You can tell when the “used range” excel is using is too big and is going to add extra blank rows when you use the scroll bar to the right and it goes beyond the last row of actual data when you scroll to the bottom. Terrible when trying to print your data. I’ve found something, and corrected the procedure, so it consistently works to delete those blank rows.
Do this to get rid of them:
- Select the entire first row under the last row of data. Hit Ctrl + Shift + Down Arrow to select all the blank rows.
- From the Home Tab Select Clear and then Clear All from the Edit menu (picture of a whitish-grey eraser).
- Right-click and select Delete.
- Select the entire first column to the right of the last column of data. Hit Ctrl + Shift + Right Arrow to select all the blank rows.
- From the Home Tab Select Clear and then Clear All from the Edit menu (picture of a whitish-grey eraser).
- Right-click and select Delete.
- Goto cell A1 first and then Save.
- Press Ctrl + Home and then Ctrl + End (This should take you the correct last cell in the used range (above blank rows).
- Click Save again.
Have a nice day!
PS.
Microsoft… Any progress on adding those csv export options?