Why is tab color greyed out in excel

Similar Threads cannot change tab color 2 Sep 18, Tab color? Sep 18, Tab color? Mar 15, How can I activate tab colors? Nov 29, Tab Key and Excel Jul 25, Excel Formating tab color. Nov 5, Tab Color. Aug 31, Custom Menu not tool bar. Apr 2, Changing worksheet tab colors. May 27, Click the plus sign next to any gray component to see which features were not installed.

Click the inverted triangle on the information bar that displays the name of the component. Choose "Run from My Computer" to activate missing features and unlock its menus in Excel Excel grays out some menus until you perform an action that precedes the use of the option. The Paste command is unavailable until you cut or copy data for use in your worksheet or the Clipboard.

Excel also grays out many menus while you are completing a formula. Check the formula bar first to make sure that your cursor is not in a cell with a formula in progress. Cancel or accept the formula to unlock inactive menus. Very frustrating there is already a colored tab in this spreadsheet so at one time I was able to access the menu item 'tab color. Sean Timmons. Is the workbook protected?

Is your workbook shared, if it is shared the coloured tabs will be grayed out and not available for compatibility reasons. I don't know how to determine if my workbook is protected. Go To Tools - Protection. If any of them say unprotect, you have protection on. Click on that option to unprotect it. Alternately, therer could be some sort of Macro or VB in the background, but I don't even want to venture into that territory in the event that it could od more harm than good.

Originally was shared on a network drive. But downloaded a copy to my own hard drive and still can't modify tab color. By shared, he means, if you look at the file name in your title bar does is say shared to the very right? If so, go to Tools - Share Workbook and remove the checkmark. A palette of Theme Colors and Standard Colors displays on the colors submenu. You can also use the ribbon to select a color for a tab. Make sure the worksheet tab for which you want to change the color is the active tab.

Then, make sure the Home tab is active on the ribbon. If you prefer using the keyboard you can press Alt, H, O, T in succession pressed separately, one after the other—do not hold any of the keys down.

To change the color of two or more contiguous worksheet tabs, click the first tab you want to select and then press Shift and click on the last tab you want to select. Then, right-click on any of the tabs in the selected group and change the Tab Color as shown earlier. To select multiple sheets that are not contiguous, click the first tab you want to select then press and hold Ctrl and click on the second tab you want to select. Continue this until all the desired tabs are selected. Then, you can select a color for the selected tabs the same way we described earlier.

Again, while the tabs are still selected, they are colored in a light gradient shade of the chosen color. Active worksheets with colored tabs have the light, gradient shade of the color and non-active colored tabs are solid colored. We only used red on the tabs in our example, but you can choose different colors for different tabs, as shown in the image at the beginning of this article. Browse All iPhone Articles Browse All Mac Articles Do I need one?

Browse All Android Articles Browse All Smart Home Articles Customize the Taskbar in Windows