Excel Open Shortcut Keys for Windows and Mac Users

In Excel for Microsoft 365 on Windows, press Ctrl+O to open the Open screen, or press Ctrl+F12 to go straight to the file-opening dialog. On a Mac, press Command+O. These shortcuts work when Excel is active; they help you open a workbook, not launch Excel itself.

The basic Excel open shortcuts

The quickest general-purpose shortcut on Windows is Ctrl+O. It takes you to Excel’s Open area, where you can choose a recent workbook or browse for a file. This is useful when you are already working in Excel and want to switch workbooks, reopen a file, or start with a different spreadsheet.

If you know you want to browse for a file on your computer, Ctrl+F12 is a more direct route. It opens the file-selection dialog without first making you choose an item from the Open screen. Depending on your keyboard, you may need to hold the Fn key as well to send F12; laptop function-row settings differ.

On Excel for Mac, use Command+O to open a workbook. The Mac shortcut uses the Command key rather than Control. If you use an external keyboard or a remote desktop, check which system is receiving the keystroke: the computer running Excel, rather than the keyboard’s physical location, determines the shortcut.

What Ctrl+O and Ctrl+F12 do differently

Both Windows shortcuts lead to the same basic task, but the route is different. Ctrl+O opens Excel’s Open screen, which can show recent files and locations. From there, you can select a listed workbook or choose a browse option to find another one. It is a good default when you are not yet sure where the file is stored.

Ctrl+F12 skips that hub and displays the Open dialog for browsing. It is often convenient when you know the folder or filename and want to navigate directly. A dialog may initially show a suggested folder or recent location, so use its navigation pane or address bar to move elsewhere if needed.

Neither shortcut is the same as saving. In Excel for Windows, Ctrl+S saves changes to the current workbook, while F12 opens Save As. Confusing F12 with Ctrl+F12 is an easy mistake: the Control key changes the action from saving a copy or choosing a save location to opening a workbook.

Open a recent workbook quickly

For a file you have opened recently, start with Ctrl+O on Windows and look in the Recent list. Select the workbook name to open it. The list is especially useful when a file lives in a cloud location or a deeply nested folder, because you do not have to repeat the full folder navigation.

Recent items are shortcuts to files, not separate copies of their contents. If a workbook has been moved, renamed, deleted, or become unavailable because a network or cloud location is disconnected, its entry may no longer open. In that case, browse to the file’s current location rather than repeatedly selecting the stale recent entry.

Excel may let you pin a frequently used item in its recent list. Pinning keeps that entry easier to find; it does not lock the workbook or prevent other people from changing it. The exact appearance of the list can vary with Excel’s build, account, and connected storage locations.

Browse to a workbook by folder or filename

If the workbook does not appear in Recent, use the browse route. On Windows, press Ctrl+F12, or use Ctrl+O and choose Browse. In the file dialog, move to the folder that contains the file, select it, and choose Open. If you know part or all of the filename, typing it into the dialog’s file-name field can be faster than opening folders one at a time.

Check the folder shown in the dialog and change it if necessary.
Use the navigation pane, address field, or filename search available in the dialog to locate the workbook.
Select the intended file and confirm that its name and file type look right.
Choose Open. If Excel displays a warning or a read-only message, read it before deciding how to proceed.

Excel workbooks commonly use extensions such as .xlsx, .xlsm, and .xls. A macro-enabled workbook normally uses .xlsm; opening it does not mean you should automatically enable its macros. If you cannot see a file, check whether the dialog’s file-type filter is hiding that format, and verify that you are browsing the correct folder or drive.

Use the keyboard after opening the Open screen

The shortcuts can reduce mouse use, but they do not mean every part of the file dialog has one universal keystroke. After Ctrl+O, use the visible focus, Tab, arrow keys, and Enter to move among available controls. In the file dialog, use the filename field or folder list as appropriate, then confirm the selected workbook with Enter or the dialog’s Open button.

Keyboard focus matters. If typing a filename appears to do nothing, the cursor may be in a different control, such as the file list or a search box. Press Tab to move focus, or click the intended field once and then type. The available controls and their order can differ between Windows versions and dialog layouts, so watch the on-screen focus indicator rather than relying on a long sequence of blind keystrokes.

After a workbook opens, Excel may place the cursor in a cell, show a Protected View banner, or display a prompt about links or file formats. Those are separate from the open shortcut itself. Read any prompt and make a deliberate choice; pressing the shortcut again will not resolve a warning or change the workbook’s trust status.

Opening Excel is different from opening a workbook

Ctrl+O works after Excel is running and has focus. It does not start the Excel application from the Windows desktop. To launch Excel, use the Windows Start menu or taskbar, or open a workbook through File Explorer. On a Mac, launch Excel from Finder, Launchpad, or the Dock, or open a workbook in Finder.

