How To Create A Pattern In Excel

Please Note: This article is written for users of the following Microsoft Excel versions: 97, 2000, 2002, and 2003. If you are using a later version (Excel 2007 or later), this tip may not work for you. For a version of this tip written specifically for later versions of Excel, click here: Changing Cell Patterns.

Changing Cell Patterns

Excel allows you to easily change the background pattern used in the cell. In the early days of spreadsheets, patterns were the only way you had to differentiate one cell from another. To change cell patterns, follow these steps:

Select the cells whose background patterns you want to change.
Choose Cells from the Format menu. Excel displays the Format Cells dialog box.
Make sure you have the Patterns tab selected. (See Figure 1.)

Figure 1. The Patterns tab of the Format Cells dialog box.

Use the Pattern drop-down list to select any of the available patterns.
Click on OK.

You should note that any pattern you select appears in the background of the cell, meaning that it appears behind any information contained within the cell. Thus, by creatively combining patterns, pattern colors, and other formatting options, you can create many, many different special effects.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2763) applies to Microsoft Excel 97, 2000, 2002, and 2003. You can find a version of this tip for the ribbon interface of Excel (Excel 2007 and later) here: Changing Cell Patterns.

Author Bio

With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He is president of Sharon Parq Associates, a computer and publishing services company. Learn more about Allen...

MORE FROM ALLEN

Creating a Drop Cap

Drop caps can be a nice finishing touch for some types of documents. Word allows you to create three types of drop caps, ...

Discover More

Wrapping Spaces

Add more than one space after the end of a sentence, and you may find that the extra spaces wrap to the start of new ...

Discover More

Positioning Graphics Evenly

If you need to arrange a group of graphics so that they are evenly distributed between a starting point and an ending ...

Discover More

More ExcelTips (menu)

Easy Value Hiding

Want a quick and easy way to hid the information in a cell? You can do it with a simple three-character custom format.

Discover More

Changing Cell Colors

If you need to change the color with which a particular cell is filled, the easier method is to use the Fill Color tool, ...

Discover More

Displaying Negative Percentages in Red

Excel includes quite a few different formats you can use for the information in a worksheet. One format that isn't as ...

Discover More