Home » Questions » Computers [ Ask a new question ]

Keyboard shortcut to switch between sheets in Excel

Keyboard shortcut to switch between sheets in Excel

Does Excel 2007 have a keyboard shortcut that switchs between worksheets?

Asked by: Guest | Views: 290
Total answers/comments: 2
Guest [Entry]

"Ctrl+PgUp to move to the left.

Ctrl+PgDn to move to the right."
Guest [Entry]

"You can also use accelerator keys to get to the Go dialog box. You can then type something like foo!A1 to navigate to the top left cell in the sheet named ""foo"". While page up and page down are generally quicker. If you have a large number (e.g., 20+) of well named sheets, this may be quicker. Go also works well if you have named tables in your sheets.

Pressing F5 normally opens the Go dialog box."