1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.

Excel Worksheet Help

Articles on Excel Worksheet Features

By

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.

Worksheet Definition

Excel Worksheet
Excel Worksheet
This article provides a definition of "worksheet" as it is used in Microsoft Excel.

Parts of an Excel 2007 Worksheet

Parts of an Excel Worksheet
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 in Excel 2007 Pt. 1

Protect Worksheet Data
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 in Excel 2007 Pt. 2

Protect Worksheet Data
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 in Excel 2007

Sort Worksheet Data
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 in Excel 2007

Freeze Worksheet Panes
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 Worksheet in Excel

Insert New Excel Worksheet
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.

Add Columns to an Excel Worksheet

Insert Excel Worksheet Columns
Insert Worksheet Columns
This article shows you how, with a click of the mouse, you can easily add columns to an Excel worksheet.

Delete Columns from an Excel Worksheet

Delete Excel Worksheet Columns
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 in Excel

Hide Worksheet Columns
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 the Worksheet Tab Color in Excel 2007

Change Worksheet Tab Color
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.

©2014 About.com. All rights reserved.