Unable to Display the "Format Cells" Dialog Box

  • Thread starter Thread starter Jack McMullan
  • Start date Start date
J

Jack McMullan

I have a worksheet which is NOT protected. With some
cells, when I try to display formatting options,
the "Format Cells" dialog box does not appear. I've tried
every method I can think of:
right-click, then select "Format Cells"
from the menu, choosing Format, Cells
keyboard short-cut - Ctrl - 1
All I get is my cell pointer in the cell I want to format,
but no dialog box. I've seen this happen in other
spreadsheets I've worked on, usually with files that have
been in existence for a while, used by various users,
could have had worksheets inserted/copied, etc.

Has anyone seen this before, and know how to repair it?
 
-----Original Message-----
I have a worksheet which is NOT protected. With some
cells, when I try to display formatting options,
the "Format Cells" dialog box does not appear.
Click to expand...

Jack

Try Detect and repair on the Help Menu. You may need the
Office CD.

Regards
Peter Atherton
 
Are the cells possibly outside the permitted scroll area? (Check: ca
you edit them?)
If so, get the Control Toolbox (from the View menu|Toolbars).
Select the Properties button (the second one).
Look at ScrollArea. If it is blank, this is not the cause.

Best of luck

Al
 
The only time I've seen this is when the workbook was created by another program
(Lotus 123 and Crystal Reports, for me).

I could select a little bigger range and get the dialog to appear. Then I'd
format this larger range and come back later to change the sacrificial cells
back to what they should be.

Any chance your workbook was created by something else?
 
Back
Top