| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problems changing cell formatting
I have "inherited" a workbook used to generate budget documents. As part of
the book, there are several sheets that contain the formatted €śform€ť which includes boxes or borders around certain cells. My problem is I cannot change the format of these cells using the €śFormat:Cells€ť menu or the Ctrl+1 shortcut. I can however copy a format to these cells to change them. Unfortunately, if I happen to copy something to the cell that is €śdetrimental€ť to my formatting I play the devil getting the formatting corrected. Another twist is I can change all of the formatting using toolbar functions, except for the bordering. The only way I can change the bordering is to copy another border format to the cell. What is €śwrong€ť with my spreadsheet and how do I €ścorrect€ť it so I can manipulate the cell formatting? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Transfer Cell Formatting for linked cells | Excel Discussion (Misc queries) | |||
| enhanced conditional formatting | Excel Discussion (Misc queries) | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
| xls worksheet formatting a single cell | Excel Discussion (Misc queries) | |||
| Formatting a cell as "text" in the number catagory. | Excel Worksheet Functions | |||
Threaded Mode
