Use the dropdown on the Open button and select Open and Repair. Go to File > Open and highlight the workbook you want to Repair. If you haven't already, ensure you've done your Windows, Office and printer driver updates. Note: Ensure your printer driver is up to date. If your Gridlines don't print, check the following:Ĭhoose the Sheet tab and find the Print section. To better align a worksheet on a printed page, you can use predefined margins, specify custom margins, or center the worksheet horizontally or vertically on the page.įind out more about setting your Page Margins. Set your Page Margins before printing a worksheet Select the Device Settings tab to see what paper size has been selected. Right click on the printer and select Printer Properties. Having your paper set to the incorrect size can cause Excel to print outside the margins.
Set the correct paper size before printing a worksheet If it is, then clear that box and the sheet will then print in color.īefore continuing on with these two fixes, if you haven't performed the Windows and printer driver updates, please do so. Look on theand check and see if the box for Print in Black and White is checked. Look up your printer manufacturer for the latest driver.
If Windows Update couldn't find a driver for your printer, you can always go directly to the manufacturers web site and check for the latest driver. Installing any important, recommended, and optional updates can often correct problems by replacing out-of-date files and fixing vulnerabilities. You might need to set Windows Update to automatically download and install recommended updates. Start by installing the latest Microsoft updates.
Please try each method in the order listed. If your print preview is different than what is printed, follow the steps in this article. However, the printed output may look different than what you see in the preview. Print Preview in Excel 2010 adjusts your workbook so it is easier to read on your monitor.
0 kommentar(er)
