Unable to "Delete Blank Rows"
Posted on 2014-03-10
I know this gets asked a lot, so here is what I've tried...
1. Select Sheet by clicking on the corner button to the left of 1 and above A
2. Press F5
3. Select Special
4. Select Blanks
5. Click on Home Ribbon > Cells > Delete Sheet Rows
Then I repeat steps from 1 to 3 and confirm the blanks have not been deleted.
Frustrated, I select the blank rows manually (using the thing on the left to select the entire row). I press the clear formatting button on the Home Tab > Editing Group.
Then I repeat steps from 1 to 3 and confirm the blanks have not been deleted. More frustruated I select every cell to right of my data and delete all the columns. Then I do the same for every row below my data.
Then I repeat steps from 1 to 3 and confirm the blanks are still not deleted.
Please, can someone tell me what I can do to quickly delete the 'so-called' blank cells?
Is there something hidden that I don't know about on the worksheet? I have many sheets where this is an issue.
So far I have found 1 tedious solution that works, I need to copy my data range to a new sheet in a new workbook then select the whole sheet and copy it back over my original range. There must be a better way!!!
Pls let me know if you've seen this before or have any ideas,