Erase All Empty Rows

  • Thread starter Thread starter Kartal
  • Start date Start date
K

Kartal

Hi All;
I prepared a data file but there are a lot of empty rows under the data.
Is there any way to erase all them?
Regards

Kartal
 
Kartal, you can't erase them but you could hide them, select the row below
you data hold down ctrl+shift and hit the down arrow then format rows hide
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
Thank you but I need to erase not to hide, if it is impossible then I will
think something else, (maybe try to fill up). Because I will use the data in
another application and that application requires full data.
Thanks...
Kartal
 
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

Drop Down List 2
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
Sort 3
Hide rows in table based on 1 empty cel of the same row. 1
Looking for the value that indicates last row number that has filled cells 3
Finding Last Entry in a Column 1
Memory Stick 4
JSON to CSV Conversion Gone Wrong: Got a Single Line of 991 Entrieswith Cells In Between. How Do I F 13

Back
Top