I find the Ctrl+ PgDn/PgUpnot good enough. When I have a lot of tabs it's very annoying to get to the right tab, or move it and change the order, which is sometimes important.

I need Excel to switch between the current tab and the previous tab I worked with - regardless of their physical order. Just like windows Alt + Tab .

I guess I can build a macro that remembers my last tab and assign a shortcut to it, but I would like to know if Excel already comes with that functionality.

4 Answers 4


I don't believe Excel has a keyboard shortcut for toggling between sheets. In Excel 2007 & 2010, as a non-VBA workaround, you can create a window for each sheet that you're working on.


Let's say you were working on Sheet1 and Sheet10.

  1. Select Sheet10 and press Alt+W, N. This creates another window where Sheet10 is active. Note that at the top of the window, the file name now has a :2 after it, like so:

    enter image description here

  2. Press ALT+Tab to go back to the first window, and highlight Sheet1. Note that the first window now has a :1 after the file name at the top.

    enter image description here

You can just use good old ALT+Tab to go back and forth between the two sheets.

Note that you're not creating another instance of Excel, just a separate view for each sheet you need. So you can still add cell references, and pressing CTRL+S in either window updates the file. If you want to work on another sheet, either change the active worksheet on one of the windows, or spawn another one.

CTRL+W closes a window.

  • You are smart ...I've read so many books and somehow... the message didn't pass :) thank you very much.
    – Asaf Gilad
    May 12, 2013 at 16:35
  • +1 + to combine , if you are on Windows 7 or 8 you could also press WinLog + <<Num>> , where <<Num>> is the number of the pinned application on the taskbar .. May 18, 2014 at 18:22

Pressing CTRL+G will allow you to type in the tab & cell number you want to go to. For example, in Kaze's example spreadsheet above, if you start with the "Sheet10" tab selected, you can press CTRL+G, and in the window that pops up, type the following:


Press "OK", and it will bring you to that sheet & cell. After you've done that once, you can simply double-click the recent links you've gone to, instead of typing in the whole link.

  • Actually I think your answer is the best one providing one has first named the tables : office.microsoft.com/en-001/excel-help/…. - e.g. select table Alt , JT , A , type the name of the table ... After this Ctrl + G , type <<TableName>> , hit Enter ... - much faster than the Ctrl + PageDown , Ctrl + PgUp May 18, 2014 at 18:27
  • 1
    But (Ctrl)+(Page), (Alt)+(Tab), and (right-click) → "Activate" all remember your current position on the sheet — and even if you have cells selected.  This answer requires that you remember where you were, or at least can specify what cell you want to go to.  This could be very disruptive of work flow. Jun 19, 2015 at 20:24

Press Ctrl+Page Up or Ctrl+Page Down to navigate between worksheets in Excel.

You can also right-click on the navigation arrows in the lower left-hand corner to display an Activate menu from which you can choose a worksheet.

  • 2
    I think he said in the question that he knows that and it is not good enough .
    – Aganju
    May 18, 2016 at 22:36

Thanks for the excellent question and the excellent answers ! I am still amazed of the amount of hidden functionalities accessible only for the truly PRO users ...

Actually My answer is a complimentary one to the answer of Ethan with one major addition. I realize to late after the 5 minutes of the expiration for comments that my comment was not fully explained , thus:

Select first each table in the sheets ( Ctrl + Shift + Down , Ctrl + Shift + Left ) , format it as table tables ( Home , Format as table ) and named it according to this instruction http://office.microsoft.com/en-001/excel-help/rename-an-excel-table-HA010223129.aspx. - e.g select table Alt , JT , A , type the name of the table ...

Now enjoy: Ctrl + G , type <> , hit Enter ..- excel will jump to the <> you have predifined , much faster than the Ctrl + PageDown , Ctrl + PgUp and much more intuitive in my opinion than the "New Window" approach.

Not the answer you're looking for? Browse other questions tagged or ask your own question.