How do i switch between sheets on Excel?

Question

I mean we press ALT TAB to switch between windows so how do we sitch between sheet 1, sheet 2 etc while working in Excel using the keyboard.
Thanks

Answer 1

as a default, im using CTRL+PageUp/ CTRL+PageDown to switch between worksheets. its a lot of help and i can work faster 'cus there's no more hassles of putting ur right hand on the mouse, then on the keyboard, then on the mouse again... its faster 'cus im only using the keyboard alone.

Answer 2

Control Tab will move between open workbooks
Control Page Up/Down will move between sheets in a workbook

Answer 3

u can either left click on the sheets(bottom of the document) in the excel document or hold down ctrl key and press page up/page down button

Answer 4

Well, I didn't know that CTRL PageUp and CTRL PageDown did that.

I have always written a VBA Macro for it

something like what is shown below:

Sub next_sheet()

i = ActiveSheet.Index
i = i + 1

If i > Sheets.Count Then
i = 1
End If

Sheets(i).Select

End Sub

Answer 5

Click on the tab where it lists the number of pages - automatic

Answer 6

while only using the keyboard???

hmmm, im not sure..