Going to a particular cell

If you are working on a small spreadsheet, it is easy to find the cell you require (for formatting, deleting, hiding, or whatever). However, if you have a very large spreadsheet, it can be quicker to ask Spreadsheet to find the cell (or range of cells) you want.

Select the Go To command from the Edit menu. The "Go To" dialog is displayed.

In the Category box, click on the location type. The categories include typical spreadsheet locations such as cells, named ranges, columns and rows. Next, enter the location you wish to go to (you can choose most of these from the drop-down box). Then click on the OK button and the spreadsheet will be redrawn, with the location you asked for selected and active.

See also:

Moving around a spreadsheet