remove all the empty rows at the end of my list?

  • Thread starter Thread starter rantz
  • Start date Start date
R

rantz

Many has asked how to remove blank rows. My problem is that I have
values in the first approx 20000 rows and then its blank until 64000
something. This means it's very hard to quickly find the last row. It
would be so much easier to just be able to move the scroll down to the
last row and find my last row with values.

So my question is. How can I remove all the empty rows at the end of my
list?
 
Rantz

Ensure you select the entire rows, not just the cells, by clicking on the
row numbers and then select edit>delete (not clear or pressing the delete
key). Now save the workbook and the scrollbars will act as normal and move
you to your last 'real cell'

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
 
You must log in or register to reply here.

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

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Looking for the value that indicates last row number that has filled cells 3
Excel Help to copy information from one row at a time to another sheet 1
adding rows into the table 1
Excel Cannot delete empty cells/rows 4
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
Hide rows in table based on 1 empty cel of the same row. 1
Excel Add ^ to a row of cells containing letters 3

Back
Top