- Worldstart's Tech Tips And Computer Help - http://www.worldstart.com -

The Wonders Of F2 In MS Excel

Posted By On November 23, 2004 @ 12:33 PM In MS Excel | Comments Disabled

The Wonders Of F2 In MS Excel

When you’re working in Excel and you need to edit something that is already in a cell what do you do?

Do you click on the cell, then click into the formula bar to edit the contents?

Sounds like a lot of clicking?

Yeah, it did to me too.

For people who don’t really care for their mouse, it can turn into a living, breathing, clicking nightmare.

Want a way to get into the cell contents and edit without the mouse?

Yes? (I thought that at least some of you might.)

Next time you need to edit a cell, simply select it. If you want to avoid the mouse try navigating with Page Up, Page Down and the arrow keys.

Now hit the F2 key.

If the cell contained a formula then you should now see it displayed right there in the cell and you have a cursor for editing.

If the cell contained text or numeric data then you can see all the text or the data with a cursor as well.

When you finish your editing simply hit the Enter key to have Excel accept your changes.

Now that you’ve awaken from your nightmare—Happy Editing!


Article printed from Worldstart's Tech Tips And Computer Help: http://www.worldstart.com

URL to article: http://www.worldstart.com/the-wonders-of-f2-in-ms-excel/