1. Computing
Spreadsheet Borders and Shading
Spreadsheet Borders and Shading
© Ted French
Adding formatting to a spreadsheet is done to make it easier to read and understand the important information it contains. Two formatting options available in Excel to help do this are borders and shading. Both options are used mainly to focus attention on specific data in the spreadsheet.

Borders can be used add an outline to a cell or range of cells. They are often used to emphasis cells containing formulas or functions. Shading alters the background color of selected cells. It is often added to title and total rows or to highlight alternate rows of data in a spreadsheet.

To find out how to accomplish this last task watch the video on how to - Create Borders and Shading in Excel.

Related Articles
January 16, 2009 at 6:17 pm
(1) Will Bee says:

How about the shading that occurs when creating subtotals? I am pretty sure it is not my fault (!) because the book I am using has the same shading in its pictures of the subtotals range that I created, but it does not explain why some lines are shaded and others are not. It is not the subtotal lines, nor the lines before or after those lines. It appears to be completely random, but mine are the same as the picture in the book.
Any ideas?? Thank you

Leave a Comment

Line and paragraph breaks are automatic. Some HTML allowed: <a href="" title="">, <b>, <i>, <strike>

©2014 About.com. All rights reserved.