August 29, 2011
Do you have a spreadsheet that contains an extra row in between each row that contains data? Here is a way to delete all of those blank rows and clean up your spreadsheet.
- Highlight the first column by clicking on the A at the top of the column.
- Press CTRL+Shift+L. This turns on the filtering feature. You will notice that as you do, a drop arrow appears on the right of cell A1.
- Click on this drop arrow. A dialog box opens. Select Text Filters and then Equals.
- In the blank box with the blinking cursor, type *.
- Click OK.
Keep in mind that this doesn’t actually delete the rows, it just hides them. If you want to delete those rows, and you are positive that none of the data rows are duplicates,
- Click on the cell above 1 and to the left of A in the top left corner of the spreadsheet. This will select the whole spreadsheet.
- Under the Data tab, in the Data Tools section, click Remove Duplicates.
- In the next box, uncheck all columns except Column A.
- Click OK.
And….here’s a second Tip FREE! If you want more room between your rows, change the height of them, don’t add rows between!
- Repeat step 1 above.
- Now move your cursor to the line between any two row numbers. See how the cursor changes to a different look?
- When it changes, grab the line and drag down until the row is the size you desire. All of the rows will change at the same time.