Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Clrt end
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 |
#2
|
|||
|
|||
Select all cells from row 102 down, do editdelete 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 "Berko" wrote: 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 |
#3
|
|||
|
|||
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. On Fri, 14 Jan 2005 10:07:05 -0800, "Berko" wrote: 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 |
#4
|
|||
|
|||
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 "Berko" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|