Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

share|improve this question
up vote 16 down vote accepted

Ctrl+PgUp to move to the left.

Ctrl+PgDn to move to the right.

share|improve this answer
    
This also applies to Excel 2013 =) – Metafaniel Mar 10 at 18:53

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.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .