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. Show
Download Practice Workbook3 Possible Solutions If Print Preview Is Not Available in ExcelIn 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 OptionsEditing 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:
After choosing Custom Margins, the following image will be available on 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.
Subsequently, you will see a proper Print Preview on your screen like the following image. Solution 2: Repairing Office InstallationFaulty Office Installation often leads to printing issues in Excel. Let’s learn the following steps to repair the Office Installation. Steps:
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.
After selecting Change, you will see the following dialogue box on your screen.
This is a comprehensive fix and it should fix any issues with your Office Installation. Solution 3: Modifying Page Setup OptionModifying 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:
Then, the Page Setup dialogue box will be available to you like the image below.
Consequently, you will be able to see your Print Preview on your screen like the below-given image. 💡 Things to Remember
ConclusionFinally, 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! Why is print preview not available in Excel?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.
How do I turn on print preview in Excel?Preview the worksheet
Click the worksheet or select the worksheets that you want to preview. Click File > Print > Print Preview. Keyboard shortcut Press Ctrl+P.
Where is print preview Excel 365?Excel combines Print and Preview in the same window. Click File > Print. On the right, you'll see a preview of your file. On the left, you'll see the Print button and the configurable Settings.
How do I find print preview?Click the File tab; Click the Print button at left bar; Click the Print Preview button, then you will get the print preview.
|