How to Remove Gridlines in Google Sheets

What gridlines are in Google Sheets and why hiding can help

Gridlines are the faint lines that delineate cells in Google Sheets. They are present by default and help you visually separate data. For many tasks—data entry, analysis, or preparing visuals—these lines can be distracting, especially when you are sharing a screenshot or presenting data in a report. Hiding gridlines is a simple, non-destructive display option: it only changes how the sheet looks on your screen; your data, formulas, and formatting remain unchanged. This makes it a popular technique for students who want to emphasize content, professionals who need cleaner screenshots for dashboards, or small business owners drafting proposals. The ability to toggle gridlines on and off per sheet means you can tailor the view for each task. In addition to on-screen presentation, understanding how to manage gridlines helps with printing and exporting, since printed output can differ from what you see in the editor. How you approach hiding gridlines may vary slightly between browser and mobile apps, but the core idea is the same: adjust the display so the focus stays on the data.

This guide uses practical, task-focused language so you can implement the steps quickly, whether you are a student compiling homework, a professional preparing a client-ready slide, or a small business owner drafting a proposal. By mastering gridlines, you can customize views for presentations, dashboards, or clean exports while preserving the underlying data and formulas.

How-To Sheets emphasizes practical, actionable changes you can apply today. Remember that every sheet is a separate canvas; adjust gridlines independently per tab if you want a uniform look across a workbook.

On-screen gridlines: hiding for a distraction-free view

Hiding gridlines on screen is a quick win when you want to focus on content, especially during data analysis, report preparation, or sharing screenshots. To hide on-screen, open your spreadsheet and go to View > Gridlines. Uncheck Gridlines, and the page will instantly display with no faint borders between cells. If you switch sheets, the setting may carry over; if not, re-apply on the new tab. Note that this change only affects how you see the sheet; it does not alter data, formats, or formulas. For multi-user work, communicate that this is a personal view preference—others may still see gridlines if they haven’t turned them off in their session. Keyboard shortcuts are not standardized for this toggle, so using the menu is the most reliable method. In addition, if you depend on keyboard navigation, consider how gridlines being hidden might affect alignment cues when entering data. The key benefit is a cleaner canvas for reviewing content, designing dashboards, or exporting clean images.

Gridlines in print vs screen: when to disable

There is a clear distinction between hiding gridlines for on-screen viewing and removing them for printed output. On-screen hiding is achieved with View > Gridlines; printing requires a separate step: File > Print, then in the Print settings uncheck Gridlines. This ensures the printed document has a clean, gridline-free appearance. Depending on the print destination (printer, PDF, or export), you may need to preview and adjust margins to preserve your layout. If your sheet includes charts or images, the gridlines around cells will not affect charts, but the surrounding white space will dictate how the page breaks occur. For most business reports, hiding gridlines while keeping cell content is enough to produce a professional look. If you frequently print, consider creating a dedicated print view template where gridlines are disabled and the rest of the formatting is tuned for page width. Always verify by doing a test print or export before final submission.

Troubleshooting and common questions

If you can’t find the Gridlines option on a particular device, look for the option under a different menu name like Display or View in the mobile app. Some layouts place the toggle in a context menu rather than the main View tab. Remember, on-screen gridlines and print gridlines are controlled separately; you must disable both for a fully clean result when sharing or printing. If you share the sheet with others, note that their view settings may differ; they can toggle gridlines independently. Finally, verify your final output by previewing or printing a copy to catch any remaining gridlines or margins that affect readability.