| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't format cells in data range
Hi All.....
I just received a file that will not allow me to format individual cells within the data range. The file, or sheet, is not protected, and I can format entire columns or rows and individual cells outside the data range, just not those inidividual cells within. Anybody know what's up here? TIA Vaya con Dios, Chuck, CABGx3 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can't format cells in data range
Hold Cntrl and press ~ button which is available above the tab button.
TGV "CLR" wrote: Hi All..... I just received a file that will not allow me to format individual cells within the data range. The file, or sheet, is not protected, and I can format entire columns or rows and individual cells outside the data range, just not those inidividual cells within. Anybody know what's up here? TIA Vaya con Dios, Chuck, CABGx3 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can't format cells in data range
Thanks for the response.
I don't know what that does....it appears to be some kind of toggle that changes column widths, but it doesn't affect my "inability to format" problem. I failed to mention it before, but when I do RightClick FormatCells on one of those cells, I do not even get the pop-up box with the options. Vaya con Dios, Chuck, CABGx3 "TGV" wrote: Hold Cntrl and press ~ button which is available above the tab button. TGV "CLR" wrote: Hi All..... I just received a file that will not allow me to format individual cells within the data range. The file, or sheet, is not protected, and I can format entire columns or rows and individual cells outside the data range, just not those inidividual cells within. Anybody know what's up here? TIA Vaya con Dios, Chuck, CABGx3 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cond. Format Data Bars of range based on values of another range | Excel Worksheet Functions | |||
| format cells range | Excel Discussion (Misc queries) | |||
| format cells from data range | Excel Worksheet Functions | |||
| When entering data into a range of cells, select the entire range. | Excel Discussion (Misc queries) | |||
| how do i format a cell based on format of a range of cells? | Excel Discussion (Misc queries) | |||
Linear Mode
