format the whole row

G

Guest

I know in older versions, the file size would be huge if
you formated a whole row rather then just the cells
required.
Does this still apply?
E.g. A workbook I am using seems to run rather slow. The
creator formatted many tables over about 25 sheets with
borders but he did so by selecting the rows rather then
the cells. I was wondering if I should take a couple
minutes and clear the formatting from those columns?

Thank you
Deborah
 
B

BrianB

I don't think changing formatting will make any difference.

You can easily check this out by making a copy of the workbook fo
testing
 
J

Jim Rech

I believe that formatting an entire row or entire column is very efficient,
since Excel needs only one formatting record for all 256/65536 cells.

--
Jim Rech
Excel MVP
|I know in older versions, the file size would be huge if
| you formated a whole row rather then just the cells
| required.
| Does this still apply?
| E.g. A workbook I am using seems to run rather slow. The
| creator formatted many tables over about 25 sheets with
| borders but he did so by selecting the rows rather then
| the cells. I was wondering if I should take a couple
| minutes and clear the formatting from those columns?
|
| Thank you
| Deborah
 
Top