bottom
Great ExcelTips!
         
Your e-mail address is safe!
Close Note

Tips.Net > ExcelTips Home > Formatting > Cell Formatting > Changing Cell Patterns

Changing Cell Patterns

Summary: Cell patterns are a great way to highlight a cell and its contents. You set a pattern (or change an existing one) by using the Patterns tab of the Format Cells dialog box, as described in this tip. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.)

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 in Excel, follow these steps:

  1. Select the cells whose background patterns you want to change.
  2. Choose Cells from the Format menu. Excel displays the Format Cells dialog box.
  3. Make sure you have the Patterns tab selected. (Click here to see a related figure.)
  4. Use the Pattern drop-down list to select any of the available patterns.
  5. 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.

Tip #2763 applies to Microsoft Excel versions: 97 | 2000 | 2002 | 2003


Organize Your Data! Using the powerful sorting capabilities of Excel can help you get your data into just the order you need. Find out how you can use the full capabilities of sorting to your benefit.
 
Check out ExcelTips: Serioius Sorting today!

Helpful Links

Ask an Excel Question
Make a Comment

Tips.Net Home

ExcelTips FAQ
ExcelTips Premium

Learn Access Now

Beauty Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Money Tips
Organizing Tips
Pest Tips
Pet Tips
Word2007 Tips
WordTips

Advertise on the
ExcelTips Site

 

Great Info!

Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your e-mail address and click "Subscribe."
     
(Your e-mail address will never be shared with anyone, ever.)