How to remove the empty row

[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!

[Dave Peterson]

Debra Dalgleish shows techniques to reset that used cell:
http://contextures.com/xlfaqApp.html#Unused

Alan Tang wrote:
>
> 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!

--

Dave Peterson

[Bill Sharpe]

Alan Tang wrote:
> 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!
Highlight a cell in the empty row.
Edit - Delete - Rows - Entire Row

Bill

[Selvarathinam]

> Alan Tang wrote:
> > 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?
> >


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

[Patricia Shannon]

Sometimes that works for me, sometimes not.
What I finally found is that doing a save-as to itself will fix the file.

"Bill Sharpe" wrote:

> Alan Tang wrote:
> > 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!
> Highlight a cell in the empty row.
> Edit - Delete - Rows - Entire Row
>
> Bill
>

[Patricia Shannon]

p.s. I have Excel 2003

"Patricia Shannon" wrote:

> Sometimes that works for me, sometimes not.
> What I finally found is that doing a save-as to itself will fix the file.
>
> "Bill Sharpe" wrote:
>
> > Alan Tang wrote:
> > > 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!
> > Highlight a cell in the empty row.
> > Edit - Delete - Rows - Entire Row
> >
> > Bill
> >