Clrt end

B

Berko

In a sheet you can, by using Ctrl-Home, go to the cel A1.
Using Ctrl-end you should go to the last used cel of the sheet.
In mine case, this is cel AB102, but I end in cel CD302!
Can I make a "Ctrl-end" in cle AB102?
All the cells outside the cells A1 to AB102 are deleted.

Marcel
 
P

Peo Sjoblom

Select all cells from row 102 down, do edit>delete and save the workbook,
repeat with all columns from AB to IV. Save workbook
You might have to restart excel with excel 97

Regards,

Peo Sjoblom
 
M

Myrna Larson

You probably didn't delete the excess rows and columns -- you probably pressed
the Del key which just clears the contents. You have to Edit/Delete. You may
also have to save the workbook, close and re-open it for the new size to be
recognized.
 
Top