Borders and shading in Excel - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is the purpose of adding borders to cells in Excel?

Borders help separate and organize data visually, making it easier to read and understand the spreadsheet.

beginner

How do you apply a border to a selected cell or range in Excel?

Select the cells, then go to the Home tab, click the Borders button dropdown, and choose the border style you want.

beginner

What is shading in Excel and why is it useful?

Shading means filling cells with color. It helps highlight important data or separate sections for better clarity.

intermediate

Can you apply different border styles to different sides of a cell? How?

Yes. Use the Borders dropdown, then choose 'More Borders' to open the Format Cells dialog. There you can set different styles for each side.

beginner

What is the difference between 'All Borders' and 'Outside Borders' in Excel?

'All Borders' adds lines between every cell in the selection. 'Outside Borders' only adds a border around the outer edge of the selection.

Which Excel tab contains the Borders and Shading options?

A Home

B Insert

C Formulas

D Data

The Home tab has the Borders and Fill Color (shading) buttons.

What does shading a cell do?

A Adds a border line

B Fills the cell with color

C Changes the font style

D Deletes the cell content

Shading fills the cell background with color.

How do you remove all borders from selected cells?

A Delete the cells

B Clear contents

C Choose 'No Border' from the Borders menu

D Change font color to white

Selecting 'No Border' removes all borders from the selected cells.

Which option adds borders only around the outside edges of a selection?

A Outside Borders

B All Borders

C Thick Box Border

D Bottom Border

'Outside Borders' adds lines only around the outer edges.

Where can you customize border styles for each side of a cell?

A Data tab

B Insert tab

C Page Layout tab

D Borders dropdown > More Borders

The 'More Borders' option opens a dialog to customize each side.

Explain how to add shading and borders to a group of cells in Excel.

Think about the buttons on the Home tab for borders and fill color.

Describe the difference between 'All Borders' and 'Outside Borders' and when you might use each.

Consider how the borders appear inside the selection versus just around it.