Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

[Fixed!] Print Preview Not Available in Excel

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.


Download Practice Workbook


3 Possible Solutions If Print Preview Is Not Available in Excel

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.

print preview 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.

print preview not available in excel Editing Page Layout Tab Options

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.

print preview not available in excel Editing Page Layout Tab Options

  • Then, click on the Orientation option from the Page Setup group.
  • Afterward, select Landscape from the drop-down.

print preview not available in excel Editing Page Layout Tab Options

  • 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.

print preview not available in excel Editing Page Layout Tab Options

  • 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.

print preview not available in excel Editing Page Layout Tab Options

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.

print preview not available in excel Repairing Office Installation

Note: Also, you can press Windows + R and then type Control Panel or something like that and choose the OK option.

print preview not available in excel Repairing Office Installation

Eventually, you’ll get the following interface on your screen.

  • Now, select Program and Features from the Control Panel window.

print preview not available in excel Repairing Office Installation

  • 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 selecting Change, you will see the following dialogue box on your screen.

print preview not available in excel Repairing Office Installation

  • Now, select Online Repair from the dialogue box.
  • Afterward, click on Repair.

print preview not available in excel Repairing Office Installation

This is a comprehensive fix and it should fix any issues with your Office Installation.

Read More: Excel VBA to Display Print Preview for Multiple Sheets


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:

  • Firstly, go to the Page Layout tab from the ribbon.

print preview not available in excel Modifying Page Setup Option

  • After that, click on the marked portion of the following image.

print preview not available in excel Modifying Page Setup Option

Then, the Page Setup dialogue box will be available to you like the image below.

print preview not available in excel Modifying Page Setup Option

  • 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 below-given image.

print preview not available in excel Modifying Page Setup Option

Read More: How to Delete Blank Pages in Print Preview in Excel (4 Easy Ways)


💡 Things to Remember


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. To learn more about Excel, you can visit our website, ExcelDemy. Happy learning!


Related Articles

Zahid

Zahid

Hello and welcome! Thank you for visiting my profile. I am currently employed as an Excel & VBA Content Creator at ExcelDemy. My most recent academic qualification is a BSc (Eng) from the Bangladesh University of Engineering and Technology. Industrial and Production Engineering was my major. I constantly attempt to think creatively and find a simple answer.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo