In Excel for Microsoft 365 on Windows, press Alt, release it, then press W and Q to open the Zoom dialog. Use the keyboard to select a preset or enter a percentage, then press Enter. Repeat the sequence whenever you want to change the worksheet’s on-screen magnification; zoom changes how large cells look, not the values or print size.
The steps below use Excel for Windows. Excel for Mac and Excel for the web have different keyboard behavior, so those options are covered as well. Save your workbook first if you are making other edits, although changing zoom alone does not alter cell data.
What You’ll Need
- Excel for Microsoft 365 on a Windows computer, with a workbook open.
- A worksheet that is not in a mode that prevents normal ribbon access. If a cell is being edited, finish or cancel the edit first.
- A zoom level in mind. Excel accepts values from 10% to 400%, and common choices such as 75%, 100%, and 125% are convenient starting points.
Step-by-Step
-
Open the worksheet you want to adjust. Zoom is normally set for the active worksheet, so first click a cell on the sheet you intend to view. If you have multiple worksheets selected as a group, be aware that changes may apply to all selected sheets. Click a single sheet tab if you want to avoid changing a group.
-
Finish any cell edit. If the insertion point is inside a cell or the formula bar, press
Enterto commit the edit orEscto cancel it. The ribbon key sequence may not work as expected while Excel is editing a cell, because key presses can be treated as cell content. -
Open the Zoom dialog with the ribbon keys. Press and release
Alt, then pressW, thenQ. Think of this as three sequential key presses, not a single chord. In standard English-language Excel for Windows,Wopens the View tab’s Key Tips andQselects Zoom. If a Key Tip appears on screen that differs, follow the displayed letter for the Zoom command; key tips can vary with language or ribbon changes. -
Choose a preset or a custom value. In the Zoom dialog, use the arrow keys to move among available preset choices, such as 75%, 100%, or 200%, and select the one you want. For an exact value, use
TaborShift+Tabto move focus to the Custom percentage field, type a number such as110, and check that Custom is selected if the dialog requires it. Do not type a percent sign unless the field accepts it; entering just the number is the simplest approach. -
Apply the new zoom level. Press
Enterto confirm the selected preset or custom percentage. The dialog closes and the active worksheet redraws at the chosen magnification. If focus is on a dialog button rather than the percentage field, useTabto reach the appropriate control before confirming. -
Zoom out when more of the sheet needs to fit on screen. Repeat
Alt,W,Q, choose a smaller preset or enter a lower number such as80, and pressEnter. A smaller zoom can reveal more columns and rows at once, though the text and controls will also appear smaller. -
Zoom in when cell contents are hard to read. Open the same dialog and choose a higher preset or enter a larger number such as
125. If you want to return to the usual baseline, use the dialog to set 100%. The change is a display preference, not a change to font size, row height, column width, or the workbook’s underlying data.
As a practical example, if a worksheet is currently at 100% and the text is uncomfortable to read, set it to 125%. If that makes too few columns visible, try 110% or 105% instead. A few percentage points can make a useful difference on a smaller laptop screen.
Common Mistakes
-
Holding all the keys at once. The Windows command is a sequence: press and release
Alt, then pressW, thenQ. HoldingAltwhile pressing the other keys is not the intended sequence and may trigger a different command. -
Assuming zoom changes print size. Worksheet zoom only changes the view on your screen. To change how a sheet fits on printed pages, use the Page Layout settings or print settings instead; changing the Zoom dialog does not resize printed text.
-
Confusing zoom with font size. Raising zoom makes everything in the worksheet appear larger, including cells and gridlines. It does not increase the font size stored in the cells. Use the Home tab’s font-size control if you need the text itself to be larger for everyone who opens the file.
-
Changing several grouped sheets unintentionally. If multiple sheet tabs are selected, Excel may apply changes to the group. Check the sheet tabs before adjusting zoom and ungroup them by selecting a single worksheet tab.
-
Typing into the worksheet instead of the dialog. If the Zoom dialog did not open, a number you type may go into the active cell. Confirm that the dialog is visible before entering a custom percentage.
Tips
-
Use a sensible starting range. Try 100% first, then adjust in small steps. Around 90% to 110% often balances readable text and visible columns, but the best level depends on screen resolution, workbook layout, and your eyesight.
-
Use Zoom to Selection for a focused view. In the Zoom dialog, choose Fit Selection when you have selected a range and want Excel to enlarge that range to fill the available worksheet area. This is useful for presenting a small table, but it may produce a very high zoom if the selection is tiny.
-
Know the non-keyboard controls too. The status bar at the bottom-right of the Excel window has zoom controls, including a percentage display and a slider. These are handy if you forget the key sequence, but the Zoom dialog is better when you need to enter an exact percentage.
-
Try Ctrl plus the mouse wheel only if a mouse is available. In many Windows desktop versions of Excel, holding
Ctrlwhile scrolling the mouse wheel changes worksheet zoom. This is a mouse-based alternative, not a keyboard-only shortcut, and a touchpad or accessibility setting may behave differently. -
Keep a familiar level for routine work. A moderate zoom makes it easier to compare a broad table without constantly scrolling. When reviewing a dense section, temporarily zoom in, then return to a comfortable overview level rather than changing the workbook’s cell formatting.
Troubleshooting
Nothing happens after Alt, W, Q. Make sure you pressed the keys in order and released each one before the next. Check that Excel, rather than another application, is active, and exit cell-edit mode. Press Alt by itself to see whether Key Tips appear. If they do, use the letters shown on your screen for the View tab and Zoom command; the letters can differ in localized editions or customized ribbon layouts.
The dialog opens but the number does not change. Use Tab and Shift+Tab to move through the dialog controls and confirm that focus is in the Custom field. Enter a number from 10 through 400, select the Custom option if needed, and press Enter. If the value is outside that range, Excel may reject it or leave the previous setting in place.
The sheet looks unchanged. Check the percentage shown on the status bar or reopen the Zoom dialog to verify the setting. A small change, such as 100% to 105%, can be subtle. Also check whether the active sheet is the one you intended to change and whether the workbook window is maximized or has panes that make the visible area look different.
You are using Excel for Mac. The Windows Alt, W, Q sequence is not the Mac shortcut. Use the macOS menu bar and choose View > Zoom if that command is available in your Excel version, then select a preset or custom percentage. macOS menu-bar keyboard navigation depends on system settings, so there is not one universal Mac key sequence to substitute. If necessary, open the menu with the mouse or trackpad.
You are using Excel for the web. Ribbon access keys can depend on the browser and may not match desktop Excel. Use the View tab’s Zoom control if it is available in your current web layout, or use the zoom control on the status bar. Browser page zoom is different: it enlarges the entire Excel web page, including the ribbon, rather than changing only the worksheet view.
Frequently Asked Questions
What is the keyboard shortcut to zoom in Excel on Windows?
Press and release Alt, then press W and Q to open the Zoom dialog. Pick a higher percentage and confirm with Enter.
How do I zoom out using only the keyboard?
Use Alt, W, Q, choose a smaller preset or enter a lower custom percentage, and press Enter. For instance, choose 80% to see more of a wide sheet at once.
Can I zoom with the plus or minus key?
Excel does not provide a standard standalone plus-or-minus keyboard shortcut for worksheet zoom. Use the Zoom dialog sequence on Windows, or the status bar controls. Do not confuse this with browser zoom in Excel for the web.
Does Excel remember the zoom level?
Excel generally saves the view setting with the workbook and may retain different zoom settings for individual worksheets. If you share a file, the recipient’s screen and Excel version can affect how comfortable that saved level looks to them.
Why does the worksheet look different when I print it?
Worksheet zoom is for on-screen viewing and does not control print scaling. Check Print Preview and the Page Layout or print scaling options to see how rows and columns will fit on paper.
What zoom percentage should I use?
There is no single correct value. Start at 100%, then raise it for readability or lower it to fit more columns and rows. The 10% to 400% range gives you room to tailor the view to your screen and task.
Related
- Excel Custom Number Format: How to Create and Apply It
- How to Select a Sheet in Excel With Keyboard Shortcuts
- Select in Excel Without Scrolling: Fast, Simple Methods
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Highlight Duplicates in Google Sheets: How to Do ItYes. In Google Sheets in a web browser, choose Format > Conditional formatting, select the cells to check,…
- Google Excel Timesheet Template: Sheets or Excel?If you are looking for a Google Excel timesheet template, the practical option is usually a Google Sheets…
- Excel Merge Cell Shortcut: Keys and Safe AlternativesIn Excel for Microsoft 365 on Windows, press Alt, H, M, C in sequence to merge the selected…
- Import CSV into Excel on Mac: A Step-by-Step GuideTo import a CSV into Excel on a Mac, open Excel and choose Data > Get Data (Power…
- How to Delete Only Visible Rows in Excel Without Hidden DataTo delete only visible rows in Excel, filter or hide the rows you want to keep, select the…
- Excel Data Validation Default Value ExplainedExcel data validation has no setting that automatically chooses a default value for a cell. To give a…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.