Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Too many different cell formats
Dear All
I have a quite big excel and i am trying to make some changes in format and i receive the message "Too many different cell format" Probably i have many different cell formats. From where i can set up the format in order to know what must be the format of the excel file? I need away to identify the format from all sheets in order to give to the all sheets as common format as i can. Any ideas? |
#2
|
|||
|
|||
Hi Manos,
Some notes on "Too many different cell formats" see http://www.mvps.org/dmcritchie/excel...sp.htm#formats In the MS KB article it mentions using borders and formatting consistently. -- It is generally better to format all of the cells beforehand rather than copying the formatting of individual cells later. There are 8 borders on a cell (4 sides with inner and outer borders). A little help with English, the word "I" in referring to yourself is always capitalized just like the first letter of other "proper nouns". I sympathize with your problems of learning English never did well in it even though it is the only language I can actually speak/understand. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Manos" wrote in message ... Dear All I have a quite big excel and i am trying to make some changes in format and i receive the message "Too many different cell format" Probably i have many different cell formats. From where i can set up the format in order to know what must be the format of the excel file? I need a way to identify the format from all sheets in order to give to the all sheets as common format as i can. Any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cell color index comparison | New Users to Excel | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
Changing Cell formats to date fields automatically | Excel Worksheet Functions | |||
Can't open doc. Too many different cell formats. | Excel Discussion (Misc queries) | |||
How do I find out how many different cell formats an existing wor. | Excel Discussion (Misc queries) |