Saturday, October 30, 2004

Using the F5 Function key

Excel has a Goto function, and the shortcut is the F5 key.
Pressing this brings up a dialog box that allows you to select a named range or type in a cell reference, eg X95. This is useful if you want to select a cell in a hidden row or cell without having to unhide the row or cell. Clicking OK will take you to the required cell or range and make it active.

There is also a Special button. Clicking this brings up an advanced group of Goto options.

Some of the most useful ones include Blank Cells to select all the blank cells in an area and Formulas. Note if you want to select all the cells with a formula that results in an error then you can do this by selecting only the Errors option under Formulas.


Posted by: Jethro | 11:56 PM |