Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / November 2007

Tip: Looking for answers? Try searching our database.

Changing Background Color Only

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Drake - 13 Nov 2007 19:19 GMT
I have a table in the middle of my sheet.  The background is just the
normal white cells.  I want to change the entire background to a solid
color, but I just can't get it to work.

Here is what I tried.  I highlighted my table, held down the ctrl key,
then highlighted the entire page, and then filled in the color...but
this doesn't work.

Any suggestions?

Thanks
Pete_UK - 13 Nov 2007 19:26 GMT
If you want just the table to be coloured, then highlight the cells
making up the table and click on the fill colour icon from the
formatting toolbar (if visible - if not then Format | Cells |
Patterns) and then click the colour you want.

Hope this helps.

Pete

> I have a table in the middle of my sheet.  The background is just the
> normal white cells.  I want to change the entire background to a solid
[quoted text clipped - 7 lines]
>
> Thanks
Drake - 13 Nov 2007 19:59 GMT
No, the table is the color I want it.  I want to have a solid
background color without disturbing the colors of my table.

Thanks

>If you want just the table to be coloured, then highlight the cells
>making up the table and click on the fill colour icon from the
[quoted text clipped - 16 lines]
>>
>> Thanks
Pete_UK - 13 Nov 2007 20:27 GMT
Okay then, set the background colour of all the cells to something
different - click the grey box at the intersection of the row and
column identifiers in order to highlight all the cells in the
worksheet (or CTRL-A {twice in XL 2003}), then click the fill icon and
choose your colour. Then highlight just the cells that make up your
table, click the fill icon and choose No Fill (or another colour).

Hope this helps.

Pete

> No, the table is the color I want it.  I want to have a solid
> background color without disturbing the colors of my table.
[quoted text clipped - 23 lines]
>
> - Show quoted text -

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.