Getting Started with Microsoft® Excel® 2003 Lesson 5: More Useful Worksheet Features

In this lesson, you will learn how to change sheet tab colors, check spelling in a worksheet, find and replace cell contents, and create an AutoCorrect shortcut. Next, you will learn how to split the worksheet view and how to hide and unhide cells, rows, columns, and worksheets. You will also learn how to protect and unprotect a worksheet. Finally, you will learn how to use custom lists to fill a range of cells.

Objectives

1. Change sheet tab colors
2. Check spelling
3. Find and replace cell contents
4. Create an AutoCorrect shortcut
5. Split the worksheet view
6. Hide and unhide cells, rows, columns, and worksheets
7. Protect and unprotect a worksheet
8. Fill a range using a custom list

Key Terms