Programs: Microsoft Excel Chapter 2: Lesson 3


Lesson 3:  In this lesson you will learn about how to make and use borders, patterns, and shading.  You will then learn how to adjust the page layout.
  • Borders
  • Shading
  • Patterns
  • Adjusting the Page Layout
Borders Borders

A border provides lines around a cell or cells to add additional emphasis.  You can outline the entire selection, or you can choose the specific side or sides that you wish to emphasize.  Border types can vary.  You can choose the thickness, color and style of the lines based on how much you wish to emphasize the chosen section.

To go about making a border, you must first highlight all desired cells.  Then click on Format on the toolbar at the top of the screen.  When a pull-menu appears click on Cells and then on the tab that says Border.  Once at this box, you are free to choose from the available line styles, line colors, and border types.  Remember to click OK to apply your choices to your work.

Shading Shading
Adding shading (or color) to your excel worksheet allows you to emphasize your work in addition to or without a border. 

There are two ways to add color into your work:  The first option is to use the pull down menu.  After highlighting the cell or group of cells that you want to color, click on Format on the top of the screen.  Then click on Cells and then on the tab that says Patterns.  In the top left hand corner, you will see many boxes of color.  Click on the color that you want to highlight your cell or cells with.  Make sure that no pattern is selected.  You will learn how to apply patterns to your work shortly.  Remember to click OK to apply your choice to your work.

The second option is to use the toolbar.  Once again, highlight everything in your worksheet that you want to be colored.  Then, click on the down arrow next to the fill color button (the button looks like a paint can about to be tipped over).  Simply click on the color that you wish to use, and your selection will be changed to that color.
Patterns Patterns
Adding different patterns into your excel worksheet allows you to further emphasize a cell's or group's cells contents. 

There is only one way to add patterns to your work.  You use the same pull down menu that you would use to add color to your work.  After highlighting the group of cells that you wish to emphasize, click on Format and then click on Cells.  Next, click on the tab that says Patterns.  Once there, click on the down arrow next to the patterns box to view all available patterns.  Click on the pattern you wish to use, and view a sample of it in the Sample box.  Remember to click OK to apply your choice to your work.  

Adjusting the Page Layout Adjusting the Page Layout
Adjusting the page layout is used if you want to print your excel worksheet.  Traditionally, gridlines are used when a spreadsheet is printed.

Once you have decided that you want to print your project, you need to tell the printer that you want it to print the gridlines as well.  First, click on File then Page Setup.  Next, click on the tab marked Sheet.  Underneath the Print section, you will see a box next to the word Gridlines.  Make sure that the box has a check mark in it.  If it does not, click on the box to put a check mark in it.  Remember to click on OK to exit out of the Page Setup box and to have the gridlines appear on the printed document.

Quiz

1.   Lines around a cell or group of cells to add additional emphasis

2.   Another word for ‘Shading’

3.   Can be accessed using the pull down menu or the toolbar

4.   Traditionally used when printing a spreadsheet

5.   Box located under the ‘Patterns’ tab that allows you to preview the color and/or pattern that you will be      applying to your work. 

6.   To access borders, patterns or shading, you must first click on this pull down menu

7.   Can only be accessed using the pull down menu

8.   To print gridlines on your excel worksheet, you must first access this pull down menu

9.   You must first _______ the cells you wish to change before doing anything else

10. The tab where the ‘Print Gridlines’ option is located

A.   Sheet                                                                   B.   Sample

C.   Borders                                                               D.   Patterns

E.    Format                                                                F.   Highlight

G.   Color                                                                  H.   Shading

I.    File                                                                       J.   Gridlines

Lesson Review

In this lesson we covered how to make borders, shading, patterns and adjusting the page layout. You learned how to make borders, how to apply patterns and shading to your work, and how to adjust the page layout in order to print the gridlines of your excel project.

 

  • Borders are used to emphasize the cells in a spreadsheet.
  • Shading is used to color the cell around the text.
  • Patterns can only be accessed by pull down menu and are effectively used to create style within the cell.
  • Adjusting the page layout makes sure that you have the gridlines printed.

 Back to Lesson # 2

Continue to Lesson # 4 

Lab Exercise #3

Back to Excel Lessons 


Programs: Microsoft Excel Chapter 2: Lesson 3