getting rid of unwanted rows

Posted by derek on August 08, 2001 7:06 AM

i have to upload a excel spreadsheet to the as/400. i want to make sure that there are no blank rows at the end of the spreadsheet. how do i save the spreadsheet so there are no blank rows at the bottom.
.
thanks.

Posted by Mark W. on August 08, 2001 7:22 AM

Install a copy of ASAP Utilities' freeware at
www.asap-utilities.com and choose
Sheets | Reset Excel's last cell

or...

Choose the Edit | Go To... | Special... Last Cell
menu command, then delete all unused rows and/or
columns above and/or to the left of the selected
cell, and Save the workbook.