How to remove the empty row

  • Thread starter Thread starter Alan Tang
  • Start date Start date
A

Alan Tang

Hello:

After I have paste the cell from another worksheet. I found that it also
copy with the empty row. Everytime when I press Ctrl-End. It will jump
into the row that haven't data. How can I remove it so that the Ctrl-End
will jump to the last row of the data?

Thansk a lot!
 
Alan said:
Hello:

After I have paste the cell from another worksheet. I found that it also
copy with the empty row. Everytime when I press Ctrl-End. It will jump
into the row that haven't data. How can I remove it so that the Ctrl-End
will jump to the last row of the data?

Thansk a lot!
Click to expand...
Highlight a cell in the empty row.
Edit - Delete - Rows - Entire Row

Bill
 
Hi Alan,

Select the entire data & press Ctrl+G or F5 -> Select "Special" -> and
select "Blanks"

Then all the blank rows will be selected & delete all the rows.

Hope it will solve ur problem.

Cheers,
Selva
 
Sometimes that works for me, sometimes not.
What I finally found is that doing a save-as to itself will fix the file.
 
p.s. I have Excel 2003

Patricia Shannon said:
Sometimes that works for me, sometimes not.
What I finally found is that doing a save-as to itself will fix the file.
Click to expand...
 
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
Excel Cannot delete empty cells/rows 4
ignoring empty??? 7
Moving a bunch of data 1
Looking for the value that indicates last row number that has filled cells 3
Copying Row Code Doesn't Copy Conditional Formating 10
adding rows into the table 1
Hide rows in table based on 1 empty cel of the same row. 1

Back
Top