Print Preview is one of the most useful features of Excel. Print Preview displays, how your Excel worksheet will look after printing. Most likely, you’re aware of the easiest methods to set the Print Preview in Excel. But it becomes quite annoying when Print Preview is not available in Excel. So, let’s explore three suitable solutions to fix the issue.
Print Preview Is Not Available in Excel: 3 Possible Solutions
In the following dataset, we have the Monthly Sales Data of a company. Now, we are going to grasp 3 simple, and easy-to-use solutions if Print Preview is not available in Excel.
Not to mention that we have used Microsoft Excel 365 version for this article, you can use any other version according to your convenience.
Solution 1: Editing Page Layout Tab Options
Editing the Page Layout tab is one of the easiest ways to solve the Print Preview Not Available issue in Excel. Let’s follow the steps mentioned below to fix it.
Steps:
- Firstly, go to the Page Layout tab from the Ribbon.
- Then, select Margins from the Page Setup group.
- Afterward, choose Custom Margins from the drop-down.
After choosing Custom Margins, the following image will be available on your worksheet.
- Now, check the box Horizontally as marked in the following picture.
- After that, click OK.
- Then, click on the Orientation option from the Page Setup group.
- Afterward, select Landscape from the drop-down.
- At this stage, press the CTRL+P keyboard shortcut from your worksheet.
Note: Pressing CTRL+P will directly take you to the Print Preview page like the following image.
At this stage, if you can’t see your full dataset in the Print Preview section, you can follow the steps mentioned below to show all of your datasets on one page.
- After pressing CTRL+P, select Page Setup as marked in the image given below.
- After that, from the Page Setup dialogue box, go to the Page tab.
- Under the Page tab, adjust to your preferred scaling by increasing or decreasing the Scaling option.
- Finally, press OK.
Subsequently, you will see a proper Print Preview on your screen like the following image.
Read More: [Fixed!] Print Preview in Excel Does Not Show All Pages
Solution 2: Repairing Office Installation
Faulty Office Installation often leads to printing issues in Excel. Let’s learn the following steps to repair the Office Installation.
Steps:
- Firstly, type Control Panel in the search box in the Taskbar as marked in the following image.
- Later, click on Control Panel.
Note: Also, you can press Windows+R and then type Control Panel or something like that and choose the OK option.
Eventually, you’ll get the following interface on your screen.
- Now, select Program and Features from the Control Panel window.
- After that, scroll down until you find Microsoft 365 Apps for enterprise-en-us and click on it.
- Then, select Change as shown in the picture given below.
After that, you will see the following dialogue box on your screen.
- Now, select Online Repair from the dialogue box.
- Afterward, click on Repair.
This is a comprehensive fix and it should fix any issues with your Office Installation.
Solution 3: Modifying Page Setup Option
Modifying the Page Setup option is one of the most efficient ways to fix the Print Preview not available issue in Excel. Let’s follow the steps mentioned below.
Steps:
- After that, click on the marked portion of the following image.
Then, the Page Setup dialogue box will be available to you like the image below.
- Now, go to the Sheet tab from the Page Setup dialogue box.
- Afterward, click on the Cell errors as a drop-down and then choose <blank>.
- Finally, press OK.
- After that, press CTRL+P to go to the Print Preview Page.
Consequently, you will be able to see your Print Preview on your screen like the image below.
Read More: How to Delete Blank Pages in Print Preview in Excel
💡 Things to Remember
- While opening the Page Setup dialogue box in Solution 3, you may use the keyboard shortcut ALT+P+I to open it instantly.
Download Practice Workbook
Conclusion
Finally, we have come to the very end of the article. I sincerely hope that this article was able to guide you to fix the issue of Print Preview Not Available in Excel. Please feel free to leave a comment if you have any queries or recommendations for improving the article’s quality.
