ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   How do I change the size of my tabs in Excel workbooks? (https://www.excelbanter.com/setting-up-configuration-excel/9897-how-do-i-change-size-my-tabs-excel-workbooks.html)

Kelleybelly

How do I change the size of my tabs in Excel workbooks?
 
I recently changed the colors in "Accessories" to a different scheme. When I
did this, it shrunk the size of the tabs in my Excel workbook to barely
readable.

Gord Dibben

Kelley

This is a function of your Windows Display Properties.

The size of the sheet tabs are governed by the setting for Scrollbars in
Windows Display Appearance. Mine are at 18. Start there and work your way
up or down. The font will increase or decrease with the size of sheet tabs.

Win98 as example...

Start Settings Control Panel Display Appearance(WinXP
AppearanceAdvanced)

"Item" drop down select Scrollbar

Change setting to Taste
Apply
OK

Depending upon your settings, you may have to re-boot to see the changes.

Also note: this is a Global change and will affect all Applications.

Gord Dibben Excel MVP

On Tue, 25 Jan 2005 14:01:03 -0800, "Kelleybelly"
wrote:

I recently changed the colors in "Accessories" to a different scheme. When I
did this, it shrunk the size of the tabs in my Excel workbook to barely
readable.




All times are GMT +1. The time now is 05:40 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com