For users of Google Sheets, the default gridlines are visible, but sometimes you might want to hide or show them based on your needs, especially when printing or presenting. Thankfully, Google Sheets provides options to manage these. If you've accidentally deleted them or just want them back, here's how to add gridlines back in Google Sheets.
Gridlines aren't just for looks; they help align your data and make your worksheet more presentable. Let's dive into the process of adding them back.
Understanding Gridlines in Google Sheets
Before we proceed, let's understand what gridlines are. In Google Sheets, gridlines are the lines that help you align your data within cells. They are visible by default but can be turned off, causing your cells to appear merged together.
There are two types of gridlines in Google Sheets: horizontal and vertical. You can show or hide them separately, or both can be shown or hidden together.
Horizontal Gridlines
Horizontal gridlines are the lines that run horizontally across your worksheet, separating your rows.
They help you easily identify and work with different rows of data. You can show or hide them based on your need, making your worksheet looks cleaner and easier to read.
Vertical Gridlines
Vertical gridlines run vertically, dividing your columns. With vertical gridlines, you can easily understand and manage your different columns of data.
Similar to horizontal gridlines, you can hide or show them as needed. Some worksheets might demand a cleaner look without any visible gridlines; others might require them for data organization and alignment.
Adding Gridlines Back in Google Sheets
Now that you understand the importance of gridlines in Google Sheets, let's learn how to add them back if they've been removed.
Google Sheets allows you to show or hide gridlines with just a few clicks. Here's how:
To Show Both Horizontal and Vertical Gridlines
When you want to show both horizontal and vertical gridlines:
- Select any cell in your Google Sheets spreadsheet.
- Click on "View" from the menu.
- Check the box next to "Gridlines".
Both horizontal and vertical gridlines will appear in your worksheet.
To Show Only Horizontal Gridlines
If you only want to show the horizontal gridlines:
- Click on "View" from the menu.
- Untick "Vertical gridlines".
- Tick "Horizontal gridlines".
Now, only the horizontal lines will be visible, helping you align your rows perfectly.
To Show Only Vertical Gridlines
To show only the vertical gridlines:
- Click on "View" from the menu.
- Untick "Horizontal gridlines".
- Tick "Vertical gridlines".
Only the vertical lines will be visible, which can be helpful for aligning columns and understanding your data better.
Adding gridlines back in Google Sheets can adesso as quick and easy this guide will help you master the process, saving you valuable time and effort.