By default, Microsoft Excel displays faint grey gridlines across every worksheet. While these lines are essential for aligning data and visually separating cells during the data entry phase, they can make a finished report or dashboard look cluttered and unprofessional. Learning how to hide gridlines is a simple but crucial step in presenting clean, easy-to-read Excel documents.
Why Hide Gridlines?
Hiding gridlines is a fundamental formatting technique for several reasons:
- Professional Presentation: When building a dashboard or a financial summary, a blank white canvas looks significantly cleaner than a screen filled with grey squares.
- Highlighting Important Data: Without the default gridlines competing for attention, the borders you intentionally add to specific tables or charts will stand out much more effectively.
- Readability: Large blocks of text or complex charts are often easier to read when they are not superimposed over a grid pattern.
Step-by-Step: Hiding Gridlines on the Screen
Turning off the visual gridlines on your monitor takes just two clicks.
- Open your Excel workbook and select the worksheet where you want to hide the gridlines.
- Navigate to the View tab on the ribbon at the top of the screen.
- Look for the Show group (located towards the middle-left of the ribbon).
- Uncheck the box labelled Gridlines.
- The grey lines will immediately disappear from your active worksheet, leaving a clean white background.
Note: This setting only applies to the current worksheet. If your workbook contains multiple sheets, you must repeat this process for each sheet where you want the gridlines hidden.
Step-by-Step: Hiding Gridlines When Printing
By default, Excel does not print gridlines. However, if someone has previously changed the print settings, you might find gridlines appearing on your physical documents even if they are hidden on your screen. Here is how to ensure they do not print:
- Navigate to the Page Layout tab on the ribbon.
- Look for the Sheet Options group.
- Under the ‘Gridlines’ section, you will see two checkboxes: ‘View’ and ‘Print’.
- Ensure the Print box is unchecked.
Troubleshooting Common Mistakes
If you have unchecked the Gridlines box but still see lines on your spreadsheet, you are likely looking at cell borders, not gridlines.
- Borders vs Gridlines: Gridlines are a global view setting that applies to the entire sheet. Borders are specific formatting applied to individual cells. If you still see lines around certain cells, highlight those cells, go to the Home tab, click the Borders drop-down menu (in the Font group), and select No Border.
- White Fill: Sometimes users attempt to hide gridlines by filling all cells with a white background colour. This is poor practice. It unnecessarily inflates the file size and can cause issues if you later try to apply conditional formatting or copy the data elsewhere. Always use the View tab to toggle gridlines.
By controlling when and where gridlines appear, you ensure your Excel spreadsheets transition smoothly from raw data entry to professional presentation.