# Hopefully a simple Excel question **URL:** \ **Category:** Factual Questions\ **Created:** [September 16, 2006, 1:40pm UTC](https://boards.straightdope.com/t/hopefully-a-simple-excel-question/372950 "2006-09-16T13:40:40Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![GorillaMan](https://avatars.discourse-cdn.com/v4/letter/g/50afbb/32.png) [@GorillaMan](https://boards.straightdope.com/u/GorillaMan)\ **Post date:** [September 16, 2006, 1:40pm UTC](https://boards.straightdope.com/t/hopefully-a-simple-excel-question/372950/1 "2006-09-16T13:40:40Z")
I’m not finding this one easy to Google… Is there a way to change the font of the text of the worksheet tabs? All that’s on the tab context menu is the tab colour, and I can’t see any option elsewhere. ---
**Author:** ![scotandrsn](https://avatars.discourse-cdn.com/v4/letter/s/a4c791/32.png) [@scotandrsn](https://boards.straightdope.com/u/scotandrsn)\ **Post date:** [September 16, 2006, 2:04pm UTC](https://boards.straightdope.com/t/hopefully-a-simple-excel-question/372950/2 "2006-09-16T14:04:30Z")
According to [this article](http://exceltips.vitalnews.com/Pages/T0642_Colors_and_Fonts_for_Worksheet_Tabs.html), you have to change some settings in Windows to do what you want. Which means you can’t save the appearance with the document, if you are planning on sharing it with someone else. ---
**Author:** ![scotandrsn](https://avatars.discourse-cdn.com/v4/letter/s/a4c791/32.png) [@scotandrsn](https://boards.straightdope.com/u/scotandrsn)\ **Post date:** [September 16, 2006, 2:08pm UTC](https://boards.straightdope.com/t/hopefully-a-simple-excel-question/372950/3 "2006-09-16T14:08:42Z")
I can’t find anything on Microsoft’s website that suggests any differently. Apparently they regard the tabs as part of the user’s environment, rather than as part of the worksheet itself. ---
**Author:** ![scotandrsn](https://avatars.discourse-cdn.com/v4/letter/s/a4c791/32.png) [@scotandrsn](https://boards.straightdope.com/u/scotandrsn)\ **Post date:** [September 16, 2006, 2:11pm UTC](https://boards.straightdope.com/t/hopefully-a-simple-excel-question/372950/4 "2006-09-16T14:11:36Z")
In further news, in VBA for excel, the [WorksheetName].Tab object does not seem to contain Font as a member, or any other formatting information except Color and ColorIndex. So you can change it for yourself, but not ship your changes along with the file. ---
**Author:** ![GorillaMan](https://avatars.discourse-cdn.com/v4/letter/g/50afbb/32.png) [@GorillaMan](https://boards.straightdope.com/u/GorillaMan)\ **Post date:** [September 16, 2006, 2:22pm UTC](https://boards.straightdope.com/t/hopefully-a-simple-excel-question/372950/5 "2006-09-16T14:22:04Z")
Bugger. Anyway, having it for myself would be better than nothing - but what font setting do I need to change?! ---
**Author:** ![scotandrsn](https://avatars.discourse-cdn.com/v4/letter/s/a4c791/32.png) [@scotandrsn](https://boards.straightdope.com/u/scotandrsn)\ **Post date:** [September 16, 2006, 2:37pm UTC](https://boards.straightdope.com/t/hopefully-a-simple-excel-question/372950/6 "2006-09-16T14:37:36Z")
> [@GorillaMan](#): > > Bugger. Anyway, having it for myself would be better than nothing - but what font setting do I need to change?! From my linked article: > [@](#): > > If you want to change the font used in a worksheet tab, you need to change the fonts used by Windows (not Excel) to displays information. You can right-click on your desktop, choose Properties, and then click on the Appearance tab. Changes you make on this tab will affect all programs running on your system, not just Excel. ---
**Author:** ![GorillaMan](https://avatars.discourse-cdn.com/v4/letter/g/50afbb/32.png) [@GorillaMan](https://boards.straightdope.com/u/GorillaMan)\ **Post date:** [September 16, 2006, 2:42pm UTC](https://boards.straightdope.com/t/hopefully-a-simple-excel-question/372950/7 "2006-09-16T14:42:52Z")
Oh, sorry, missed that. Maybe I won’t bother - I was thinking it was going to be an individual font in the Appearance - Advanced settings