How do I change the size of my tabs in Excel workbooks?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
Appearance>Advanced)

"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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Tablet size: I love the 8 inches 1
Excel Protection 2
ViewSonic VG2757V-2K Display with Inbuilt Webcam and Multifunctional Docking Station Unboxing 4
ViewSonic VP16-OLED Unboxing: High-End Portable Monitor Designed for Creators 2
Different font sizes in different worksheet tabs 3
Excel Compare numbers on 1 tab to other tabs in workbook. 1
Windows 10 One of my previous builds is experiencing random, multiple BSODs 9
Recover lost excel tabs/spreadsheets from workbook 2

Back
Top