If you want to remove gridlines from cells in Google Sheets, there are a few ways to do it. You can hide gridlines across an entire spreadsheet, remove the appearance of gridlines from a specific range by changing its formatting, or use borders to create a cleaner and more organized layout.
In this guide, you’ll learn how to remove gridlines from your Google Sheets worksheet using simple steps.
Remove Gridlines from Cells in Google Sheets
To Remove Gridlines from Cells in Google Sheets,
- Open Google Sheets and select the spreadsheet where you want to remove gridlines.
- Click View in the top menu.
- Select Show and then click Gridlines to hide gridlines across the current worksheet.
- To hide the gridlines around only certain cells, select the required cell range.
- Open the Fill color option and choose a suitable background color, such as white.
- Use the Borders option to add or customize borders around the selected cells if needed.
- If you want to restore the gridlines, go to View > Show > Gridlines and enable them again.
Step 1: Open Your Google Sheets Spreadsheet
The first step is to open the spreadsheet where you want to remove the gridlines. Launch your preferred web browser, such as Google Chrome, Microsoft Edge, or Safari, and visit Google Sheets.
Sign in to your Google account if necessary. Once the Google Sheets home page opens, locate the spreadsheet you want to edit. You can select a file from your recent documents or open a spreadsheet from Google Drive.
After opening the file, take a moment to identify the worksheet where you want to hide the gridlines. A Google Sheets file can contain multiple worksheets, which appear as tabs at the bottom of the screen.
For example, your spreadsheet might contain tabs named Sales Report, Expenses, and Customer Data. If you only want to remove gridlines from the Sales Report worksheet, make sure you select that tab before continuing.
This is important because the gridline setting applies to the current worksheet. Selecting the correct tab helps prevent you from changing the appearance of another sheet accidentally.
Step 2: Open the View Menu
Once your spreadsheet is open, look at the menu bar near the top of the Google Sheets window. You will see options such as File, Edit, View, Insert, Format, and Data.
Click View to open the menu containing different display and viewing options.
The View menu controls how information appears on your screen. It includes features for showing or hiding certain spreadsheet elements, changing display settings, and adjusting how you work with the worksheet.
Look through the available options and find Show. This option contains settings for displaying elements such as formulas, gridlines, and other spreadsheet features.
Move your mouse pointer over Show or select it to open its submenu. You will then see the Gridlines option.
Step 3: Turn Off Gridlines in the Current Worksheet
After opening the Show submenu, locate the Gridlines option. If gridlines are currently visible, you will generally see a check mark beside this option.
Click Gridlines to turn off the gridlines in the current worksheet.
Once you do this, the faint gray lines separating the cells will disappear from the worksheet view. Your data will remain in the same cells, and nothing will be deleted. Google Sheets is only changing the way the worksheet is displayed.
For example, imagine that you have a table containing employee names, departments, and salaries. Before hiding gridlines, every cell is surrounded by light gray lines. After disabling gridlines, the worksheet will look cleaner, and the information may be easier to present in a report.
Keep in mind that this setting does not delete cell contents, formulas, or formatting. It only changes the visibility of the worksheet’s gridlines.
If you have multiple worksheets in the same file, you may need to repeat this process for each worksheet where you want gridlines hidden.
Step 4: Select the Cells Where You Want a Gridline-Free Appearance
Sometimes, you may not want to hide gridlines across the entire worksheet. Instead, you might want a specific section, such as a title area, summary box, or formatted report, to appear without visible gridlines.
In this situation, first select the cells you want to format. Click the first cell in the range and drag your mouse across the other cells. You can also select a range by clicking the first cell, holding the Shift key, and selecting the last cell.
For example, if you want to format cells A1 through D5, select the entire range from A1:D5.
You can also select an entire row or column by clicking its number or letter along the edge of the worksheet. However, if you only want to change a small section, selecting a specific range gives you more control.
It is important to understand that Google Sheets does not normally provide a separate Hide Gridlines for This Cell command. The regular gridline setting applies to the whole worksheet. Therefore, selecting a range prepares it for alternative formatting methods rather than directly disabling its gridlines.
Step 5: Apply a Background Color to the Selected Cells
After selecting the required cells, look for the Fill color button in the Google Sheets toolbar. Its icon usually looks like a paint bucket.
Click Fill color to open the available background color choices. Select a color that matches the appearance you want for your worksheet. For a clean, gridline-free design, white is often a suitable choice when the sheet has a white background.
Applying a background color can make a selected area look more like a solid block, especially when combined with other formatting choices. This is useful for creating headings, summary sections, or report layouts.
However, there is an important distinction. Changing the fill color does not actually disable gridlines. Gridlines are a display feature, and applying a fill color alone may not hide them in every situation.
For a consistent gridline-free appearance, you should use the worksheet-level gridline setting described earlier. You can then use background colors to improve the visual design of specific areas.
If your worksheet already contains different background colors, choose a color that fits your existing formatting. This helps keep the spreadsheet easy to read and visually consistent.
Step 6: Remove Existing Cell Borders if Necessary
If you have applied borders to your spreadsheet in the past, those borders may still be visible even after you hide gridlines.
To check for existing borders, select the relevant cells and find the Borders button in the Google Sheets toolbar. The icon usually looks like a small square divided into sections.
Click the Borders button to view the available border settings. You may see options such as All borders, Inner borders, Outer borders, and Clear borders.
If you want to remove borders from the selected cells, choose Clear borders. This removes the manually applied border formatting from the selected range.
This step is particularly useful when you’re preparing a clean report or a presentation-style worksheet. Removing unnecessary borders can make the layout look less crowded.
Remember that gridlines and borders are separate features. Turning off gridlines does not remove borders, and clearing borders does not necessarily hide gridlines. You may need to manage both settings depending on the appearance you want.
Step 7: Add Only the Borders You Need
Although you may want to remove gridlines, completely removing every visual separation between cells is not always the best choice. In some spreadsheets, borders help readers understand the structure of the information.
For example, a financial report might look better with a border beneath the column headings or around a total amount. A table containing customer details may benefit from an outer border while leaving the inside of the table open.
To add borders, select the cells you want to format and click the Borders button. Choose the appropriate border style from the menu.
You can add an outer border around a selected range, apply a bottom border to headings, or use other border options to create a professional layout.
If you have already hidden the worksheet gridlines, these manually applied borders will remain visible. This allows you to create a custom table design without relying on the default gray gridlines.
For a polished spreadsheet, try to use borders sparingly. Too many borders can make the worksheet look busy, while a few well-placed borders can improve readability.
Step 8: Check the Worksheet and Save Your Changes
After turning off gridlines and adjusting any cell formatting, review the worksheet carefully.
Look at the areas where you entered data, created tables, or added headings. Make sure the information is still easy to read and that important sections are clearly separated.
If you are working on a report, check whether the headings, totals, and labels are easy to identify without gridlines. If the worksheet looks too plain, consider adding bold text, background colors, or selected borders.
Google Sheets generally saves changes automatically while you work. You can check the saving status near the top of the spreadsheet to make sure your updates have been synchronized.
If you plan to print or share the spreadsheet, remember that the way gridlines appear on screen may differ from how the sheet looks in a printed document or exported file. Review the print settings before creating a final copy.
Faqs
Can I remove gridlines from only one cell in Google Sheets?
Google Sheets does not normally offer a separate gridline visibility setting for an individual cell. The View > Show > Gridlines option applies to the current worksheet. If you want a particular cell or range to appear different, you can use background colors and custom borders to create the desired design.
How do I remove gridlines from the entire Google Sheets worksheet?
Open the worksheet, click View, select Show, and then click Gridlines. This hides the faint gray lines across the current worksheet. Your data, formulas, and cell contents will remain unchanged.
Will hiding gridlines delete my spreadsheet data?
No. Hiding gridlines only changes the worksheet’s visual display. It does not delete information, remove formulas, or erase cell contents.
What is the difference between gridlines and borders in Google Sheets?
Gridlines are the light gray lines that help you identify cells while working in a worksheet. Borders are formatting options that you manually apply to cells or ranges. Hiding gridlines does not automatically remove borders.
Can I restore gridlines after hiding them?
Yes. To restore them, go to View > Show > Gridlines and click the Gridlines option again. The gridlines will become visible in the current worksheet.
Why can I still see lines after hiding gridlines?
You may be seeing manually applied cell borders rather than gridlines. Select the affected cells, open the Borders menu, and choose Clear borders if you want to remove those borders.
Can I hide gridlines in the Google Sheets mobile app?
The available display and formatting options can vary between the desktop and mobile versions of Google Sheets. If you cannot find the gridline setting in the mobile app, try opening the spreadsheet in the desktop web version of Google Sheets, where the View menu provides the standard gridline control.