The articles on this page cover a number of topics related to Excel worksheets - such as worksheet terms, adding and deleting worksheets, how to protect data in a worksheet, adding and removing columns and rows from a worksheet and much more.
This article provides a definition of "worksheet" as it is used in Microsoft Excel.
Parts of an Excel Worksheet
This article identifies the main parts of an Excel 2007 worksheet . There are links from each label to glossary items describing each part in greater detail.
Protect Worksheet Data
One of Excel's security features is the Protect Data option. What it does is allow you to lock up all or parts of a worksheet to prevent accidental or intentional changes by users. Part 1 covers locking/unlocking specific cells in a worksheet.
Protect Worksheet Data
Part two of protecting worksheet data involves applying the Protect Sheet option. Until step 2 is completed, all data is vulnerable to change.
Sort Worksheet Data
Excel's sort feature is a quick and easy way to sort data in a worksheet. The options for sorting data include:
- Sorting in ascending order - A to Z alphabetically or smallest to largest for number data.
- Sorting in descending order - Z to A alphabetically or largest to smallest for number data.
- Custom sorting - includes sorting by the cell background color or the font color of the data.
Freeze Worksheet Panes
Freezing worksheet panes keeps headings across the top and down the left side of the worksheet from disappearing when you scroll. This tutorial shows you how to "freeze" those sections of the worksheet containing titles so that they remain visible at all times.
Insert New Excel Worksheet
One way to add a new worksheet can be added in Excel 2007 by clicking on the Insert Worksheet
tab at the bottom of the Excel screen. Another, quicker way is to use the keyboard shortcut to insert a new worksheet. This shortcut also works for Excel 2003.
Insert Worksheet Columns
This article shows you how, with a click of the mouse, you can easily add columns to an Excel worksheet.
Delete Worksheet Columns
As easy as it is to add columns to a worksheet, its just as easy to delete columns that are no longer needed.
Hide Worksheet Columns
Sometimes you don't need to delete columns, just get them out of the way for a while. This article will show you how to hide one or more worksheet columns in Excel.
Change Worksheet Tab Color
To find specific information in a large worksheet it is often useful to color code the tabs of worksheets containing related data. Similarly, you can use different colored tabs to differentiate between worksheets containing unrelated information.