Clrt end

[Guest]

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

 

[Guest]

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

 

[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.

 

[Paul B]

Berko, have a look here on how to do it
http://www.contextures.com/xlfaqApp.html#Unused
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003