In this tutorial, you will learn how to remove extra rows and columns from a Google Sheet. It is very easy to delete multiple rows or columns from a Google Sheet. We just need to select columns/rows/cells in a series and use Edit menu. However, when we have to get rid of all the extra columns and rows from a sheet, such method doesn’t work. Therefore, we need to take the help of some add-on like ‘Crop Sheet‘.
Crop Sheet is a very simple Google Sheets add-on, yet it is very important to automatically remove all the extra rows and columns from a Google Sheet. This add-on works in two different manners:
- It can remove all the extra rows and columns without any selection.
- You can select the rows and columns that you want to keep and then the add-on will take the action to remove rest of the columns and rows.
If you want to learn about the add-on in detail, then continue the reading.
Remove Extra Rows and Columns from A Google Sheet Using Crop Sheet Add-on:
Following are the steps:
Step 1: Open this Google Sheet add-on homepage (jump to the end of this tutorial to get the link) and install it. No need to mention that you must be signed in to your Google account to install the add-on.
Step 2: While running the add-on for the very first time, it will prompt access to your Google account. Permit the access and then the add-on will be ready for you.
Step 3: Open a Google Sheet that contains extra rows and columns. And then, click Add-ons menu. There you will find Crop Sheet option. Under that option, there will be two sub-options: Crop to data and Crop to selection.
Step 4: Use the first option if you haven’t selected the data. This option will automatically remove all the blank rows and columns from your sheet. If you have selected rows and columns that you want to keep, then select the second option.
In a blink of an eye, all the extra columns and rows will be deleted from your Google Sheet.
There can be many reasons when you don’t want to see the extra rows and columns in a Google Sheet. You have some private Google Sheet in which you don’t want to add any extra details at all, or you have shared a sheet with some specific people and don’t want to let anyone else add. extra row or columns. Whatsoever is the case, this Crop Sheet add-on can be helpful for you.