Alternating between sheets of same workbook

L

Lourens

Hi
Is there a keyboard way of switching between sheets of the same Excel
workbook, like Ctrl+TAB switches between windows
 
B

Bernard Liengme

Taken from Excel's Help with search word "Shortcuts"
SHIFT+F11 or ALT+SHIFT+F1
Insert a new worksheet.
CTRL+PAGE DOWN
Move to the next sheet in the workbook.
CTRL+PAGE UP
Move to the previous sheet in the workbook.
SHIFT+CTRL+PAGE DOWN
Select the current and next sheet. To cancel selection of multiple sheets,
press CTRL+PAGE DOWN or, to select a different sheet, press CTRL+PAGE UP.
SHIFT+CTRL+PAGE UP
Select the current and previous sheet.
ALT+O H R
Rename the current sheet (Format menu, Sheet submenu, Rename command).
ALT+E M
Move or copy the current sheet (Edit menu, Move or Copy Sheet command).
ALT+E L
Delete the current sheet (Edit menu, Delete Sheet command).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top