Excel Workbook Shortcut Keys for Everyday Tasks

For Excel for Microsoft 365 on Windows, the most useful workbook shortcuts are Ctrl+N to create a workbook, Ctrl+O to open one, Ctrl+S to save, and Ctrl+W to close the active workbook. Use Ctrl+Page Up and Ctrl+Page Down to move between its worksheets; the sections below cover more shortcuts, Mac differences, and common snags.

Workbook shortcuts versus worksheet shortcuts

An Excel workbook is the file; it can contain multiple worksheets, each with its own grid of cells. Some shortcuts act on the file or workbook window, while others move around or change the sheets inside it. Knowing which level a shortcut affects helps prevent mistakes—for example, switching sheets does not switch to another open workbook.

Keyboard shortcuts can save time when repeated across a workday, but not every useful command has a single key combination. Excel also offers ribbon KeyTips: press Alt on Windows to display letters for ribbon tabs and commands, then press the displayed letters in sequence. These are command sequences, not necessarily simultaneous key combinations. KeyTips can vary with ribbon layout, language, or version, so follow the letters shown on your screen.

The shortcuts here are for desktop Excel on Windows unless noted. They assume a standard keyboard and the English-language ribbon. Some laptop keyboards require the Fn key for function or navigation keys.

Open, save, and close workbooks

These are the core file-management shortcuts to learn first. Saving regularly is especially helpful before making broad changes, though AutoSave may also be available for eligible cloud files.

Ctrl+N creates a new workbook. Excel uses its default new-workbook settings or template.
Ctrl+O opens the Open view, where you can browse recent files or choose a location.
Ctrl+S saves the active workbook. For a new workbook that has not been named, Excel asks where and under what name to save it.
F12 opens Save As, allowing you to choose a different name, location, or file type.
Ctrl+P opens the print view so you can review print settings and preview pages.
Ctrl+W closes the active workbook. If there are unsaved changes, Excel normally asks whether to save them.
Alt+F4 closes the Excel application on Windows, not just the active workbook. If other workbooks are open, Excel may close them too, with prompts for unsaved work.

Closing a workbook and quitting Excel are different actions. Use Ctrl+W when you want to close the current file but keep Excel available; use Alt+F4 when you intend to exit the application. If several workbooks are open, check the title bar and active window before saving or closing so you act on the intended file.

Move between worksheets and open workbooks

Within one workbook, Ctrl+Page Down activates the next worksheet tab and Ctrl+Page Up activates the previous tab. These shortcuts follow the tab order, including hidden gaps only in the sense that hidden worksheets are skipped; they do not unhide a sheet. If the workbook has only one visible worksheet, pressing the shortcut may appear to do nothing.

When more than one workbook window is open in desktop Excel for Windows, Ctrl+F6 switches to the next workbook window. Ctrl+Shift+F6 switches in the reverse direction. These shortcuts are useful when comparing two files; they do not move between worksheets in the current file. On Mac, use Excel’s Window menu to choose an open workbook window if your keyboard or macOS window settings make cycling between windows inconvenient.

For a workbook with many sheets, clicking the sheet navigation arrows at the lower-left of the window can scroll the tab strip, but scrolling the strip is not the same as activating a sheet. Right-click those navigation arrows to display a list of sheet names and choose one directly. This is often faster than pressing Page Up or Page Down repeatedly when the target sheet is far away.

Create, rename, and organize worksheets

Shift+F11 inserts a new worksheet in the active workbook. On some laptops, use Fn+Shift+F11 if the function keys are assigned to hardware controls. To rename the active sheet with the Windows ribbon KeyTips, press Alt, then H, O, and R in sequence. Type the name and press Enter. The equivalent ribbon route is Home > Format > Rename Sheet.

To move or copy a sheet, use the sequence Alt, H, O, M. Excel opens the Move or Copy dialog; choose the destination workbook and position, and select Create a copy if you want to retain the original sheet. The ribbon route is Home > Format > Move or Copy Sheet. This is different from copying cells: the command moves or duplicates an entire worksheet, including its content and many sheet-level settings.

On Mac, use the Home tab’s Format menu for renaming and moving or copying sheets; the Windows Alt-letter sequence does not translate directly. Shift+F11 can insert a sheet on Mac as well, though some keyboards require the Fn key. You can also use the plus button beside the sheet tabs to add a worksheet on either platform.

