Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 29th 04, 10:49 PM
Kelli
 
Posts: n/a
Default How do I change the Excel 2000 sheet tab size? It's too small.

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

  #2   Report Post  
Old November 29th 04, 11:44 PM
Gord Dibben
 
Posts: n/a
Default

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
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 Mon, 29 Nov 2004 14:49:01 -0800, "Kelli"
wrote:

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


  #3   Report Post  
Old December 1st 04, 05:23 PM
Kelli
 
Posts: n/a
Default

Hi Gord,

Thank you so much - this was exactly what I needed!

Kelli

"Gord Dibben" wrote:

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
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 Mon, 29 Nov 2004 14:49:01 -0800, "Kelli"
wrote:

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



  #4   Report Post  
Old December 1st 04, 11:11 PM
Gord Dibben
 
Posts: n/a
Default

Thanks for the feedback Kelli.

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

Gord Dibben Excel MVP

On Wed, 1 Dec 2004 09:23:08 -0800, "Kelli"
wrote:

Hi Gord,

Thank you so much - this was exactly what I needed!

Kelli

"Gord Dibben" wrote:

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
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 Mon, 29 Nov 2004 14:49:01 -0800, "Kelli"
wrote:

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




  #5   Report Post  
Old February 5th 05, 03:37 AM
racso
 
Posts: n/a
Default

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

"Kelli" wrote:

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



  #6   Report Post  
Old February 5th 05, 12:29 PM
RagDyeR
 
Posts: n/a
Default

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!
==============================================

"racso" wrote in message
...
I'm looking for an answer to the same question.
Oscar

"Kelli" wrote:

For some reason my sheet tab size is very very small. How can I change it

to
be bigger?



  #7   Report Post  
Old February 5th 05, 12:31 PM
Max
 
Posts: n/a
Default

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

--
Rgds
Max
xl 97
---
GMT+8, 1 22' N 103 45' E
xdemechanik <atyahoo<dotcom
----
"racso" wrote in message
...
I'm looking for an answer to the same question.
Oscar

"Kelli" wrote:

For some reason my sheet tab size is very very small. How can I change

it to
be bigger?



  #8   Report Post  
Old February 5th 05, 12:37 PM
Max
 
Posts: n/a
Default

Why size 25 ? Quite an amazing coincidence <g

--
Rgds
Max
xl 97
---
GMT+8, 1 22' N 103 45' E
xdemechanik <atyahoo<dotcom
----


  #9   Report Post  
Old February 5th 05, 01:17 PM
RagDyeR
 
Posts: n/a
Default

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.
--

Regards,

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

"Max" wrote in message
...
Why size 25 ? Quite an amazing coincidence <g

--
Rgds
Max
xl 97
---
GMT+8, 1 22' N 103 45' E
xdemechanik <atyahoo<dotcom
----



  #10   Report Post  
Old February 5th 05, 01:51 PM
Max
 
Posts: n/a
Default

"RagDyeR" wrote
Tell me your original was 17

... 18, pretty close <g
--
Rgds
Max
xl 97
---
GMT+8, 1 22' N 103 45' E
xdemechanik <atyahoo<dotcom
----




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to change the color of all series in an excel chart in one go. Mz2 Charts and Charting in Excel 1 January 20th 05 01:07 AM
How to change the color of all series in an excel chart in one go. Marielle Charts and Charting in Excel 1 January 17th 05 04:41 PM
Hyperlink to specific sheet in Excel Web File jd17 Links and Linking in Excel 0 December 8th 04 09:03 PM
How can I change size of the picture without changing chartobject? Marie J-son Charts and Charting in Excel 6 December 7th 04 12:34 PM
Fonts get size 1 and can't be changed after a procedure - even by excel GUI!! Marie J-son Charts and Charting in Excel 2 December 6th 04 04:11 AM


All times are GMT +1. The time now is 12:49 AM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017