Excel.Tips.Net Welcome toExcel.Tips.Net

Helpful Links

Tips.Net Home
ExcelTips Home
Ask an Excel Question
Make a Comment

Tips.Net Store

ExcelTips FAQ
ExcelTips Premium

Learn Access Now

Beauty Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Money Tips
Organizing Tips
Pest Tips
Pet Tips
Wedding Tips
Word2007 Tips
WordTips

Advertise on the
ExcelTips Site

Newest Tips

Assigning a Macro to a Keyboard Combination

Creating Scenarios

Using Message Boxes

Understanding Phantom Macros

Picking a Group of Cells

Running Out of Memory

Hiding Rows Based on a Cell Value

 

Increasing Font Size In Worksheet Tabs

Summary: While Excel does not have an intrinsic way to change the font in on a worksheet tab, Windows does. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.)

Many Excel users have problems with the size of font used to display names in the worksheet tabs used by Excel. Unfortunately, there is no way to change the font size within Excel, itself. This is because Excel relies on settings within Windows itself to control how worksheet tabs are displayed. They are considered part of the horizontal scroll bar used by Excel. Fortunately, Windows allows you to increase the size of your scroll bars. By doing so, you increase the size of Excel's worksheet tabs.

You change the size of scroll bars by following these steps:

  1. Get out of Excel. (You don't perform these steps within Excel, remember?)
  2. Right-click anywhere on the desktop. Windows displays a Context menu.
  3. Choose Properties from the Context menu. You will see the Display Properties dialog box.
  4. Make sure the Appearance tab is selected. (Click here to see a related figure.)
  5. In the Item drop-down list, select Scrollbar. (You can also choose the Scrollbar item simply by clicking the vertical scroll bar in the image at the top of the Display Properties dialog box.)
  6. Increase the value in the Size text box, just to the right of the Item drop-down list. Try a value that is only two or three greater than the value already there.
  7. Click on OK to close the Display Properties dialog box.

Jump back into Excel and check the size of the worksheet tabs. You can repeat these steps, as necessary, until you get just the right look. Understand, however, that you are modifying Windows' configuration information, not Excel's. This means that your changes will also affect other programs you use, not just Excel.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2690) applies to Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Remove Some Stress at Tax Time! Doing your personal income taxes can be a royal pain. Why not make the process just a bit less stressful with our 101-question checklist. You can prepare for filing your taxes with confidence, knowing you've covered all your bases.
 
Check out Filing Your Income Taxes Checklist today!