ExcelBanter - How do I unhide the cell format function in Excel 2000

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I unhide the cell format function in Excel 2000 (https://www.excelbanter.com/excel-worksheet-functions/7941-how-do-i-unhide-cell-format-function-excel-2000-a.html)

Len Melcer

How do I unhide the cell format function in Excel 2000

I have a spreadsheet where the cells with data entered in them can have the
Format Cell option selected but any empty cells cannot have the Format Cell
option selected. I can enter text but am unable to format the cell afterwards.

Frank Kabel

Hi
any chance this sheet is protected?

--
Regards
Frank Kabel
Frankfurt, Germany

Len Melcer wrote:
I have a spreadsheet where the cells with data entered in them can
have the Format Cell option selected but any empty cells cannot have
the Format Cell option selected. I can enter text but am unable to
format the cell afterwards.

Len Melcer

Not in any obvious way. The Tools-Protection option appears to show the
sheet and workbook as unprotected.

"Frank Kabel" wrote:

Hi
any chance this sheet is protected?

--
Regards
Frank Kabel
Frankfurt, Germany

Len Melcer wrote:
I have a spreadsheet where the cells with data entered in them can
have the Format Cell option selected but any empty cells cannot have
the Format Cell option selected. I can enter text but am unable to
format the cell afterwards.

All times are GMT +1. The time now is 08:05 AM.