To hide the faint lines between columns and rows in Excel for Microsoft 365 on Windows, open the worksheet, select the View tab, and clear the Gridlines checkbox in the Show group. This hides gridlines across that worksheet; to hide lines only in particular cells, apply a fill color to those cells instead.
What Excel means by column lines
People often use column lines to mean the light gray grid that separates cells. Excel calls these lines gridlines. They are a display aid, not cell borders: they help you see the worksheet structure while entering or reviewing data, but they are not normally part of the cell formatting.
Gridlines run horizontally and vertically across the worksheet. Excel does not provide a setting to switch off only the vertical lines between columns while leaving horizontal gridlines on, or to hide the gridlines of just one column with the View checkbox. That checkbox controls the gridlines for the active worksheet as a whole.
It is also easy to confuse gridlines with other visual marks. The letters A, B, C at the top are column headings, while blue or dashed lines may indicate page breaks. Cell borders, table outlines, and chart lines are separately formatted objects. Hiding gridlines does not automatically hide any of those.
Hide gridlines on a whole worksheet
On Windows desktop Excel, use this path:
- Click the worksheet tab you want to change.
- Open View on the ribbon.
- In the Show group, clear the Gridlines checkbox.
The change applies to the current worksheet, not every sheet in the workbook. If a workbook has several tabs and you want a clean view on each, visit each sheet and change its setting. You can turn the lines back on at any time by returning to View and selecting Gridlines.
There is a second route on the desktop: select Page Layout, find the Sheet Options group, and clear View under Gridlines. The View checkbox in this group controls on-screen appearance. A separate Print checkbox controls whether gridlines appear on paper or in a PDF, so do not treat those two settings as interchangeable.
These settings are saved with the workbook. Hiding gridlines changes how the sheet looks; it does not delete data, alter formulas, or remove borders and fill formatting. If you share the workbook, the recipient may see the same gridline preference when opening it, subject to the app and view they use.
Hide lines in selected cells only
If you want to remove the faint lines from one column, a block of cells, or a designed form while keeping them elsewhere, apply a fill to the target cells. Select the cells, go to Home, open the Fill Color menu in the Font group, and choose a color. A white fill often blends into a white worksheet background, making the gridlines disappear inside the selected range while the rest of the sheet retains its grid.
For example, to make a report’s title area look like a single panel, select A1:F3 and apply a white fill. The gridlines in that block will no longer show, while gridlines below row 3 and beyond column F remain visible. If the worksheet background or the page design uses another color, choose a matching fill instead.
A fill is real cell formatting, unlike switching off gridlines. It may affect how the cells look when printed or when a different theme is used. To undo it, select the cells and choose Home > Fill Color > No Fill. If the cells already have a meaningful fill, consider keeping it and using borders selectively to create the desired visual structure.
For a deliberate dividing line, select cells along the edge and use Home > Borders to apply a border. Borders can be chosen and formatted independently, and remain visible when worksheet gridlines are hidden. This is the right approach for a report that needs a specific separator rather than Excel’s default grid.
Gridlines on screen versus printed pages
Turning off gridlines in the View tab is an on-screen display choice. It does not by itself determine whether gridlines print. In desktop Excel for Windows, select Page Layout and look in Sheet Options > Gridlines. Clear View to hide them on screen, or clear Print to prevent them from printing. These are separate checkboxes, so a worksheet can have gridlines visible on screen but omitted from printouts, or the reverse.
Gridlines are commonly left off in printed reports because they can make a page look crowded. If you need some divisions in the printout, use borders for the specific cells or table edges you want to show. Borders are formatting, so they can print even when the Print gridlines option is off.
Before printing, use File > Print to inspect the preview. Check more than the gridlines: page orientation, scaling, margins, and the selected print area can all affect the result. In Excel for the web, print output can depend on the print workflow and available settings; check its print preview rather than assuming the desktop Page Layout controls have the same placement.
Gridlines, borders, headings, and page breaks
Several Excel marks look like lines but need different fixes. If a line remains after you clear Gridlines, first check whether it is a cell border. Select the cells around it and inspect Home > Borders; removing a border is a formatting change and may also remove other edges in the selected range if you choose the wrong option.
Column letters and row numbers are headings, not gridlines. To hide those labels on Windows, use View and clear Headings in the Show group. This affects both row and column headings on that worksheet. It does not hide the grid or change the worksheet’s data, and it is useful when presenting a dashboard or a form-like sheet.
Page-break indicators are another common source of confusion. A solid or dashed boundary may appear after using print-related features or viewing page breaks. In Windows desktop Excel, page breaks can be hidden through File > Options > Advanced, then under Display options for this worksheet, clear Show page breaks. The option is distinct from Gridlines and may need to be adjusted separately.
Tables can also have visible outlines or banded formatting, and shapes may have their own borders. Hiding gridlines will not remove those visual elements. Identify which object is producing the line before changing settings; otherwise, you may turn off useful worksheet guides and still leave the unwanted border in place.
Why gridlines may still appear
If the lines remain, check these common causes before changing other formatting:
- Make sure you are on the intended sheet. Gridline visibility is set per worksheet.
- Confirm that the View tab’s Gridlines checkbox is cleared. The Page Layout Print checkbox does not control on-screen lines.
- Look for borders applied to the cells. Gridlines disappear with the display setting, but borders do not.
- Check whether the visible marks are page breaks, headings, table edges, or shapes rather than gridlines.
- If only part of the sheet has no lines, check whether those cells have a fill color.
Another source of confusion is that applying a fill can hide gridlines only where the cells are filled. A white fill may look like no formatting on a white sheet, but it is still present. If a colleague later changes the fill or the sheet’s appearance, the distinction can become noticeable. For a polished workbook, make intentional use of fills and borders, and keep the gridline setting separate from the design choices.
Windows, Mac, and Excel for the web
The Windows instructions above apply to Microsoft 365 desktop Excel. On Excel for Mac, use the View tab and the Gridlines control to show or hide the sheet grid; the exact ribbon arrangement can differ by window size and app build. Mac keyboards also differ from Windows, but there is no need for a keyboard shortcut for this task: use the visible ribbon control.
In Excel for the web, open the worksheet’s View tab and use its gridlines display control. The browser interface can place controls differently from desktop Excel, and some page setup choices are more limited or handled through printing. If the goal is specifically to change what appears on paper or in a PDF, inspect the available print settings and preview in the web app, or open the workbook in desktop Excel for the full Page Layout options.
Because the setting belongs to a worksheet, the same underlying workbook can look slightly different in another view or app if that app has different display behavior. For a file intended for others, check the sheet in the environment they will use and verify the print preview separately.
Frequently Asked Questions
Can I hide gridlines in just one Excel column?
Not with the worksheet Gridlines checkbox; it applies to the whole sheet. To hide lines in a particular column while keeping the rest, select its cells and apply a fill color. You can also use borders to control which edges are visible.
How do I remove only the vertical lines in Excel?
Excel does not have a gridline setting for vertical lines alone. Hide all gridlines for the worksheet, then add horizontal borders where needed, or use fills and borders to build the layout you want.
Why do lines still show after I turn off Gridlines?
They may be cell borders, table edges, page-break indicators, or other formatted objects. Gridlines are only the worksheet’s default cell guides. Inspect the cell formatting and distinguish borders from page breaks before removing anything.
Will hiding gridlines affect my formulas or data?
No. It changes the worksheet display, not cell contents, formulas, or calculation. It also does not remove borders or other formatting. The setting can be changed back from the View tab.
How do I hide gridlines when printing?
In Windows desktop Excel, go to Page Layout > Sheet Options > Gridlines and clear Print. Use File > Print to review the result. The View setting and Print setting are independent.
Can I remove gridlines from only a few cells without hiding them everywhere?
Yes. Apply a fill color to those cells; gridlines are not shown through filled cells. Choose a fill that matches the worksheet design, and use No Fill later if you want to restore the default cell appearance.
Related
- Excel Data Heat Map: Create, Read, and Troubleshoot One
- Excel Custom Print Area: Set, Adjust, and Troubleshoot
- Excel Continually Not Responding? Causes and Fixes
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Limit a Range in Google SheetsTo limit who can change cells in Google Sheets, select the cells, open Data > Protect sheets and…
- Vacation Budget Spreadsheet by Day: Build and Use OneA vacation budget spreadsheet by day puts each travel date on its own row and groups expected costs…
- Excel Ran Out of Resources: Causes and FixesWhen Excel says it ran out of resources, it could not get enough memory or another system resource…
- Creating a Schedule in Google Sheets: Steps and TipsTo create a schedule in Google Sheets, open a blank spreadsheet, add columns for dates, start and end…
- How to Remove Page Break View in Excel: Normal ViewTo remove Page Break Preview in Excel for Microsoft 365 on Windows, select View > Normal. If you…
- Excel Shortcuts for Evenly Sized Rows and ColumnsYes. In Excel for Microsoft 365 on Windows, select the columns or rows you want to make equal,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.