Removing empty rows

  • Thread starter Thread starter Hendy
  • Start date Start date
H

Hendy

Anyone help with this one?

Try to remove empty rows from a spreadsheet.

Hend
 
Hi Hendy

Do you mean empty rows between rows with data or rows at the bottem
of your sheet
 
If there is a single column that you can rely on to be able to say:-

'If the cell is this column is blank, then delete the row'

then select that column and do Edit / Go To / Special / Blanks

then Edit / Delete / Entire row
 
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

Finding Last Entry in a Column 1
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
JSON to CSV Conversion Gone Wrong: Got a Single Line of 991 Entrieswith Cells In Between. How Do I F 13
UDF To Calculate Work hours between two dates Problem with code 4
Excel Add ^ to a row of cells containing letters 3
If the cell is not empty, then... 5
Hide rows in table based on 1 empty cel of the same row. 1

Back
Top