Deleting Columns and Rows In Google Sheets

Deleting Columns and Rows In Google Sheets
There are times when we collect data in a spreadsheet that isn’t relevant or necessary for our needs. This can happen when we receive data from another source. In this example, we have some data received from an online database which includes extra information and columns with headings and no data.

DraggedImage.693a29fb0e644e7780f49377e031a564.png

 

DraggedImage.afdaae6ee07e465eaea1bc291496b618.png

Click once on the column heading. In this example, we’ll click column H.

DraggedImage.a569b32d70b04dd0bf60816bc91c231d.png

There are several ways we can select the delete column option. When we hover the mouse over a selected column, an actions menu option will appear.

DraggedImage.c7860f796e8a4631b66f7a2ba9cb72e6.png

Click the menu to see the option to delete a column.

DraggedImage.f2fcccdb773a4fb6aefd2b5ef4074bda.png

We can also go to Edit in the menu and select delete from the options in this menu.

DraggedImage.a19470a40a6b479cac2e24d75e14ee5d.png

Another way to get the delete option is to click on the column to get the contextual menu, and that will provide the same options we had by clicking on the column actions menu.

DraggedImage.4486dc2409fd40e38e808deb9e407a96.png

When we delete a column, the contents of the column are erased and the column itself is removed. The column to the right moves to the left and takes its place. This is the difference between deleting a column or just deleting a column of values. In this example, when we delete the values in the column, the column remains.

DraggedImage.a594da1351284384bb5518cbed3a3136.png

When we delete the column, the values and the column itself are removed.

DraggedImage.88abdca5868f4649b750c4fd2ea1ab55.png

To delete a row we click on the row heading just like we clicked the column heading. Rows don’t have an action menu to help delete the row.

DraggedImage.2036b6a698734d0b8ccc36697aecf361.png

Right click to get the contextual menu or click on Edit in the menu and choose to delete the row.

Posted in Google Sheets.