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. Read More: [Fixed!] Print Preview in Excel Does Not Show All Pages 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. Read More: Excel VBA to Display Print Preview for Multiple Sheets 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. Read More: How to Delete Blank Pages in Print Preview in Excel (4 Easy Ways) 💡 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! Related Articles
How do you show print preview margins in Excel?Tip: To preview the new margins, click File > Print. To adjust the margins in Print Preview, select the Show Margins box in the lower right corner of the preview window, and then drag the black margin handles on either side or at the top or bottom of the page.
Why are lines not showing in Excel print preview?If gridlines don't appear when you preview or print the sheet, on the File menu, click Page Setup. Then on the Sheet tab, make sure that the Draft quality check box is not selected. If gridlines don't print, there may be an issue with your printer driver.
Why does my print preview look different in Excel?Having your paper set to the incorrect size can cause Excel to print outside the margins. Go to Start > Devices and Printers. Right click on the printer and select Printer Properties. Select the Device Settings tab to see what paper size has been selected.
How do I see page boundaries in Excel?To view page breaks using Page Break Preview: On the status bar, click the Page Break Preview button. Or, click the View tab, then click the Page Break Preview button.
|