Build a reliable workbook workflow

Shortcuts are most useful as part of a predictable sequence. For example, when starting a new monthly report, create it with Ctrl+N, save it with Ctrl+S under a clear name, and add or rename sheets before entering data. While working, use Ctrl+Page Down and Ctrl+Page Up to move between input, summary, and notes sheets without reaching for the mouse.

Before a significant structural change—such as moving a sheet to another workbook—save first. A move can affect formulas that refer to the sheet, links between files, or the order in which people expect tabs to appear. If you are unsure whether you want to preserve the original, select Create a copy in the Move or Copy dialog. That choice gives you a separate sheet to inspect before removing or replacing anything.

For files stored in OneDrive or SharePoint, AutoSave may save changes continuously when it is enabled and the workbook is in a supported location. It is not a substitute for choosing a sensible file name and location, and availability can depend on the account, file format, and settings. Ctrl+S remains a useful habit: it requests a save and makes the current save state easier to confirm.

Windows, Mac, and Excel for the web

On Mac, the main file shortcuts generally use Command instead of Windows Ctrl: Command+N creates a workbook, Command+O opens one, Command+S saves, and Command+P opens print options. Command+Shift+S is the Save As shortcut in Excel for Mac. Command+W closes the active workbook window; Command+Q quits Excel.

Worksheet navigation on Mac uses Control+Page Up and Control+Page Down on keyboards that have those keys. On compact keyboards, the equivalent may require Fn with the Control and arrow keys, depending on the keyboard and macOS settings. Check the keyboard’s function-key behavior if the shortcut changes system volume or brightness instead of changing sheets.

Excel for the web runs inside a browser, so a shortcut may be handled by the browser rather than the spreadsheet. For example, Ctrl+W commonly closes the browser tab, not just the workbook. The web app supports many Excel shortcuts, but not every desktop command or KeyTip sequence behaves identically. Use the in-app menus when a shortcut is intercepted, and avoid using a browser close shortcut if you have unsaved edits.

Common shortcut problems and how to fix them

A shortcut types a character instead of running: Make sure Excel, rather than a cell editor or another window, has focus. Press Esc to leave cell-entry mode if needed, then try again.
Page Up or Page Down changes the screen, not the sheet: The worksheet shortcut needs Ctrl on Windows. A laptop may also need Fn to send the Page key.
A ribbon sequence does not work: Press Alt first and read the KeyTips that appear. KeyTip letters can differ across languages or ribbon configurations; follow the on-screen prompts rather than assuming every installation uses the same sequence.
Ctrl+W closes the wrong thing: In desktop Excel, it closes the active workbook; in a browser, it may close the tab. Confirm whether you are in desktop Excel or Excel for the web before using it.
A command seems to do nothing: The action may not apply in the current context—for example, switching sheets cannot reveal a hidden sheet, and saving may not show a dialog when the workbook already has a name and location.

Shortcuts do not bypass Excel’s confirmation prompts or file permissions. If a workbook is read-only, protected, or stored somewhere you cannot write, a save or edit can still be blocked. Resolve the access issue or use Save As to create a copy in a writable location rather than repeatedly pressing the same shortcut.

Frequently Asked Questions

What is the shortcut to switch between sheets in Excel?
On Windows, press Ctrl+Page Up for the previous worksheet or Ctrl+Page Down for the next one. On Mac, use Control+Page Up or Control+Page Down; compact keyboards may require Fn.

What is the shortcut to create a new Excel workbook?
Press Ctrl+N on Windows or Command+N on Mac. To add a worksheet inside the current workbook instead, use Shift+F11 or the plus button by the sheet tabs.

How do I save an Excel workbook with the keyboard?
Use Ctrl+S on Windows or Command+S on Mac. For Save As, use F12 on Windows or Command+Shift+S on Mac.

How do I close a workbook without quitting Excel?
In desktop Excel, press Ctrl+W on Windows or Command+W on Mac. On Windows, Alt+F4 exits Excel, while on Mac Command+Q quits the application.

Can I use Excel workbook shortcuts in a browser?
Many familiar shortcuts work in Excel for the web, but the browser can intercept some combinations. In particular, Ctrl+W usually closes the browser tab, so use the workbook’s menus when a shortcut could close the page.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.