Double-clicking a workbook in File Explorer or Finder is another common way to open it. If Excel is installed and associated with that file type, the workbook normally opens in Excel. If another application opens instead, the file association may be set differently. You can also open Excel first and then use its keyboard shortcut, which gives you more control over the route and the selected file.

This distinction helps explain why a shortcut may seem not to work: pressing Ctrl+O while a browser, email program, or another application is active sends the shortcut to that application. Click the Excel window or switch to it before using the Excel shortcut.

Mac and Excel for the web differences

For Excel for Microsoft 365 on Mac, the usual open-workbook shortcut is Command+O. Windows instructions that use Ctrl+O or Ctrl+F12 should not be assumed to work identically on Mac. Mac dialogs and menu labels can also differ, even though the core task—selecting a workbook and opening it—is the same.

Excel for the web runs inside a browser, so keyboard shortcuts can interact with the browser or operating system as well as Excel. Web workbooks are generally opened from the Excel start page, OneDrive, SharePoint, or the location where the file is stored. To work with a local file, use the web app’s available upload or open-file workflow rather than assuming the desktop Excel file dialog will appear from Ctrl+O.

If you switch between desktop and web Excel, look at the application name and window before using a shortcut. A shortcut documented for the Windows desktop app may be intercepted or have a different result in a browser. The browser’s own Open command, for example, is not a substitute for selecting a workbook within Excel for the web.

Common problems and how to fix them

The shortcut does nothing: Make sure Excel is active. On a compact keyboard, try holding Fn with Ctrl+F12 if the function keys control brightness, volume, or other hardware settings.
A different window appears: The keystroke may have gone to another app. Switch to Excel and try again. In a remote desktop or virtual machine, confirm that keyboard input is being sent to the computer running Excel.
The workbook is missing: Check Recent, then browse to its current folder. Confirm the spelling, file extension, and storage location; the file may have been moved or saved under a different name.
The file appears unavailable: Reconnect to the relevant network or cloud account, or use a local copy if one exists. A recent-list entry can remain after the original location has changed.
Excel shows a warning: Treat security prompts, Protected View, and external-link notices as separate decisions. Do not enable macros or trust a file merely to get past the opening process unless you know the source and need the content.

For a damaged or unusually large workbook, opening may take time even after the shortcut works correctly. Avoid pressing the shortcut repeatedly, which can open additional dialogs or make it harder to see the original one. Wait for Excel to respond, check for a confirmation prompt, and try a known-good workbook if you need to determine whether the issue affects one file or Excel generally.

Related shortcuts worth knowing

A few nearby shortcuts make workbook navigation easier once the file is open. On Windows, Ctrl+N creates a new blank workbook, Ctrl+S saves the current workbook, and Ctrl+W closes the current workbook window. These are not interchangeable: closing a workbook is different from exiting Excel, and saving does not create a new workbook.

On Mac, common equivalents include Command+N for a new workbook, Command+S to save, and Command+W to close the current window. Keyboard mappings can be affected by macOS settings, keyboard layout, or remote-access software. If a shortcut behaves unexpectedly, use Excel’s menus to confirm the intended command and check the shortcut list for the version you are using.

One useful routine is to open with Ctrl+O, save with Ctrl+S as you work, and close with Ctrl+W when finished on Windows. On Mac, use the corresponding Command-key shortcuts. This routine does not replace a backup: saving changes the workbook at its current location, so use a separate copy when you need to preserve an original.

Frequently Asked Questions

What is the shortcut key to open a file in Excel?
On Windows, press Ctrl+O to reach the Open screen, or Ctrl+F12 to open the file-browsing dialog directly. On Mac, press Command+O.

Does Ctrl+O open Excel?
No. It opens the workbook-opening interface inside Excel when the app is active. To launch Excel itself, start it from the Windows Start menu, the Mac Dock, Finder, or another app launcher.

What is the difference between Ctrl+O and Ctrl+F12 in Excel?
Ctrl+O takes you to Excel’s Open area, which can include recent workbooks and browse options. Ctrl+F12 goes directly to the Windows Open dialog, making it useful when you want to browse for a file immediately.

What is the open shortcut in Excel on a Mac?
Use Command+O in the Mac desktop app. Do not substitute the Windows Control-key shortcut unless your specific setup or remote environment explicitly maps it that way.

Why does Ctrl+O not work in Excel?
Excel may not have focus, the workbook dialog may already be open, or another program may be receiving the keys. Click or switch to the Excel window, check your keyboard’s function-key behavior for Ctrl+F12, and try the Open command from Excel’s File menu if needed.

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.