How do I change the Excel 2000 sheet tab size? It's too small.

K

Kelli

For some reason my sheet tab size is very very small. How can I change it to
be bigger?
 
G

Gord Dibben

Kelli

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
 
G

Gord Dibben

Thanks for the feedback Kelli.

When you're happy, we're all happy.

Gord Dibben Excel MVP
 
R

RagDyeR

This is really a Windows controlled property, which means that Word and
other applications will also be affected by this change.

Since the sheet tabs are actually located on the scroll bar, enlarging the
scrollbar will enlarge the tabs along with it.

Right click on your Windows desktop, and choose "Properties".
Click on the "Appearance" tab, and then on the "Advanced" button.
Expand the "Items" box, and click on "scrollbar".
My default size is 17, so an increase to 25 will make a very noticeable
change to the tab size, but play around to find your preference.

Don't forget, any changes apply to other apps as well.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

I'm looking for an answer to the same question.
Oscar
 
M

Max

Think its a windows setting

Try adjusting the "Scrollbar" size bigger to say: 25

In Windows XP:
Right-click at any empty spot in desktop > Properties
In Display Properties dialog, choose Appearance tab
Click "Advanced" button
In the Advanced Appearance dialog
Click the "Item" droplist > choose 'Scrollbar"
Set size to say: 25 > OK > Apply
 
R

RagDyeR

Tell me your original was 17, and it'll be stranger still, since I increased
mine from 16 a while ago in a test, and never changed it back.
 
G

Gordon

RagDyeR said:
This is really a Windows controlled property, which means that Word and
other applications will also be affected by this change.

Since the sheet tabs are actually located on the scroll bar, enlarging the
scrollbar will enlarge the tabs along with it.
Click to expand...

Isn't the OP talking about WORKSHEET tabs, not Taskbar tabs?

--
Registered Linux User no 240308
Just waiting for Broadband to complete the conversion!(3 weeks and
counting!)
gordonATgbpcomputingDOTcoDOTuk
to email me remove the obvious!
 
R

RagDyeR

Yes Gord, he is ... And sooooo?<g>
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------

RagDyeR said:
This is really a Windows controlled property, which means that Word and
other applications will also be affected by this change.

Since the sheet tabs are actually located on the scroll bar, enlarging the
scrollbar will enlarge the tabs along with it.
Click to expand...

Isn't the OP talking about WORKSHEET tabs, not Taskbar tabs?

--
Registered Linux User no 240308
Just waiting for Broadband to complete the conversion!(3 weeks and
counting!)
gordonATgbpcomputingDOTcoDOTuk
to email me remove the obvious!
 
G

Gordon

RagDyeR said:
Yes Gord, he is ... And sooooo?<g>
Click to expand...
Soooooo - it's not a Windows property, it's an Excel property and won't
affect Word 'cos Word doesn't HAVE tabs.

--
Registered Linux User no 240308
Just waiting for Broadband to complete the conversion!(3 weeks and
counting!)
gordonATgbpcomputingDOTcoDOTuk
to email me remove the obvious!
 
R

RagDyeR

Gordon,

The proof of the pudding is in the eating!
I usually say this to OPs ... Have you tried it ?

My post mentioned that the *SCROLL* (horizontal AND vertical) bar will be
enlarged, and since the sheet tabs in XL are on the scroll bar, they will be
increased in size also, as will the scroll bars in Word.
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------

RagDyeR said:
Yes Gord, he is ... And sooooo?<g>
Click to expand...
Soooooo - it's not a Windows property, it's an Excel property and won't
affect Word 'cos Word doesn't HAVE tabs.

--
Registered Linux User no 240308
Just waiting for Broadband to complete the conversion!(3 weeks and
counting!)
gordonATgbpcomputingDOTcoDOTuk
to email me remove the obvious!
 
G

Gordon

RagDyeR said:
Gordon,

The proof of the pudding is in the eating!
I usually say this to OPs ... Have you tried it ?

My post mentioned that the *SCROLL* (horizontal AND vertical) bar will be
enlarged, and since the sheet tabs in XL are on the scroll bar, they will be
increased in size also, as will the scroll bars in Word.
Click to expand...

I do find that MS has serious problems with joined-up thinking. OK, so
changing this WINDOWS setting changes the way Excel displays tabs within
a spreadsheet. BUT, if you change the negative number default by
selecting brackets in Regional settings in WINDOWS, Excel does NOT use
that default!!!!!! (Lotus does, and that's not an MS product!!!!)
Sheeeesh!

--
Registered Linux User no 240308
Just waiting for Broadband to complete the conversion!(3 weeks and
counting!)
gordonATgbpcomputingDOTcoDOTuk
to email me remove the obvious!
 
Top