“How do I delete multiple rows in Google Sheets”
Analyst
“How do I remove a column in Google Sheets?”
“How to delete empty rows in Google Sheets?”
Google Sheets is important in the workplace, especially for web analysts. Like Microsoft Word or Microsoft Excel, Google Sheets is undeniably part of the office workflow. It’s a rare occurrence that you DO NOT come across Google Sheets or any spreadsheet in your work.
That said, Google Sheets is a melting pot of features like writing formulas. And most people don’t know about some nifty features. Most are overlooked or they need a refresher. Deleting or removing columns or rows in Google Sheets shouldn’t be hard
That being said, let’s start. Create a new Google Sheets file on your computer.
1 – Go to your Google Drive workspace.
2 – Click ‘+ New’ then create a new Google Sheets file.
Delete Columns or Rows in Google Sheets
In this article, you’ll learn how to delete columns and rows in a spreadsheet without fancy formulas. There are super easy ways to remove columns in Google Sheets. You can also add columns and rows. In this article, we’ll demonstrate how to delete columns first then demonstrate rows after.
How To Delete Columns In Google Sheets
We’ll tackle how to remove columns first. Below are the different methods. Remember that columns contain the vertical data that goes from top to bottom.
Method 1: Taskbar or Menu
1 – Go to the cell of the column you want to delete.
2 – Go to the taskbar or menu at the top and click “Edit”.
3 – Click “Delete column…”. In this example, it’s column C.
This is the first method to delete a column. Note that this removes one column only. If you prefer to delete more columns, highlight more cells horizontally. If you highlight five cells and do the process, you delete five columns.
Method 2: Manual Clicking
1 – Go to the column you want to delete.
2 – Click the letter of that column stated at the top. This highlights the entire column.
3 – Right-click.
4 – Click “Delete column”. In case you’re wondering, “Delete column” is the correct one while “Clear column” only clears the cells to an empty column.
This is the second method to delete a column. Like the previous method, this removes one column only. If you prefer to delete multiple columns, highlight more columns. If you highlight five columns and do the process, you remove five columns.
Method 3: Keyboard Shortcuts
1 – Go to the cell of the column you want to delete a column beside.
2 – For PC users, press CTRL + SPACEBAR. For Mac users, press CONTROL + SPACEBAR. This highlights the entire column.
3 – For PC users, press CTRL + MINUS KEY. For Mac users, CONTROL + MINUS KEY.
That’s it! Deleting columns shouldn’t be that hard in Google Sheets. Note that you can mix the methods to suit your workflow. For example, you can use Method 2 in highlighting the columns but then use Method 3 to delete.
Next is deleting rows…
How To Delete Rows in Google Sheets
We’ll now tackle how to delete rows. Remember that rows contain the horizontal data that goes from left to right. The steps of deleting rows are identical to deleting columns. And they are super easy to do.
Method 1: Taskbar or Menu
1 – Go to the cell of the row you want to delete.
2 – Go to the taskbar or menu at the top and click “Insert”.
3 – Click “Delete row…”. In this example, it’s row 4.
This is the first method to delete a row. Note that this removes one row only. If you prefer to delete multiple rows, highlight more cells vertically. If you highlight five cells and do the process, you remove five rows.
Method 2: Manual Clicking
1 – Go to the row you want to delete.
2 – Click the number of that row stated on the left side. This highlights the entire row.
3 – Right-click.
4 – Click “Delete row”.
This is the second method to delete a row. Like the previous method, this removes one row only. If you prefer to delete multiple rows, highlight more rows. If you highlight five rows and do the process, you remove five rows.
Method 3: Keyboard Shortcuts
1 – Go to the cell of the row you want to delete.
2 – For PC users, press SHIFT + SPACEBAR. For Mac users, press SHIFT + SPACEBAR as well. This highlights the entire row.
3 – For PC users, press CTRL + MINUS KEY. For Mac users, CONTROL + MINUS KEY.
That’s it! Deleting rows shouldn’t be that hard in Google Sheets. Note that you can mix the methods to suit your workflow. For example, you can use Method 2 in highlighting the rows but then use Method 3 to delete.
Tip: How To Use Columns and Rows in Analysis
When using columns and rows in Google Sheets, you need to know the values to insert in those cells and formulas. Spreadsheets contain multiple data points. You need to be aware of what’s called data structures especially with their values.
For columns, it should contain the same values. This means that columns should be one data type. If the data is a dates, the entire column should be dates only. If the data is a names, the entire column should be names only. If the data is product number, the entire column should be product numbers only.
For rows, it should be the information of one segment. For example, when you highlight a date in a row, everything in the row is the data for that date. When you highlight a name in a row, everything in the row is the data for that specific person. When you highlight a product in a row, everything in the row is the data for that product.
Conclusion: Google Sheets is easy to use
Deleting columns or rows in Google Sheets doesn’t need any formula. Whether you’re acquiring data or cleaning data, Google Sheets isn’t hard to use. You need to contextualize what you need to get the most out of it. Google Sheets is a popular and powerful tool in the workplace. When used properly, it’s powerful to automate many things in your workflow.