How to Fix a Grayed-Out Print Preview Command in Excel
Question details
The Print Preview command added to the Quick Access Toolbar is unresponsive and grayed out.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Attempting to use a customized shortcut on the Quick Access Toolbar to preview a workbook before printing.
- Observed behavior
- The Print Preview command icon appears on the Quick Access Toolbar but is grayed out and cannot be clicked, even though other commands work normally.
Ensure that you have an active workbook open in Excel and that a default printer is properly installed on your system, as print commands will remain disabled if no document is active or no printer driver is found.
Replace the Disabled Command on the Quick Access Toolbar
Remove the incorrect or unsupported Print Preview command and replace it with the fully functional 'Print Preview and Print' option.
Often, users accidentally add an older legacy version of the Print Preview command that is no longer supported by the modern Office interface. Swapping it for the correct command restores functionality.
Go to File > Options, and then select 'Quick Access Toolbar' from the menu on the left side of the dialog box.
In the list on the right side, locate the currently disabled 'Print Preview' command, select it, and click the 'Remove' button.
From the 'Choose commands from' dropdown menu on the left, select 'Popular Commands' or 'All Commands'. Scroll down to find 'Print Preview and Print', select it, and click 'Add'.
Click 'OK' to save your changes. Restart Excel, open a workbook, and verify that the new command icon is active and functional.
Add Print Preview to a Custom Ribbon Group
If customizing the Quick Access Toolbar continues to fail, adding the command directly to a custom group on the main Ribbon is a reliable workaround.
Use the Built-In File Menu Alternative
Use the standard backstage view as an immediate alternative to customized toolbar buttons.
Easily Preview and Print Spreadsheets in WPS Office
Avoid dealing with customized toolbar errors and legacy commands. WPS Spreadsheets provides a straightforward, flawlessly integrated Print Preview feature right out of the box, allowing you to format and print your work without frustration.
- 1. Open your file in WPS Spreadsheet: Launch WPS Office and open your spreadsheet document.
- 2. Access the main menu: Click the 'Menu' button in the top-left corner of the application.
- 3. Select Print Preview: Hover over 'Print' and click on 'Print Preview' to instantly verify your page layouts and margins before printing.
Frequently Asked Questions
Why is the Print Preview button grayed out even after I add it?
This usually happens because the older, unsupported 'Print Preview Full Screen' command was added instead of the modern 'Print Preview and Print' command. Legacy commands are often disabled in the newer Office ribbon interface.
Can a missing printer driver cause the Print Preview to be disabled?
Yes. Excel relies on your default printer's driver to calculate page margins and layout. If no printer is installed or the current driver is corrupted, the application cannot generate a preview and will gray out the print-related options.
Is there a fast keyboard shortcut for Print Preview in Excel?
Yes, pressing Ctrl + P or Ctrl + F2 on your keyboard will instantly open the Print menu, which automatically displays the document's Print Preview on the right side of your screen.
Will customizing the Quick Access Toolbar apply to all my Excel files?
Yes, by default, Quick Access Toolbar customizations apply to all workbooks. When you add the correct command, make sure 'For all documents' is selected in the customization dialog box.
