How to add columns 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.

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: 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

Read original article here

Denial of responsibility! TechNewsBoy.com is an automatic aggregator around the global media. All the content are available free on Internet. We have just arranged it in one platform for educational purpose only. In each content, the hyperlink to the primary source is specified. All trademarks belong to their rightful owners, all materials to their authors. If you are the owner of the content and do not want us to publish your materials on our website, please contact us by email – [email protected]. The content will be deleted within 24 hours.