Is it possible to change the worksheet tab size?

excel excel-2016
Solar Mike picture Solar Mike · Jun 24, 2017 · Viewed 9.1k times · Source

I have lots of sheets in a workbook, all with short names, so is it possible to reduce the default size of the tab so I can see more sheets?

Answer

teylyn picture teylyn · Jun 24, 2017

There is no setting to change the sheet tab size. In Excel 2016, and in all previous versions, the sheet tab will be as wide as required to show the text.

Related questions

How to reference and refresh a QueryTable in Excel 2016 in VBA

I'm trying to refresh a query on a cell change, however I can't figure out how to reference the query. My code: Sheets("Roster Query").QueryTables(0).Refresh Just errors out with: Run-time error '1004': Application-defined or object-defined error I …

Read More
Remove AM/PM from "time" cell

I am calculating all the hours/minutes/seconds of all calls made on our PABX system. The cell has to be "time" format to display correctly. BUT, this adds an AM/PM at the end of the result as if …

Read More
Connecting to Oracle Database through Excel

I'm trying to connect to an Oracle Database on our server from an Excel sheet, but am having trouble understanding why. I currently have both 32-bit and 64-bit Oracle 12c installed in different ORACLE_HOMEs and have a 32-bit installation …

Read More