navigation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In Lotus, if you pressed crtl home you went to the first cell in the first
spreadsheet. In Excel, I can press page down or up to tab through the
worksheets. Is there a shortcut to go to the beginning or the end of the
group of worksheets?
 
One way:

Select A1 of the first sheet.
Insert>Name>Define, call the cell "aaaa" or "begin" or something short but meaningful to you

Wherever you are in your workbook, you can always press F5 and type "aaaa", ENTER to go to the first cell

--
Kind regards,

Niek Otten
Microsoft MVP - Excel
Another way is to record a macro and assign a CTRL+SHIFT key to it.

If you're new to macros, look here:

http://www.mvps.org/dmcritchie/excel/getstarted.htm

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| In Lotus, if you pressed crtl home you went to the first cell in the first
| spreadsheet. In Excel, I can press page down or up to tab through the
| worksheets. Is there a shortcut to go to the beginning or the end of the
| group of worksheets?
 
No one step shortcut that I'm aware of (but I'm not always aware of
everything).

At the lower left of the Excel window are some navigation buttons, pressing
the left-most of them takes you to the first sheet, then [Ctrl]+[Home] will
take you to first user accessible cell (usually A1, but with Window Freeze
turned on it may be another - upper left in unfrozen portion of the window).
 
Back
Top