How to add, hide and remove columns or rows in Google Sheets
Edgar Cervantes / Android Authority
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
QUICK ANSWER
To add, remove or hide a row in Google Sheets, right-click it and select the appropriate option.
KEY SECTIONS
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.
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.
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.
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.
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.
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.
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.
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: Google Sheets lets you make charts simply by asking for them
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?
For all the latest Technology News Click Here
For the latest news and updates, follow us on Google News.