format function

[fhl]

I'm in excel 2000. I have no protection set on the sheet or workbook; nor
any conditional formatting in the cells. I select a range of cells that I
want to format, when I go to format in the toolbar and click on cells nothing
happens. Any ideas on what to look for to allow "format" to be functional
would be appreciated.

 

[Spiky]

I'm in excel 2000. I have no protection set on the sheet or workbook; nor
any conditional formatting in the cells. I select a range of cells that I
want to format, when I go to format in the toolbar and click on cells nothing
happens. Any ideas on what to look for to allow "format" to be functional
would be appreciated.

What do you mean by "go to format in the toolbar and click on cells"?

 

[fhl]

After I select the cells, I put the cursor on format in the toolbar, that
brings up a drop down, wherer I select cells --------- it then does nothign
and returns my to the worksheet ratherthan showing me teh format options.

 

[Gord Dibben]

Probably means "go to format in the toolbar and click on cells" as in

Format>Cells


Gord Dibben MS Excel MVP

 

[fhl]

Gord Dibben

Please see my original question --any ideas about that?? Not sure why
Spiky asked a second question

Thanks

 

[Meebers]

How about trying this: select a cell(s) and while your pointer is within
that cell, right mouse click and choose format cells. Any thing after
that??

 

[fhl]

Thanks for the suggestion; but, that didn't work either!!!!

 

[Gord Dibben]

I saw the original but have no answer other than to google or search MS KB
articles.

I seem to remember one of the versions losing the ability to open Options from
Tools>Options.


Gord

 

[Spiky]

Gord Dibben

Please see my original question --any ideas about that?? Not sure why
Spiky asked a second question

Thanks

Sorry, I think you mean Menu, not Toolbar. Since there are many
formatting buttons in Toolbars, I wasn't sure what you meant. Anyway,
I get it now.

I don't remember anything specific about XL2000 on this topic. But
does this happen in every file or just a particular one? I have seen
files get corrupted in similar ways and just not work right. Sometimes
creating a new file and copying the data to it will fix the problem.

I guess my only other thought is to double-check that nothing is
Protected.