• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Change Tab Size in Excel 2013?

M

mnuttall87

New Member
How can you change the size of the tabs at the bottom in Excel 2013? Is there another setting to adjust the font size/white space size/etc? Is this done via XML schema? I know in Excel 2003/2007/2010 it worked by using the following method:

-Right click on your desktop and select Personalize.

-Click on Window Color (at the bottom of the screen).

-Click Advanced appearance settings.

-In the Item drop down box, choose Scrollbar.

-Set the Size box to a smaller number. (14 is a good size, 17 is default)

Click OK
 
This is determined by a Windows system-wide setting. To change it, select Start, Settings, Control Panel and double-click Display. In the Display Properties dialog box, click the Appearance tab, and choose Scrollbar from the Item list. Adjust the sheet tabs until they're the size you want. Be aware that this setting affects the scroll bars in all your applications.
 
Have you tried this combo in Excel 2013 and Windows 7 specifically with actual results? Your answer is exactly the solution I posted in my OP - it no longer works for Excel 2013.
 
Have you tried this combo in Excel 2013 and Windows 7 specifically with actual results?
Click to expand...

Not really, just thought I would post any old rubbish................Of course I have tried it, I do not post unless two things happen, one, I try it and two it works, as this does. 2013 and Win 7.


.
 
I have tried this method numerous times and had another Excel MVP test this method. The method posted adjusts the scroll bar size and does nothing to the size of the tabs. If anyone else has some insight or can confirm this method works and myself and an Excel MVP are just idiots, please reply.
 
Tried changing the Excel-wide font in options to no avail. I've run out of ideas for this one. I can't find any reference to tab height in the MSDN Developer Site for Excel either.
 
Hi Matt..

I tried atleast 4-5 times.. but not able to decrypt right now..
Still give a try.. ** Backup Registry strongly recommended

Run > Regedit > HKEY_CURRENT USER > Control Panel > Desktop > WindowMetrics

upload_2014-7-11_1-5-22.png

check for Binary ScrollWidth (if not found you can create Right Click > New > Binary Value > Name it as "ScrollWidth")
Default is -255 (same as 17 in in Display scrllbare size section)

after 4 -5 restart (as restart required to reflect changes in registry) in increasing / decreasing scroll height.. but Sheet Tab height looks like unchanged..

However.. the box size is changing with scroll size.. but the Font size of SheetName unchanged.. (I think so..)
upload_2014-7-11_1-2-21.png

Now its your turn to play.. :)
 
You must log in or register to reply here.
Back
Top