If you’re creating a spreadsheet in Google Sheets, you might find yourself wanting a clean and organized sheet without the default gridlines. Gridlines can be helpful for data input and analysis. However, in some cases, these lines may make your sheet look crowded, or you may find them inappropriate for your presentation style.
No need to worry – Google Sheets provides a simple solution to this. Here’s a step-by-step guide on how to remove gridlines in Google Sheets.
Step 1: Open your Google Sheets document
Firstly, you need to open your Google Sheets document. You can do this by going to sheets.google.com and selecting the document you want to work on.
Step 2: Select the cells where you want to remove the gridlines
Once your document is open, select the cells where you want to remove the gridlines. You can do this by clicking and dragging your cursor across the cells. If you want to remove gridlines from the entire sheet, you can do so by clicking the small square in the top left corner of the sheet. This will select all cells.
Step 3: Navigate to the “View” option in the menu
Now, navigate to the “View” option in the menu at the top of the page. Click on it to see the drop-down menu.
Step 4: Toggle off the “Gridlines” option
In the drop-down menu, you will see an option labeled “Gridlines”. If the gridlines are currently showing, there will be a checkmark next to this option. Click on “Gridlines” to toggle this option off. Once done, the gridlines should disappear from your selected cells.
Within the ‘View’ menu, the code essentially does this:
if (document.querySelector("#\:1.viewMenu > div.goog-menu.goog-menu-vertical > g-menu > g-menu-item:nth-child(8) > div > div.goog-menuitem-content").checked) {
document.querySelector("#\:1.viewMenu > div.goog-menu.goog-menu-vertical > g-menu > g-menu-item:nth-child(8) > div > div.goog-menuitem-content").click();
}
With these simple steps, you can remove gridlines in Google Sheets. The method is straightforward and doesn’t require any complex coding or advanced Google Sheets knowledge. Keep exploring for more such features to make your data look the way you want it to.