Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Tab color changes to distinguish multiple sheets chosen
In Excel '97, when multiple sheets were chosen to make the same change on all
of the sheets, the tab colors would be distinctive to make the user aware that they were working on multiple sheets. This does not happen on Excel 2007, so after I have worked on the multiple sheet changes, if I forget or am distracted, and I return to Excel, I forget that I was working on multiple sheets, and am constantly thinking that I am working on one sheet, and thus end up changing multiple sheets unintentionally, which has been causing me headaches. Does anyone know about a cure? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Tab color changes to distinguish multiple sheets chosen
Hi,
Look at the title bar you will see the word [Group] when multiople sheets are selected. But there is no way to change the display of the tab color when selected, however, if you look closely the tab change shade a little. With no color applied to the tabs, their default, selected tabs a bright white and non-selected tabs are a dull light blue. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "kibrit" wrote: In Excel '97, when multiple sheets were chosen to make the same change on all of the sheets, the tab colors would be distinctive to make the user aware that they were working on multiple sheets. This does not happen on Excel 2007, so after I have worked on the multiple sheet changes, if I forget or am distracted, and I return to Excel, I forget that I was working on multiple sheets, and am constantly thinking that I am working on one sheet, and thus end up changing multiple sheets unintentionally, which has been causing me headaches. Does anyone know about a cure? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Tab color changes to distinguish multiple sheets chosen
Shane,
The only change of tab color that happens on my computer is the first sheet (which becomes bolded text) of the series. The rest of the sheets within the Group look as the same as the ones that are not in the group. The color of my tabs are defaulted to Gray and stay as such when selected. Your comment about the Group is helpful, but I tend not to look up there as often, but if there is no other distinctions in the tabs, I will have to make it a habit to look there. Thanks so much for your feedback! "Shane Devenshire" wrote: Hi, Look at the title bar you will see the word [Group] when multiople sheets are selected. But there is no way to change the display of the tab color when selected, however, if you look closely the tab change shade a little. With no color applied to the tabs, their default, selected tabs a bright white and non-selected tabs are a dull light blue. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "kibrit" wrote: In Excel '97, when multiple sheets were chosen to make the same change on all of the sheets, the tab colors would be distinctive to make the user aware that they were working on multiple sheets. This does not happen on Excel 2007, so after I have worked on the multiple sheet changes, if I forget or am distracted, and I return to Excel, I forget that I was working on multiple sheets, and am constantly thinking that I am working on one sheet, and thus end up changing multiple sheets unintentionally, which has been causing me headaches. Does anyone know about a cure? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel doesn't print the background fill color chosen for a cell | Excel Worksheet Functions | |||
How to distinguish text color changes done by Conditional Formatti | Excel Discussion (Misc queries) | |||
Print multiple excel sheets in color | Setting up and Configuration of Excel | |||
how to distinguish between text cells? | New Users to Excel | |||
XL print preview should show grayscale if chosen on color printer | Excel Discussion (Misc queries) |