GIRISH_ EXCEL FREAK
New Member
Shortcut to move to the last sheet or first sheet in an excel file when there are more sheets in a file.
What is the shortcut in excel ?
- Thread starter GIRISH_ EXCEL FREAK
- Start date
Khalid NGO
Excel Ninja
Hi,
You can use any shape as Hyperlink to First/Last Sheet.
eg: insert a shape in First Sheet and Hyperlink to last sheet,
insert a shape in Last Sheet and Hyperlink to first sheet.
or you can use GO TO:
suppose you are at cell A1 of sheet1
press F5 (Go To)
Type:
Sheet3!a1
Regards,
You can use any shape as Hyperlink to First/Last Sheet.
eg: insert a shape in First Sheet and Hyperlink to last sheet,
insert a shape in Last Sheet and Hyperlink to first sheet.
or you can use GO TO:
suppose you are at cell A1 of sheet1
press F5 (Go To)
Type:
Sheet3!a1
Regards,
alacrity59
Member
Nice tips.
Occasionally I receive a spreadsheet that has many many tabs. Some Excel developer must have been thinking of me when they added the ability to right click the scrolling arrows at the bottom left corner of the spreadsheet to bring up a list of all the tabs to select from. From there it is fairly quick to navigate to the first or last spreadsheet in a workbook.
Perhaps not the exact subject at hand but sometimes I'm working on a spreadsheet and need to flip between two tabs that are not positioned right before or after each other. In this case I close all other spreadsheets then go under view and open a new window. I select the second tab I'm working with and then flip between the two tabs with Ctrl+Tab.
Occasionally I receive a spreadsheet that has many many tabs. Some Excel developer must have been thinking of me when they added the ability to right click the scrolling arrows at the bottom left corner of the spreadsheet to bring up a list of all the tabs to select from. From there it is fairly quick to navigate to the first or last spreadsheet in a workbook.
Perhaps not the exact subject at hand but sometimes I'm working on a spreadsheet and need to flip between two tabs that are not positioned right before or after each other. In this case I close all other spreadsheets then go under view and open a new window. I select the second tab I'm working with and then flip between the two tabs with Ctrl+Tab.