In Excel for Microsoft 365 on Windows, press Ctrl+Page Down to move to the next worksheet and Ctrl+Page Up to move to the previous one. Use Shift+F11 to insert a worksheet; the shortcuts below also cover selecting, renaming, and managing sheets, with notes for Mac users.
How worksheet shortcuts work
An Excel workbook can contain multiple worksheets, shown as tabs along the bottom of the window. A sheet-navigation shortcut changes which tab is active without changing the selected cell’s value. That distinction matters: Ctrl+Page Down changes worksheets, while Ctrl+Down moves within the current worksheet. Once you recognize whether a command acts on a tab, a cell, a row, or a column, it is easier to choose the right shortcut.
Most shortcuts below assume you are not actively editing a cell. If you are typing in a cell or the formula bar, press Enter to commit the entry or Esc to cancel it before trying a navigation command. Laptop keyboards may also require the Fn key for Page Up, Page Down, or function keys such as F11.
- Next worksheet: Ctrl+Page Down.
- Previous worksheet: Ctrl+Page Up.
- Insert a new worksheet: Shift+F11.
- Select the current and adjacent worksheets: Ctrl+Shift+Page Down or Ctrl+Shift+Page Up.
Move between sheets and cells
Ctrl+Page Up and Ctrl+Page Down move one tab at a time, following the workbook’s sheet order. They do not jump to the first or last sheet, and they do not scroll a long worksheet vertically. If the active tab is the last sheet, Ctrl+Page Down does not wrap around to the first; use the sheet-tab navigation arrows or click the tab you need.
Cell-navigation shortcuts are useful alongside sheet shortcuts, but they do a different job. Ctrl+Home takes you to cell A1 on the active worksheet. Ctrl+End moves to the last cell Excel considers used, which may be beyond the visible data if formatting or past edits expanded the used area. Ctrl+Arrow moves to the edge of a contiguous data region in that direction, or to the next nonblank cell when starting in a gap. These commands keep you on the same sheet.
For example, if a workbook has tabs named January, February, and March in that order, Ctrl+Page Down from January activates February. Press it again to reach March. If you then press Ctrl+Home, Excel goes to A1 on March—it does not return to January. This is a useful way to check the same cell position across monthly sheets without confusing tab movement with cell movement.
Select rows, columns, and multiple worksheets
Selection shortcuts help when you want to apply an action to a whole row or column, or to make the same change on several sheets. In a normal worksheet cell, Ctrl+Space selects the entire column and Shift+Space selects the entire row. In an Excel table, selection behavior can differ because the table has its own structured rows and columns.
To select adjacent sheet tabs, click the first tab, then hold Shift and click the last tab. To select separate tabs, hold Ctrl while clicking each one. The active sheet remains part of the selection. You can also extend a selection from the current tab with Ctrl+Shift+Page Down or Ctrl+Shift+Page Up, which adds the next or previous sheet to the group.
Grouped worksheets can be useful when several sheets share the same layout. For instance, selecting three monthly sheets and entering a heading in the same cell can put that heading on all three. But edits, formatting, and some other commands may apply to every selected sheet, not just the active one. Check the selected tabs before making changes; grouped tabs are visibly highlighted. To stop grouping, click a sheet outside the group or right-click a selected tab and choose Ungroup Sheets.
Insert, rename, move, and delete sheets
Shift+F11 inserts a new worksheet, generally next to the active sheet. On Windows, another option is the New Sheet plus button beside the sheet tabs. The plus button is convenient when function-key behavior is awkward, while Shift+F11 is quick if your hands are already on the keyboard.
Windows Excel also provides KeyTip sequences for sheet commands. Press Alt, then the listed letters in order; these are ribbon navigation keys, not simultaneous key combinations:
- Rename the active sheet: Alt, H, O, R. Type the new name and press Enter.
- Open Move or Copy Sheet: Alt, H, O, M. Choose a destination workbook or position; select Create a copy if you want to keep the original sheet.
- Delete the active sheet: Alt, H, D, S. Confirm the prompt if Excel asks you to do so.
Double-clicking a sheet tab is another quick way to rename it. Right-clicking a tab opens a menu with commands such as Insert, Delete, Rename, Move or Copy, and Tab Color. Deleting a sheet is not the same as clearing its cells: deletion removes the worksheet itself and its contents. Excel may offer an undo option immediately afterward, but save a copy first if the sheet contains important information.
Shortcuts for common worksheet tasks
Combining a few commands can make routine workbook work faster. These examples use ordinary worksheet tabs and assume the relevant sheet is already active:
- Add a sheet and label it: press Shift+F11, then Alt, H, O, R; type a clear name such as “Q2 Summary” and press Enter.
- Review matching cells across sheets: navigate with Ctrl+Page Up or Ctrl+Page Down, then use Ctrl+Home if you want to compare the top-left cell on each sheet.
- Apply the same entry to several sheets: select adjacent or separate tabs, enter the value in the intended cell, and commit it. Confirm that the tabs are still grouped before making further edits.
- Keep a sheet while placing a duplicate elsewhere: open Move or Copy Sheet, choose the destination, and check Create a copy before confirming.
For cell operations, Ctrl+Z undoes many recent actions, but it should not replace careful use of sheet commands. In particular, check whether multiple tabs are selected before typing, formatting, deleting rows, or pasting. A small visual check can prevent an edit from spreading across a group of worksheets.
Windows and Mac differences
The shortcuts in this guide are primarily for Excel for Microsoft 365 on Windows. In Excel for Mac, Control+Page Down and Control+Page Up move between worksheets on keyboards that provide those keys. On a MacBook keyboard without dedicated Page Up and Page Down keys, you may need to use Fn with the relevant arrow-key combination; the exact key behavior can depend on the keyboard and macOS settings.
Shift+F11 inserts a worksheet in Excel for Mac as well, though some keyboards require Fn+Shift+F11 because the function keys control hardware features by default. Ribbon KeyTip sequences such as Alt, H, O, R are specific to Windows and should not be assumed to work the same way on a Mac. On Mac, use the sheet-tab context menu or the Excel ribbon to rename, move, or delete a sheet. If a shortcut is intercepted by macOS, check the keyboard shortcuts configured in macOS and Excel.
Excel for the web runs in a browser, where some shortcuts may be handled by the browser or differ from the desktop application. If a key combination opens a browser feature instead of acting in Excel, use the sheet-tab controls or consult the shortcut help for the web version. The same principle applies when using a remote desktop: the local computer may capture a key before Excel receives it.
Common problems and practical checks
If Ctrl+Page Up or Ctrl+Page Down appears not to work, first check whether the cell is in edit mode and whether your keyboard has separate Page keys. Finish or cancel cell editing, then try adding Fn if your laptop requires it. Also confirm that Excel has focus; a browser window, dialog box, or another application may be receiving the keystrokes.
If a shortcut changes more sheets than expected, look for grouped tabs. Multiple selected worksheets can make ordinary edits apply to each selected sheet. Click a single sheet tab to return to working on one worksheet. If a sheet seems to be missing, it may be hidden rather than deleted; right-click a visible tab and choose Unhide to check for hidden worksheets. A protected workbook or sheet can also limit which actions are available.
Finally, Ctrl+End may land far below or to the right of your actual data. Excel’s used range can include cells that were previously formatted or edited. This is a cell-range issue, not a sheet-navigation problem. Inspect the area, remove unwanted formatting or content if appropriate, and save the workbook; Excel’s used-range behavior may update after changes and reopening.
Frequently Asked Questions
What is the shortcut to switch sheets in Excel?
On Windows, press Ctrl+Page Down for the next worksheet or Ctrl+Page Up for the previous one. On Mac, use Control with Page Down or Page Up where those keys are available.
How do I add a new sheet without using the mouse?
Press Shift+F11 in Excel for Microsoft 365 on Windows. On some laptops, hold Fn as well. Excel for Mac also supports Shift+F11, subject to the keyboard’s function-key settings.
How do I select multiple sheets with the keyboard?
From the active sheet, press Ctrl+Shift+Page Down to add the next sheet to the selection, or Ctrl+Shift+Page Up to add the previous one. Use Ctrl-click or Shift-click on tabs when you need to choose nonadjacent or a wider range of sheets.
What is the difference between Ctrl+Page Down and Ctrl+Down?
Ctrl+Page Down activates the next worksheet tab. Ctrl+Down moves the active cell within the current worksheet, usually to the edge of a contiguous data region or to the next nonblank cell below.
Can I undo deleting an Excel sheet?
Excel may let you undo a deletion immediately with Ctrl+Z, but you should not rely on that as your only safeguard. Save a copy before deleting an important sheet, especially if the workbook contains valuable data or later actions may make the deletion difficult to reverse.
Related
- Excel Power Query Merge Table Types and When to Use Them
- Excel Power Query: Enable Background Refresh
- Excel Power Query: Delete Duplicate Rows
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Schedule an Email in Outlook on Any Device TodayTo schedule an email in Outlook, write your message, open the menu beside Send, choose a scheduling option,…
- Excel Row Height Shortcut: Set or AutoFit RowsIn Excel for Microsoft 365 on Windows, press Alt, H, O, H in sequence to open the Row…
- Data Slicer in Excel: How to Add and Use OneA data slicer in Excel is a clickable on-sheet control that filters a table or PivotTable by the…
- How to Double Space in Word: Steps, Tips, and FixesTo double-space text in Word, select the text—or press Ctrl+A on Windows or Command+A on Mac to select…
- What Does an Excel Heat Map Look Like?An Excel heat map looks like a range of spreadsheet cells filled with different colors to show how…
- Excel File Corrupted? Recovery Steps That WorkIf an Excel file is corrupted and cannot be repaired, stop working on the original, make a separate…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.