Borders and shading in Excel - Cell-by-Cell Formula Trace

Sample Data

A simple list of fruits with quantities and prices to demonstrate borders and shading.

Cell	Value
A1	Item
B1	Quantity
C1	Price
A2	Apples
B2	10
C2	0.5
A3	Bananas
B3	5
C3	0.3
A4	Cherries
B4	20
C4	1.2

Formula Trace

No formula used; this example focuses on applying borders and shading to cells.

Step 1: Select range A1:C4

Step 2: Apply thick outside border

Step 3: Apply thin inside borders

Step 4: Shade header row A1:C1 with light gray fill

Cell Reference Map

Item

↓

Apples

↓

Bananas

↓

Cherries

The range A1:C4 is selected for borders and shading. No formulas reference these cells.

Result

  +---------+----------+--------+
1 | Item    | Quantity | Price  |
  +=========+==========+========+
2 | Apples  | 10       | 0.5    |
  +---------+----------+--------+
3 | Bananas | 5        | 0.3    |
  +---------+----------+--------+
4 | Cherries| 20       | 1.2    |
  +---------+----------+--------+

Header row shaded light gray; thick border around all; thin borders inside.

The table shows a thick border around all cells, thin borders between cells, and the header row shaded in light gray to stand out.

Sheet Trace Quiz - 3 Questions

What does applying a thick outside border do?

A Removes all borders

B Colors the inside cells with gray

C Creates a strong outline around the selected cells

D Changes the font color

Key Result

Borders and shading are formatting features applied to cell ranges, not formulas.