Set default cell format while retaining overrides

  • Thread starter Thread starter Paul
  • Start date Start date
P

Paul

Is there a way to set the *default* cell format for:

(1) a workbook while still retaining formatting that has been
specifically set for worksheets, rows, columns, and cells;

(2) worksheets while still retaining formatting that has been
specifically set for rows, columns, and cells; and

(3) rows and columns while still retaining formatting that has been
specifically set for cells?

In other words, is there a workbook-level default, overridable by a
worksheet-level default, overridable by a row/column-level default,
overridable by a cell-level format? I'd be looking at formatting such
as wrapping, alignment, numer representation format, etc.

I am using Excel 2003 on Windows XP.
 
Is there a way to set the *default* cell format for:

(1) a workbook while still retaining formatting that has been
specifically set for worksheets, rows, columns, and cells;

(2) worksheets while still retaining formatting that has been
specifically set for rows, columns, and cells; and

(3) rows and columns while still retaining formatting that has been
specifically set for cells?

In other words, is there a workbook-level default, overridable by a
worksheet-level default, overridable by a row/column-level default,
overridable by a cell-level format?  I'd be looking at formatting such
as wrapping, alignment, numer representation format, etc.

I am using Excel 2003 on Windows XP.
Click to expand...

Furthermore, is there a way to remove overrides at any of the above
levels so that the next higher level default is inheritted again?

One situation in which this would be useful is when I notice that some
rows are much taller than needed. I assume that the height has
somehow been manually set.
 
Furthermore, is there a way to remove overrides at any of the above
levels so that the next higher level default is inheritted again?

One situation in which this would be useful is when I notice that some
rows are much taller than needed.  I assume that the height has
somehow been manually set.
Click to expand...

Row autofit does not work, and googling indicates that this is a
common problem. So I tried to set all the rows to a specific height
to see if autofit would then respond.

Well.

I set the row heights to 0.5. Excel became unresponsive. If I had
known that formatting could cause a crash, I would have saved.

I am developing a psychological complex and expect to go into
convulsions when working with Excel. That's a nice way of
saying...things unmentionable in this forum.
 
Row autofit does not work, and googling indicates that this is a
common problem.  So I tried to set all the rows to a specific height
to see if autofit would then respond.

Well.

I set the row heights to 0.5.  Excel became unresponsive.  If I had
known that formatting could cause a crash, I would have saved.

I am developing a psychological complex and expect to go into
convulsions when working with Excel.  That's a nice way of
saying...things unmentionable in this forum.
Click to expand...

OK, I hope can save others the trouble...here is what I found works.
Manually oversize the height of all rows by dragging, not by what I
did above to cause a crash. Then autofit will work. Strangely
enough, I sometimes has to resize some column widths, even though the
text within was not enough to wrap (it was close to wrapping).
 
Back
Top