Worksheet Tabs

Tips, Tricks, and Answers

The following articles are available for the 'Worksheet Tabs' topic. Click the article's title (shown in bold) to see the associated article.

Dynamic Worksheet Tab Names
Would it be helpful if your worksheet tab names were determined by the contents of a cell in your worksheet? Using the macros described in this tip, you can easily make the worksheet tabs just as dynamic as any other part of an Excel worksheet.

Freezing Worksheet Tabs
It is possible for your workbooks to contain scores of worksheets. If you want to repeatedly jump back to a specific worksheet, navigating those sheets can sometimes get tedious. This tip discusses what you can do to make that navigation to a single worksheet easier than ever.

Getting the Name of the Worksheet Into a Cell
Excel allows you to change the names assigned to the worksheets in a workbook. If you want to have those names appear in a cell on the worksheet, there are a couple of ways you can approach the problem. Here's an assortment of techniques.

Increasing Font Size In Worksheet Tabs
While Excel does not have an intrinsic way to change the font in on a worksheet tab, Windows does.

Naming Tabs for Weeks
Need to set up a workbook that includes a worksheet for each week of the year? Here's a couple of quick macros that can do the hard work for you.

Picking Worksheets Quickly
If your workbook contains a multitude of worksheets, the worksheet tabs at the bottom of the program window start to loose a bit of their utility value. If you want a quick way to choose which worksheet to display, apply the technique described in this tip.

Referencing Worksheet Tabs
Ever want to use the name of a worksheet tab within a cell? Here's how you can access that information using the CELL function.

Sheets for Days
Need a quick way to have a worksheet for each day in a month? Here's a macro that makes the worksheet creation a snap.

Turning Off Worksheet Tabs
Look at the bottom of a worksheet and chances are you will see tabs for all the worksheets in the current workbook. Want to hide those tabs? You can do so by using the steps described here.