If you use Microsoft Excel on a regular basis, then you're probably familiar with tabs. But those of us that are long time spreadsheet users have a greater appreciation for how wonderful they are; that's because workbook tabs weren't always available. Workbook tabs were introduced in Microsoft Excel 95; before that, you only had one sheet per file (I know, scaring isn't it?)
Naturally, the greatest attributes of tabs is being able to organize several related spreadsheets in one file (or workbook), and to link between all of them. Most users know that you can also double click on a tab to rename it. Did you know that you can change the order of the tabs by clicking and dragging them? Good. But ... did you also know that by holding down the CTRL key while you click and drag that you can make a copy of that worksheet?
If you haven't done so, you just right-click on a tab to see the other options available to you. For example, you'll find another to rename, move or copy sheets (for those that are mouse challenged.) Being able to change the color of a tab by right-clicking is a great way add some spice to your workbook.
You'll also find a way to select all of your sheets. But for precise selection (and those that are NOT mouse challenged), you can click on the first sheet and then use the CTRL-click to select other sheet one by one, or SHIFT-click to select a range of sheets. What's so important about selecting sheets you may ask? Something unknown to most users is that whatever tasks you perform in Microsoft Excel (including typing in a cell) happens to all of the worksheets selected, whether it's one sheet or several.
The only thing that used to bother me a little was the size of the tabs ... just a bit small. Ready for something I didn't even know? I learned this morning that you can actually change the size of those tabs (yeah!!!). Check out this neat tip from John Walkenbach's website The Spreadsheet Page. It could change your life!