Alternating between sheets of same workbook
 

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

Hi Lourens

Ctrl-PageUP and PageDown

See also
http://www.contextures.com/excel.htm



--
Regards Ron de Bruin
http://www.rondebruin.nl


"Lourens" wrote in message ...
Hi
Is there a keyboard way of switching between sheets of the same Excel
workbook, like Ctrl+TAB switches between windows

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).

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Lourens" wrote in message
...
Hi
Is there a keyboard way of switching between sheets of the same Excel
workbook, like Ctrl+TAB switches between windows

Yes.

Ctrl+Page Down (Page Up)
--
Cordially,

Bob Sullivan
Microsoft Office Master Instructor


"Lourens" wrote:

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