Fix Brown Shading in Microsoft Excel Rulers and Print Margins
Question details
The user needs to understand brown shaded areas in Excel rulers and make the worksheet margins and final column align correctly for printing.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- After migrating to Microsoft 365, the user changes worksheet margins but the ruler indicators and printable area do not appear to match the worksheet.
- Observed behavior
- Brown shading appears in the Excel rulers, and changing the margins does not allow the final column to fit within the right margin. The shading represents printable and non-printable areas rather than cell formatting.
Select the affected worksheet and confirm the intended printer, paper size, and page orientation in Excel. Also check whether a print area is already defined, because an old print area can make the worksheet appear misaligned.
Check Excel page layout, scaling, and print area settings
Use this solution when ruler shading or a missing final column is caused by page setup, printer, or worksheet print settings.
The brown or gray area around the ruler indicates a non-printable region determined by the selected printer and page setup. It is not cell shading and may not align with a margin marker until the paper, printer, orientation, and scaling settings are consistent.
In Excel, select the affected worksheet, open the View tab, and choose Page Layout or Page Break Preview to see how the worksheet is divided across printed pages.
Open the Page Layout tab, select Size to choose the correct paper size, then select Orientation and choose Portrait or Landscape. In the Page Setup group, click the dialog launcher to review the selected printer and page settings.
On the Page Layout tab, select Margins and choose Custom Margins to check the left, right, top, and bottom values. Then open the Scale to Fit controls and set Width, Height, or Scale so the final column fits the intended page.
On the Page Layout tab, open the Print Area menu and select Clear Print Area. If needed, select the cells to print, return to Print Area, and choose Set Print Area.
Open File > Print and review the preview for the selected worksheet. If the column still falls outside the page, return to Page Setup and confirm that the correct worksheet, printer, paper size, and scaling options are being used.
Reset Excel page setup when margin changes are not retained
Use this option when Excel keeps reverting the margins or displays different ruler boundaries for different worksheets or printers.
Print Excel-compatible worksheets with WPS Office
If Microsoft Excel continues to show confusing ruler shading or inconsistent print boundaries, WPS Office provides a free, lightweight alternative with a familiar spreadsheet interface. Open Excel workbooks, review page layout and print settings, adjust scaling and margins, and migrate without losing common Office formatting.
- 1. Install WPS Office: Download and install WPS Office, then open the application from your desktop or Start menu.
- 2. Open the Excel workbook: In WPS Office, choose Spreadsheet > Open and select the affected XLS or XLSX file.
- 3. Review page layout: Open the Page Layout tab and check the paper size, orientation, margins, scaling, and print area before printing.
- 4. Preview and print: Select File > Print to preview the worksheet, confirm that the final column fits, and choose the target printer.
Frequently Asked Questions
Does brown shading in an Excel ruler mean that cells are formatted brown?
No. The shaded ruler area indicates printable and non-printable regions based on the selected printer, paper size, and page setup. It is not cell formatting.
Why does changing Excel margins not make the final column fit?
The worksheet may be using the wrong paper size, orientation, printer, scaling setting, or a defined print area. Check Page Layout > Size, Orientation, Margins, Scale to Fit, and Print Area, then verify the result in File > Print.
Where can I see the actual worksheet page boundaries in Excel?
Open the View tab and select Page Layout or Page Break Preview. These views show how the worksheet will be divided across printed pages.
How do I remove an old print area in Excel?
Select the affected worksheet, open the Page Layout tab, choose Print Area, and click Clear Print Area. You can then select the intended cells and use Set Print Area.
Can WPS Office open my Excel workbook with its print settings?
WPS Office can open common XLS and XLSX workbooks and provides page layout, margin, scaling, and print preview controls. Review the print preview after opening the file because printer-specific boundaries may vary.
