How to Remove Gridlines in Excel

What gridlines are and why you might remove them

Gridlines are the faint horizontal and vertical lines that separate cells in an Excel worksheet. They help you visually navigate a grid, but they can clutter visuals when you’re preparing a report, presenting data, or taking screenshots for a dashboard. Removing them is a display choice, not a data change. As the XLS Library team explains, tuning visibility lets you focus on numbers and visuals without altering formulas. This can improve readability when sharing workbooks. Hiding gridlines does not modify data or formulas; it only affects how the grid appears on screen and, depending on settings, how it prints. If you frequently share clean visuals, learning to toggle gridlines on and off is a valuable skill that saves time.

From a practical perspective, consider your audience and delivery method. For slide decks, PDFs, or dashboards, gridlines often distract from charts and tables. For day-to-day data entry, you may prefer the traditional gridlines for orientation. The choice becomes a designer’s tool, not a data edit. XLS Library finds that most users choose to switch off gridlines temporarily when exporting visuals or preparing reports, then re-enable them for data entry sessions. This flexible approach helps you present data clearly without compromising accuracy.

Quick ways to hide gridlines in Excel

There are two fast, reliable ways to hide gridlines in Excel, and they apply across most modern versions, including Office 365 and standalone Excel installations on Windows and Mac:

• Method A: Use the View tab to toggle Gridlines off. This affects only the current worksheet’s display. If you have multiple sheets open, you can apply the change to a single sheet or use the sheet tabs to switch between them.
• Method B: Switch to Page Layout view. In this view, you’ll see how your sheet prints with or without gridlines. This helps ensure your printed reports look exactly as you intend. You can exit Page Layout to return to normal gridlines whenever needed.

These options are user-friendly, quick to implement, and reversible. Remember: hiding gridlines is a cosmetic adjustment and will not affect formulas, data, or cell formatting beyond visibility. If you’re preparing a slide deck or a PDF, hiding gridlines is often the simplest way to produce a clean, scan-friendly image of your data.

Hiding gridlines for printing vs just viewing

Excel differentiates between on-screen visibility and print output. To hide gridlines on screen, use View → Gridlines off. To prevent gridlines from appearing when you print, you must adjust the print settings. Go to Page Layout → Sheet Options → Gridlines, and uncheck the Print option. In some versions, this option is under Print Settings within the Print dialog as well. The key idea is to separate display from print, so your screen remains readable while your printed copy looks pristine. When you’re preparing a report for stakeholders, ensure you test print a page or two to confirm gridlines are not showing up.

Step-by-step guide: Windows and Mac differences

The exact menu labels can vary slightly between Windows and

Advanced options: using Page Layout, View, and Custom Views

If you want to manage multiple layouts, Excel’s Custom Views can be a powerful ally. Create a “Gridlines hidden” view to save the exact settings for screen display and print. Custom Views let you toggle display, print, and print area settings as a single switch, without changing the workbook across the board. To use Custom Views, go to View → Custom Views, add a new view, and specify which settings to include. Save and switch between your saved views depending on the delivery channel—screen sharing, PDF exports, or printed reports—while ensuring you don’t forget to re-enable gridlines when needed.

Applying across multiple sheets and workbooks

If you’re working with several sheets that share the same structure, you can speed up the process by grouping them. Select the first sheet, hold Shift, and click the last sheet to group them. Then toggle Gridlines off on the active sheet; the change will apply to all grouped sheets. This is especially helpful when preparing a multi-sheet report or dashboard where consistency matters. If you prefer not to group, you’ll need to repeat the steps for each sheet. The key is to verify the outcome by checking a print preview across the grouped sheets to ensure consistency.

Troubleshooting common issues

If gridlines still appear after you hide them, double-check which setting you modified. Sometimes you’ll be toggling on the wrong setting (display vs print). Ensure you used View → Gridlines off for the on-screen view and Page Layout → Sheet Options → Gridlines (Print) off for printing. Also verify you are editing the correct worksheet—not a protected or hidden sheet. If nothing seems to work, try restarting Excel or resetting the workbook’s view settings to default, then reapplying the changes.