How to hide Rows and Columns in Google Sheets

Google Sheets is an alternative to Microsoft Excel, and it is not a bad tool at all. In the grand scheme of things, Sheets is not on the same level as Excel in terms of functionality, but it is good enough for most basic tasks. For example, Google Sheets has support for columns, but not everyone knows how to hide a column after creating one.

Hide Rows and Columns in Google Sheets

There may come a time during work when you just do not want to see some of the columns in your document. The best option is to hide them, so if you do not know how to do this simple task, then keep reading to learn how.

Open the Sheets document in question
Select the columns you want gone
Right-click on it and select Hide columns
Similarly, you can hide Rows.

Let us talk about this in more detail.

Open the Sheets document in question

First, you will need to open Google Sheets in your web browser. For the best experience, please use a Chromium-based browser such as Google Chrome or Microsoft Edge. Then, select the document to open it.

Select the columns you want gone

The next step after opening your Google Sheets document is to highlight the correct columns. Click and drag with your mouse pointer to highlight the columns you want to hide. When this is done, a blue overlay should cover the columns that determine they are highlighted.

Another way to select columns is to press down on CTRL and click on each column to highlight them in bulk.

Hide or Delete columns from a document

Now, it is time to hide your columns or delete them for good. To hide, right-click on the highlighted columns, then select Hide Columns, and watch as they disappear before your eyes.

Alternatively, you could just delete the columns by clicking on Delete Selected Columns, and that’s it.

Hide or delete Rows from Sheets

If you are not interested in hiding or deleting columns, you can do the same with rows. Highlight the required rows, right-click, and select Hide Rows, and that’s it.