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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How could I return to the first row after I finish the last entry? 11
how do I copy the last 20 entries in an expanding list 4
Excel Cannot delete empty cells/rows 4
Getting To End Of Worksheet 1
Excel 2003 - Ctrl-End selects last cell. How chg last cell addr? 2
How do I copying data from a cell on sheet to a diff cell/sheet 1
Find last cell in a column, Delete its contents and make it active 5
copy cells from multiple pages to one sheet w/ if statement 8

Back
Top