Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Has anyone come across an issue involving incorrectly displayed formatting?
One particular cell shows Arial, Bold, 9, but does not display as the adjacent cell with the same formatting. The worksheet does not contain conditional formatting, does not make use of styles, and there are no discernable differences except Word Wrap between the formatting on that cell against the others; however, upon using the Find feature to see if there are other cells with similar formatting, only that cell is returned in the results. This issue can be corrected using the Format Painter, but I would be interested in knowing what caused this issue and how it can be prevented in the future. If you would like to see the workbook in question, let me know. This is my first post to the forum and I do not see where the file can be posted along with the message. Thank you! |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Copuld be what display you are seeing "in" the cell, is actually a carryover
from the cell to the left of it, formatted differently.....and of course when you click on the cell you get IT's formatting info, not the one next to it........ Vaya con Dios, Chuck, CABGx3 "MINI_Micia" wrote: Has anyone come across an issue involving incorrectly displayed formatting? One particular cell shows Arial, Bold, 9, but does not display as the adjacent cell with the same formatting. The worksheet does not contain conditional formatting, does not make use of styles, and there are no discernable differences except Word Wrap between the formatting on that cell against the others; however, upon using the Find feature to see if there are other cells with similar formatting, only that cell is returned in the results. This issue can be corrected using the Format Painter, but I would be interested in knowing what caused this issue and how it can be prevented in the future. If you would like to see the workbook in question, let me know. This is my first post to the forum and I do not see where the file can be posted along with the message. Thank you! |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Shrink to fit? I'd be happy to look at it if you want to email it to me.
-- Jim "MINI_Micia" wrote in message ... | Has anyone come across an issue involving incorrectly displayed formatting? | One particular cell shows Arial, Bold, 9, but does not display as the | adjacent cell with the same formatting. The worksheet does not contain | conditional formatting, does not make use of styles, and there are no | discernable differences except Word Wrap between the formatting on that cell | against the others; however, upon using the Find feature to see if there are | other cells with similar formatting, only that cell is returned in the | results. | | This issue can be corrected using the Format Painter, but I would be | interested in knowing what caused this issue and how it can be prevented in | the future. If you would like to see the workbook in question, let me know. | This is my first post to the forum and I do not see where the file can be | posted along with the message. | | Thank you! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Problems changing cell formatting | Excel Discussion (Misc queries) | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
Possible Lookup Table | Excel Worksheet Functions | |||
cell formatting problems | New Users to Excel | |||
Cell formatting behaviour question | Excel Discussion (Misc queries) |