Format Cell is not working consistently

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ken Krone - 18 Oct 2003 22:30 GMT

I have a worksheet in which I can format some columns with data can be
formatted by right-clicking, Format Cells, but other columns with data
will not. The dialog box for formatting does not appear.

Other worksheets do not have the problem and the Format Cells dialog box
appears as it should.

Any idea where I start to troubleshoot this?

Thanks
Ken K

Reply to this Message

Ken Krone - 18 Oct 2003 22:34 GMT

This is Excel 2000, SP3

> I have a worksheet in which I can format some columns with data can be
> formatted by right-clicking, Format Cells, but other columns with data
[quoted text clipped - 7 lines]
> Thanks
> Ken K

Reply to this Message

Dave Peterson - 19 Oct 2003 01:50 GMT

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?

> I have a worksheet in which I can format some columns with data can be
> formatted by right-clicking, Format Cells, but other columns with data
[quoted text clipped - 7 lines]
> Thanks
> Ken K

Signature

Dave Peterson
ec35720@msn.com

Reply to this Message

Ken Krone - 19 Oct 2003 02:46 GMT

Hi. Thanks for responding.

The file was created by Excel 2000.

Very strange. I can click on Column A, right-click, select Format
Cells, and all works just fine. However, on some columns, no dialog box
appears when I click on Format Cells.

Ken K

>The only time I've seen this is when the workbook was created by another program
>(Lotus 123 and Crystal Reports, for me).
[quoted text clipped - 18 lines]
>>Thanks
>>Ken K

Reply to this Message