CORE EXCEL · Step 23 of 23

Draw the actual worksheet border you intend

Lesson guide and formula instructions

Before this step: Inspect a real worksheet cell and its unrounded formula. Distinguish gridlines from stored borders.

Draw Border traces cell edges; Draw Border Grid creates internal and outside edges across a gesture rectangle. Erasing one shared physical line must preserve other borders and the actual worksheet contents.

In Practice choose Thin green (#46685B), select H10 and use Draw Border Grid to drag inside B2 through D4. Undo and Redo the complete grid stroke once.
Use Erase Border on the shared C3/D3 boundary. Choose Draw Border, Double amber (#B87722), and trace only the bottom of D5; Escape leaves the tool.
Change B2 to the suggested quantity through the actual top bar. Explain the drawing path and border-only changes, predict the original total and independently check the full current/probe reports before saving the lesson.

Windows / Mac methods and focus

Desktop reference platformMethod in this lesson

Start here: Leave cell text editing. Choose line style/color, then use the intended cell edges or cells rather than an unrelated old selection.

Use the desktop pointer or menu method below.

Open Home → Borders arrow. Choose Draw Borders for outer edges or Draw Border Grid for a grid; set line color and line style.
Use Erase Border to remove a drawn boundary. The browser practice explicitly traces individual physical edges.

The cited Microsoft Windows instructions distinguish Draw Borders, Draw Border Grid and Erase Border. Gridlines and temporary teaching outlines are separate from stored cell borders. No universal Mac menu or print result is certified.

In this worksheet: Choose a labelled local pointer tool and draw directly on the actual worksheet. Escape cancels the stroke/tool; a completed gesture is one Undo group. The local edge-tracing tool is not arbitrary freeform ink.

Desktop references use the reviewed US-keyboard context. Function keys can require Fn. Use this lesson’s own platform selector and focus target for captured browser keys. Changing this reference selector does not run a worksheet command.

Microsoft: draw, grid and erase worksheet borders

Check the contextWhere must the relevant focus or selection be?Which boundary matters here?

This context check does not apply worksheet changes or complete the course exercise. Complete and check the actual workbook below.

Navigation does not record a passing attempt.

Applied lesson settings, explanations and source prediction: still needed

Original source

Teaching · read-only · E5

Step 1 / 5Inspect real cell borders and working formulas

Inspect

Gridlines and teaching outlines are not stored borders. Inspect the actual SUM and the separately typed outside values. Teaching is read-only; switch to Your turn to edit.

D2 · (blank)
No formula appliedD3 · (blank)
No formula appliedD4 · (blank)
No formula appliedD5 · (blank)
No formula applied

Sheet zoomPointer toolLineLine color

Loading your interactive spreadsheet…

Your turn on this worksheet

Choose Draw Border Grid, Thin, green #46685B. With H10 selected, drag inside B2 to D4. Undo and Redo that whole grid stroke.
Choose Erase Border and click or trace the shared boundary between C3 and D3.
Choose Draw Border, Double, amber #B87722. Trace only the bottom edge of D5. Escape leaves drawing mode.
Use the real top formula/value bar to change B2 to 6. Check every live Amount and the unrounded total.

Drawn borders are stored cell properties. Teaching highlights and ordinary gridlines are separate. Use Clear drawn borders if you want to repeat a demonstrated example. This page keeps no workbook or stroke ledger after reload.

What determines where a drawn border goes?What should a border stroke change?Original unrounded total in D5

Complete the actual pointer path and current workbook checks before saving a lesson record.

Actual stored borders, source values and gesture observations

[]{}