Topic: Worksheets

The following are additional topics related to the category listed above. A bracketed number after the topic indicates how many articles are related to that subject.

Tips, Tricks, and Answers

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

Condensing Multiple Worksheets Into One Excel provides a consolidation tool that allows you to easily combine the data from a bunch of worksheets into a single worksheet. This tip explains how you can use this tool. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Determining a Worksheet's Number When you add a new worksheet to a workbook, it receives a meaningful name such as “Sheet4” or “Sheet17.” If you want to determine a worksheet’s number—even after you change the worksheet’s name—here’s how to do it. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Disabling Moving Between Worksheets If you want someone to not be able to move from one worksheet to another in a workbook, you’ve got your work cut out for you. Here are some things you can try to disable this form of navigation. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Freezing Top Rows and Bottom Rows It is not unusual to need to see both your column headers and column totals in your data. How to display all this information at one time can be a frustrating aspect of worksheet design and usage. This tip provides some ideas that can help make the desired information accessible. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Generating Unique Numbers for Worksheets You may need to automatically generate unique numbers when you create new worksheets in a workbook. Here’s a couple of easy ways to do it. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Hiding and Unhiding Worksheets Not all of the worksheets in a workbook need to be open to the world and visible. You can hide worksheets by using the steps described in this tip. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Independent Radio Buttons Radio buttons and check boxes can be inserted in a worksheet using the Control toolbox. The purposes for which each is used is very different, as is their behavior. This tip uses the scenario of creating a bowling-pin form to illustrate how they differ. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Jumping to a Specific Worksheet When you’ve got a workbook that has a huge number of worksheets in it, jumping to a specific worksheet can be a challenge. Excel provides some tools to select from a large number of worksheets, but you can also create your own tool that will do the job even better. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Jumping to Alphabetic Worksheets Workbooks can contain many, many worksheets. If you want a quick way to jump to a specific worksheet, there are a couple of techniques you can apply. This tip describes those techniques, and even provides a macro that makes jumping to groups of worksheets even easier. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Moving from Sheet to Sheet You can use the keyboard to accomplish many common tasks in Excel. You can even use the keyboard to move between worksheets, as described in this tip. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Ordering Worksheets Based on a Cell Value Macros that sort your worksheets based on their name have been around for quite some time. You may not want to sort the worksheets based on name, but on the value in a cell on the worksheets. This tip provides a macro that provides just this type of sorting capability. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Protecting a Worksheet's Format You can protect various parts of your worksheets by using the tools built into Excel. One thing you can protect is the format of the worksheet, as described in this tip. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Putting Addresses on State-Specific Worksheets Got a bunch of data on a worksheet that you need to divide onto other worksheets, based on a specific piece of information in the data? You can do this manually or you can do it using a macro that examines your data and makes the move. Here’s how. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Quickly Inserting a New Worksheet Want the absolute fastest way to add a new worksheet to your workbook? All it takes is to know the handy shortcut highlighted in this tip. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Relative Worksheet References When you copy a formula from one place to another, Excel automatically adjusts the references within that formula relative to the target location of the copy. There is one big exception to this, which is references to worksheet names; these are not modified. This tip provides some ways that you can make the relative adjustments you need to make in formulas that contain worksheet references. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Renaming Worksheets Some easy steps to rename the worksheets in your Excel workbook. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Returning a Worksheet Name It can be handy to reference the name of a worksheet tab directly in a cell of the worksheet. This tip explains a couple of ways you can accomplish this nifty feat. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Saving Versions Do you want to save different versions of your workbooks as easily as you can save versions of a Word document? Excel doesn’t provide a tool that is nearly that easy, but there are a couple of approaches you can use to save different versions of your work. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Setting the Number of Default Worksheets Excel allows the user to determine how many default worksheets are in a new workbook. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Shortcut to Merge Cells Merging cells is a common activity, so it is a little surprising that Excel doesn’t include a shortcut for the task. You can, however, create your own shortcut using a macro, as described in this tip. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Shortcut to Move Between Two Worksheets It is not uncommon to have workbook where two of the worksheets get more use than any of the others. If you want to easily switch between these two worksheets, you’ll love the shortcuts discussed in this tip. Implement them, and you’ll be quickly switching worksheets in no time! Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Switching Headers in a Frozen Row Excel allows you to “freeze” rows in your worksheet. What if you want the rows that are frozen to change as you scroll through the worksheet? There is no way to do that directly in Excel, but you can use a macro to approach a solution. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Synchronized Workbook and Worksheet Names When you work on older workbooks in Excel, you may notice that the name of the worksheet tab and the workbook itself are the same. This is by design, and something you can correct. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Viewing Two Worksheets At Once If you need to work on two worksheets in the same workbook at the same time, Excel makes this rather easy to do. All you need to do is display two windows and arrange them to both be visible. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

More Topics

Tips, Tricks, and Answers

Problems with Dates?

Helpful Links

Great Info!

RSS Feeds