EXCEL tabs

  Heefie 00:14 29 Nov 04
Locked

At last I get around to why I signed on !!!

Excel tabs expand & reduce to allow the name of the tab to Worksheet to fit ... if it's called "AA" then the tab is small, if it's called "Billy Smither's babysitting timetable" it's big ...

Question ... Can I specify the size of an Excel Worksheet tab, even if that means the full name will not fit on the tab that is showing ?!?!?

  VoG II 00:17 29 Nov 04

Nope. Maximum 32 characters.

  Heefie 00:21 29 Nov 04

... I want the tabs to be smaller, as I know what they say ... the scrolling left and right, in this particular spreadsheet, is a pain !!!

The first 10 characters (for instance) would be more than sufficient ...

  PA28 09:28 29 Nov 04

Why don't you simply enter the first 10 characters then? It'll be as meaningful to anyone as a truncated longer sheet name and if that's all you need ..... you can always put the full name of the sheet in a cell elsewhere on the sheet for other users.

  Tog_ 10:08 29 Nov 04

Isn't it possible to create buttons for the toolbar that will navigate you to the relevant sheet?

  Shas 11:20 29 Nov 04

Four arrows to the left of the worksheet tabs - if you right-click on any of them you get a pop up box listing all the tabs and you can select the one you want. Is this what you mean Tog_?

  pj123 11:27 29 Nov 04

As PA28 suggests. Why not just rename them to the size you want. As an "Oldie" I tend to still use the old DOS 8.3 format and abbreviate all my file names.

  Tog_ 11:59 29 Nov 04

IIRC (it was in my previous job), when the project expenditure sheets came round, along the top were a bunch of buttons created using macros (VB?). Selecting one would perform a specific calculation on the input figures and take you to the result but I'm sure that the result was on a different sheet to the input.

  Heefie 16:59 29 Nov 04

... this spreadsheet has information in the tab that is not avaiable anywhere else in the Worksheet and that information is used by various buttons, formulae and hyperlinks ... both on each individual worksheet and in a master / index worksheet.

It's not a *problem*, as such, it would just make navigation a bit easier sometimes ... doesn't look like it's possible though, from replies so far, never mind !!!

  VoG II 17:26 29 Nov 04

Sorry, I totally misunderstood your question (it was late).

Right click on the navigation arrows, bottom left. You will then see a pop-up list of all the sheets.

  Heefie 17:48 29 Nov 04

... how simple !!!!!!!!

Thanks for that, so simple, LOL !!!!

This thread is now locked and can not be replied to.

Best phone camera 2016/2017: Galaxy S7 vs iPhone 7 vs Google Pixel vs HTC 10 Evo vs OnePlus 3T vs…

1995-2015: How technology has changed the world in 20 years

Best Christmas Agency Projects of 2016

Super Mario Run preview | Hands-on first impressions of Super Mario Run: Mario's iPhone & iPad…