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

On Wed, 14 Jul 2010 13:00:44 +0200, Bla wrote:

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.