getting rid of blank area

  • Thread starter Thread starter JB
  • Start date Start date
J

JB

Hi
When I export certain work to excel, the rows end up in the 6000 when really
there are only usually max 250 - 300 rows.
I saw somewhere that if you go to the last cell (ctr+end) and you delete all
the rows blank to there, your last cell will be where you want it.
But that doesn't work.
I end up having to copy my working area and pasting it to a new worksheet
and then deleting the original.
Surely there's a better way?
Thanks for any solutions.
Jen
 
It does work if done correctly.

After deleting the "unused" rows you must save the workbook.

Earlier versions required a save and close then re-open to see the changes.


Gord Dibben MS Excel MVP
 
Back
Top