How to Insert / Add / Hide Rows or Columns in Google Sheets

Are you wondering how to put on rows to display on your spreadsheet? Find out how to do that in Google Sheets with these steps. how-to-insert-add-hide-rows-or-columns-in-google-sheets

Download the Free How to Insert / Add / Hide Rows or Columns in Google Sheets Article in PDF

How to Insert / Add / Hide Rows or Columns in Google Sheets Download

How to Insert / Add / Hide Rows or Columns in Google Sheets

  • Step 1: Click the Insert button

    how-to-insert-add-hide-rows-or-columns-in-google-sheets-step-1Once you have opened your Google Sheets file, you can see the following image above on your screen. On the top left of the screen, move the pointer at the word Insert. It’s on the column of words starting from File to the Help menu.

  • Step 2: Click Rows or Columns

    how-to-insert-add-hide-rows-or-columns-in-google-sheets-step-2If your chosen template doesn’t have enough rows or columns, not to worry! You can add as many as you want. As shown in the image above, after pressing Insert, click either Rows or Columns which will show on the dropdown. You can do this on both your computer and Android or iOS device. This is useful when working on budget and inventory templates.

  • Step 3: Add Rows and Columns by Left Clicking

    how-to-insert-add-hide-rows-or-columns-in-google-sheets-step-3You can left-click on the numbers or letters, or anywhere on the Google Sheet. Then press Insert 1 row or column which you can see on the dropdown. This can let you insert columns or rows whenever you want. However, if you want to add more than one, you can also try highlighting the number of rows or columns you wish to add and then left-click it. It will show you an option to add the same amount of row/column you highlighted. For example, if you highlighted 4 rows, you will see an option like ‘Insert 4 rows above’ in the dropdown.

  • Step 4: To Hide a Row/Column, left-click the header

    how-to-insert-add-hide-rows-or-columns-in-google-sheets-step-4Move the pointer to the number/letter header to show the dropdown. Then left-click on it to show the dropdown. You also have the option to highlight the specific row or column you want to hide and left-click it as well.

  • Step 5. Click Hide Column/Row

    how-to-insert-add-hide-rows-or-columns-in-google-sheets-step-5Click on the Hide Column or Hide row option that shows in the dropdown after left-clicking the header. You can do the same thing too if you wish to do the opposite and Unhide columns or rows. You can also just use the keyboard shortcut of Undo (CTRL + Z) to undo it right away.

Can I add more than 1 row in Google Sheets?

Yes, you can do this by highlighting the number of rows with your cursor, left-clicking it, and clicking on the Insert Rows that show in the dropdown. If you highlight 3, then you can insert 3 more, and so on.

How do I delete a column in Google Sheets?

Highlight and then left-click to get the dropdown and click on the Delete Column option. You can do this if you added way more columns by accident.

Can I unhide columns and rows in Google Sheets?

Yes, this can be done by highlighting the row/column, left-click, and choosing the Unhide Row or Unhide Column option at the dropdown.

What can I do if I accidentally delete the wrong row or column in Google Sheets?

You can press the keyboard shortcut for Undo by pressing the CTRL button and the Z button at the same time.