Sometimes I feel like the text on the worksheet tabs at the bottom of Excel is on the small side. Today I picked up a great tip from OfficeUsers.org, that tells you how you can increase the size of these tabs by increasing the size of your side and bottom scrollbars.

When you increase the scrollbar size, the size increases not just in Excel, but in every program you use. If you try increasing the size and don’t like it, don’t worry, you can always follow the same process and decrease the scrollbar size (17 is the default).

Increase Worksheet Tab Size by Increasing Scroll Bar Size

Windows 7

  1. Right click on your desktop and select Personalize.
  2. Click on Window Color (at the bottom of the screen).
  3. Click Advanced appearance settings.
  4. In the Item drop down box, choose Scrollbar.
  5. Set the Size box to a larger number. (I found 22 to be a nice size.)
  6. Click OK.

Windows XP

  1. Go to the Start Menu and select Control Panel.
  2. Double click Display and go to the Appearance tab.
  3. Click the Advanced button.
  4. In the Item drop down box, choose Scrollbar.
  5. Set the Size box to a larger number. (I found 22 to be a nice size.)
  6. Click OK.

Windows Vista

  1. Right click on your desktop and select Personalize.
  2. Click on Window Color and click Advanced appearance settings.
  3. In the Item drop down box, choose Scrollbar.
  4. Set the Size box to a larger number. (I found 22 to be a nice size.)
  5. Click OK.