Home :: Articles

Working with Excel Worksheets

An Excel workbook contains one or more worksheets where the data is stored, summarized, and presented. By default, when starting a new workbook, three blank worksheets are provided. As you go through a Microsoft Excel Training program, you'll learn how to manage your worksheets. In the meantime, here are a few tips to help you get started working with them.

The default names are Sheet1, Sheet2, and Sheet3 which don't tell you a thing about the contents of each worksheet. Fortunately, it's easy to name them. To do so, simply double-click on the tab of the sheet that you want to rename. Double-clicking highlights the name so that you can type over it. Give each sheet a descriptive name such as: Gas Prices by Month, Product List, or Tax Rates.

You can also rearrange the order of the worksheets. For example, if you want the first sheet in the sequence to be a worksheet that's located further in the arrangement, you can drag and drop the sheet to its new location.

Right-clicking on the tab of a worksheet opens up a submenu where you can do these tasks and more. Let's say that you want to draw attention to one worksheet, hide another, and protect one from having its data overwritten by others. You can do all of these tasks in this submenu.

Use the tab color option to assign a color to a particular worksheet. By doing this, you can color code your worksheets or highlight those that you want others to pay attention to.

Hiding worksheets is often done when you don't want others viewing the underlying data or when you want to make the worksheet less cluttered. Once hidden, you can easily unhide it by right-clicking once again and selecting Unhide.

Protecting a worksheet ensures that other users don't edit critical data. By right-clicking the tab of the desired worksheet and choosing Protect, you can assign privileges that users can and cannot do.

Want to learn more about worksheet management? Enroll in a Microsoft Excel 2003 Training or Microsoft Excel 2007 Training program and take control of your spreadsheets.