How do I get worksheet to end after last entry

  • Thread starter Thread starter Carmela Hall
  • Start date Start date
C

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