How do I get worksheet to end after last entry

[Carmela Hall]

How do I get my worksheet to end at the bottom of my last entry.
Lets say my last entry is line 542, but if I hit Ctrl End it goes all the
way to Line 65082. This locks up my computer when I have to filter....
Can you please help........

 

[Shane Devenshire]

Hi,

Click row number 543, how down the Ctrl key and press the down arrow (to
select all the way to 65,536). Press Ctrl+- (control minus) and save the
file.

 

[Gord Dibben]

Select row 543 then SHIFT + End + DownArrow

Or CTRL + SHIFT + DownArrow

Edit>Delete>Entire Row.

Now save the workbook to reset the used range.


Gord Dibben MS Excel MVP

On Fri, 20 Mar 2009 12:13:02 -0700, Carmela Hall <Carmela