Search results for

All search results
Best daily deals

Affiliate links on Android Authority may earn us a commission. Learn more.

How to add, hide and remove columns or rows in Google Sheets

Master the basics of creating and formatting spreadsheets.
By

Published onFebruary 15, 2022

Adding, removing, and hiding columns or rows to your spreadsheet is a simple two-click process. Here are some quick ways to add, hide, or remove columns or rows in Google Sheets.

Read more: 10 best Excel and spreadsheet apps for Android

How to add columns or rows in Google Sheets

Adding a column or row in Google Sheets is a quick two-step process. To add a column, right-click the entire column beside where you want your new column to be, and click Insert 1 column left or Insert 1 column right.

Add column sheets
Adam Birney / Android Authority

Likewise, to add a row, right-click the entire row beside where you want your new row to be, and click Insert 1 row above or Insert 1 row below.

Add row sheets
Adam Birney / Android Authority

Additionally, if you right-click on a single cell, it will give you the option to Insert 1 column left or Insert 1 row above.

right click cell sheets
Adam Birney / Android Authority

As a result of making your selection, you will see a new, blank column or row added in your chosen direction.

How to add multiple columns or rows in Google Sheets

If you want to add multiple columns or rows, you can follow a similar process. Instead, this time, start by highlighting the number of columns you want to add. For example, if you’re going to add three columns, highlight the three columns next to the columns you want to add. Then, right-click the column and select where to add the new ones.

Add multiple rows
Adam Birney / Android Authority

Likewise, if you want to add, say, a dozen rows, highlight twelve rows next to the rows you want to add, and so on.

How to hide columns or rows in Google Sheets

To hide columns or rows in Google Sheets, select the row or column you wish to hide and right-click it. From there, select Hide, represented by the icon with a slash through the eye.

Hide column
Adam Birney / Android Authority

How to unhide columns or rows in Google Sheets

After hiding a row or column, you’ll notice a box with arrows replacing it in the top header. That box represents the hidden column or row.

Unhide column sheets
Adam Birney / Android Authority

Click the box, and your column or row reappears.

Similarly, you can select multiple columns or rows at once by holding Shift on the keyboard. Then, right-click on one of them and select Hide.

How to delete columns or rows in Google Sheets

To delete a column or row in Google Sheets, a quick way is to right-click in a cell within the column or row you want to remove. After that, select Delete column or Delete row. You can also delete individual cells this way.

Delete column or row
Adam Birney / Android Authority

If you accidentally deleted the wrong entry, don’t worry; you won’t have to input all that data again. Instead, a simple Crtl + Z on the keyboard can restore the column or row you deleted.


Read more: How to freeze columns or rows in Google Sheets

FAQs

How do I add a formula in Google Sheets?

Double click the cell where you want your formula, then either select the procedure from the Functions tab or enter ‘=’ followed by the formula. For example, enter ‘=SUM’ to produce the total value of a given row.

How do I apply a formula to an entire column in Google Sheets?

First, select the cell with the formula. Then, click the desired column letter at the top. Now press Crtl + D (Windows) or Command + D (Mac).

How do I use Google Sheets?

A good starting point to learn the essential tools available in Google Sheets is by reading the Google Sheets cheat sheet.

You might like