Tips, Tricks, and Answers

The following articles are available. Click the article's title (shown in bold) to see the associated article.

Adding Borders to Cells A few quick ways to add borders to a cell or range of cells. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Adding Diagonal Borders Borders on all sides of a cell are easy to do in Excel. You can also create diagonal borders that run right through the middle of the cell. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Automatic Lines for Dividing Lists You can use conditional formatting to add automatic dividing lines between groups of data in your worksheets. This tip shows how easy it is to add the lines. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Changing the Color of a Cell Border Many people add borders to cells on a regular basis, yet have no clue that you can change the color of those borders. This tip shows how easy it is to get just the right hue for your cell borders. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Drawing Borders Adding borders to cells is normally done through Format | Cells. Excel provides an even easier way, however, that allows you to just click and draw the borders you want. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Removing Borders Want to quickly remove all the borders from a cell? There is no need to use the menus or display dialog boxes. Just use the handy shortcut provided in this tip. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Helpful Links

Ask an Excel Question
Make a Comment

Tips.Net Home
Vital News Home

ExcelTips FAQ
ExcelTips Premium

Learn Access Now

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

Advertise on the
ExcelTips Site

 

RSS Feeds

 Daily Nuggets (an ExcelTip every day)

 Allen Wyatt's ExcelTips (the weekly classic)