Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ro Ro is offline
external usenet poster
 
Posts: 3
Default Apply Colors to Worksheet Tabs

can I apply the same color across multiple tabs instead of individually
appyling a color to each tab?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4,393
Default Apply Colors to Worksheet Tabs

Group the sheets by clicking the tab of the first sheet; hold Shift and
click tab of the last sheet
Now right click and use Color Tab
Note the colour is not really visible until you ungroup since selected tabs
always appear white
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Ro" wrote in message
...
can I apply the same color across multiple tabs instead of individually
appyling a color to each tab?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I get ONLY new info from 1 Worksheet to another automatical Elaine Excel Worksheet Functions 6 July 13th 06 05:45 PM
Excel - how about allowing colored worksheet tabs for organizing CEGuy28 Excel Worksheet Functions 2 November 26th 05 02:50 AM
How can I automate the naming of worksheet tabs? TJ Excel Discussion (Misc queries) 7 September 8th 05 12:01 AM
Comparing a list to a Calendar worksheet. PatrickL Excel Worksheet Functions 0 August 25th 05 04:21 PM
How do I work with the "dialogs" I can insert as worksheet tabs? Jerryclick Excel Worksheet Functions 1 August 8th 05 08:56 PM


All times are GMT +1. The time now is 04:14 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"