How do I get worksheet to end after last entry
 

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

How do I get worksheet to end after last entry
 

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.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Carmela Hall" wrote:

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

How do I get worksheet to end after last entry
 

Select row 543 then SHIFT + End + DownArrow

Or CTRL + SHIFT + DownArrow

EditDeleteEntire 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
wrote:

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