Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
navigation
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
navigation
One way:
Select A1 of the first sheet. InsertNameDefine, 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 he http://www.mvps.org/dmcritchie/excel/getstarted.htm -- Kind regards, Niek Otten Microsoft MVP - Excel "Pam M" wrote in message ... | 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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
navigation
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). "Pam M" wrote: 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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
navigation
Great idea--thanks!
"Niek Otten" wrote: One way: Select A1 of the first sheet. InsertNameDefine, 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 he http://www.mvps.org/dmcritchie/excel/getstarted.htm -- Kind regards, Niek Otten Microsoft MVP - Excel "Pam M" wrote in message ... | 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Navigation | Excel Discussion (Misc queries) | |||
Navigation | Excel Worksheet Functions | |||
navigation between worksheets | Excel Discussion (Misc queries) | |||
Navigation help please | New Users to Excel | |||
slow navigation | Excel Discussion (Misc queries) |