Auto Format

[FLKULCHAR]

This is interesting:

I wish to apply one of the auto-formats to my selection of cells, and...

IT DOES NOT WORK; I select the range of cells, properly select
auto-format, etc.

HOWEVER, IF I GO TO A BLANK WORKBOOK, THEN SELECT A GROUP OF BLANK
CELLS...APPLY THE AUTO FORMAT...IT WORKS...

THEN, I "COPY AND PASTE SPECIAL" (formatting only) INTO THE ORIGINAL
WORKSHEET, AND IT WORKS!!

Please help!

I do not wish to copy and paste special.

FLKulchar

[Jeff Stevens]

I have had similar problems with formatting when I use a file that was
converted from Lotus to Excel. Other than that, I'm stumped as well.


"FLKULCHAR" <FLKULCHAR@discussions.microsoft.com> wrote in message
news:7E29C628-3B7E-45F3-B84F-9D7FDFE0D37D@microsoft.com...
> This is interesting:
>
> I wish to apply one of the auto-formats to my selection of cells, and...
>
> IT DOES NOT WORK; I select the range of cells, properly select
> auto-format, etc.
>
> HOWEVER, IF I GO TO A BLANK WORKBOOK, THEN SELECT A GROUP OF BLANK
> CELLS...APPLY THE AUTO FORMAT...IT WORKS...
>
> THEN, I "COPY AND PASTE SPECIAL" (formatting only) INTO THE ORIGINAL
> WORKSHEET, AND IT WORKS!!
>
> Please help!
>
> I do not wish to copy and paste special.
>
> FLKulchar

[FLKULCHAR]

great...this file was converted from MSWORKS...ergo, same problem

"Jeff Stevens" wrote:

> I have had similar problems with formatting when I use a file that was
> converted from Lotus to Excel. Other than that, I'm stumped as well.
>
>
> "FLKULCHAR" <FLKULCHAR@discussions.microsoft.com> wrote in message
> news:7E29C628-3B7E-45F3-B84F-9D7FDFE0D37D@microsoft.com...
> > This is interesting:
> >
> > I wish to apply one of the auto-formats to my selection of cells, and...
> >
> > IT DOES NOT WORK; I select the range of cells, properly select
> > auto-format, etc.
> >
> > HOWEVER, IF I GO TO A BLANK WORKBOOK, THEN SELECT A GROUP OF BLANK
> > CELLS...APPLY THE AUTO FORMAT...IT WORKS...
> >
> > THEN, I "COPY AND PASTE SPECIAL" (formatting only) INTO THE ORIGINAL
> > WORKSHEET, AND IT WORKS!!
> >
> > Please help!
> >
> > I do not wish to copy and paste special.
> >
> > FLKulchar
>
>
>