ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   In Excel 2003, why does the format cells option not work? (https://www.excelbanter.com/excel-discussion-misc-queries/78713-excel-2003-why-does-format-cells-option-not-work.html)

ERNIE H

In Excel 2003, why does the format cells option not work?
 
We have an "Inspection master" form that has been cut/pasted, cell formatted
and re-formatted many times. Now when selecting cells and cell groups the
format cells function does not work.

Michael

In Excel 2003, why does the format cells option not work?
 
Hi Ernie H. Each spreadsheet can have only so many formats, around 4,000 I
think. You might try making a copy of your spreadsheet, selecting the entire
sheet and eliminating all formats except the font to see if you can then
start formatting again. HTH
--
Sincerely, Michael Colvin


"ERNIE H" wrote:

We have an "Inspection master" form that has been cut/pasted, cell formatted
and re-formatted many times. Now when selecting cells and cell groups the
format cells function does not work.



All times are GMT +1. The time now is 07:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com