ExcelBanter - worksheet background color

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - worksheet background color (https://www.excelbanter.com/excel-discussion-misc-queries/17157-worksheet-background-color.html)

Mominator

worksheet background color

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

Biff

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
.

Mominator

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
.

Dave Peterson

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

Mominator

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

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

All times are GMT +1. The time now is 05:15 AM.