
Tips.Net > ExcelTips Home > Formatting > Cell Formatting > 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:
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!
No, not that type of date. If you need to do any types of work with calendar dates, Excel has the tools you need. Learn how to use those tools the easy way. (more information...)
Ask an Excel Question
Make a Comment
ExcelTips FAQ
ExcelTips Premium
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