ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Can't format cells in data range (https://www.excelbanter.com/excel-discussion-misc-queries/234141-cant-format-cells-data-range.html)

CLR

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



TGV

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



CLR

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




All times are GMT +1. The time now is 02:06 AM.

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