I would like to format the individual worksheets with a color for the sheet
itself. Is this possible in 2002? thanks for you help and advice
Candice
I would like to format the individual worksheets with a color for the sheet
itself. Is this possible in 2002? thanks for you help and advice
Candice
Hi!
Do you mean you want to color the sheet tabs?
Right click the sheet tab, select Tab Color.
Biff
>-----Original Message-----
>I would like to format the individual worksheets with a
color for the sheet
>itself. Is this possible in 2002? thanks for you help
and advice
>Candice
>.
>
No, I wanted to color the sheet itself... is that possible?
(Thank you for your thoughts)
"Biff" wrote:
> Hi!
>
> Do you mean you want to color the sheet tabs?
>
> Right click the sheet tab, select Tab Color.
>
> Biff
>
> >-----Original Message-----
> >I would like to format the individual worksheets with a
> color for the sheet
> >itself. Is this possible in 2002? thanks for you help
> and advice
> >Candice
> >.
> >
>
There is a way round this.
In paint, create a picture that is a single colour by using the fill tool. Save this
Then format > Sheet > Background and choose your newly created file
HTH
Hywel
Manchester UK
Select all the cells (ctrl-a, twice in xl2003).
Then format|cells|Pattern tab|
and choose a nice fill color
Mominator wrote:
>
> I would like to format the individual worksheets with a color for the sheet
> itself. Is this possible in 2002? thanks for you help and advice
> Candice
--
Dave Peterson
Thank you! Not what I had hoped for, but will do. Have a great weekend.
:-)
"Dave Peterson" wrote:
> Select all the cells (ctrl-a, twice in xl2003).
>
> Then format|cells|Pattern tab|
> and choose a nice fill color
>
>
>
> Mominator wrote:
> >
> > I would like to format the individual worksheets with a color for the sheet
> > itself. Is this possible in 2002? thanks for you help and advice
> > Candice
>
> --
>
> Dave Peterson
>
You can add a picture to the background, too.
Format|sheet|Background
Mominator wrote:
>
> Thank you! Not what I had hoped for, but will do. Have a great weekend.
> :-)
>
> "Dave Peterson" wrote:
>
> > Select all the cells (ctrl-a, twice in xl2003).
> >
> > Then format|cells|Pattern tab|
> > and choose a nice fill color
> >
> >
> >
> > Mominator wrote:
> > >
> > > I would like to format the individual worksheets with a color for the sheet
> > > itself. Is this possible in 2002? thanks for you help and advice
> > > Candice
> >
> > --
> >
> > Dave Peterson
> >
--
Dave Peterson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks