Turning into normal proportions

  • Thread starter Thread starter Bla
  • Start date Start date
B

Bla

Hi,

I somehow managed to (unintentionally) populate the whole - I mean from
bottom to top, from left to right, over million rows) sheet with
borders. I don't know how it happened, so I couldn't figure some smart
way to get rid of them (it surprised me when I opened the file the next
day), so I manually erased them.
The consequence is - the sheet became huge!
It's version 2007 and I don't have experience with this version.
How can I make the sheet 'normal'?

Thank you.
 
Select all rows below and all columns right of your actual data range.

Delete these rows and columns..................do not just clear contents.

Then save the workbook.


Gord Dibben MS Excel MVP
 
Back
Top