CORE EXCEL · Step 17 of 23
Rebuild readable borders over a solid fill Before this step: Selectively remove fill/borders and recover that change with Undo and Redo.
A solid cell fill can hide ordinary gridlines. Explicit contrasting borders define the report: thin internal lines, a medium outer frame and a double total underline. None of these changes should alter the report calculation.
Reset the original, then repeat the Practice two-layer clear and its Undo/Redo on A1:E5. Apply dark green fill #163D32 and white text to A1:E5 while retaining every other font property and number format. Apply all thin white borders to A1:E5, then a medium white outside frame. Select A5:E5 and apply a double gold #FFD166 bottom border. Retain all source values and formulas, explain explicit borders versus gridlines, predict the original rounded total and check the complete current report. Windows / Mac methods and focus Desktop reference platformWindows Mac Method in this lessonChoose explicit cell borders
Start here: Select the target cells and inspect which edges will change.
Desktop key: Ctrl+1 · Selected worksheet cells
Open Format Cells and choose Border. Choose the intended edge positions and line settings. Applied borders remain distinct from gridlines, particularly over a fill.
In this worksheet: Use explicit Outside/Inside/Bottom edge controls with the chosen style; inspect actual cells and Undo.
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.
Check the context Where must the relevant focus or selection be?Choose a focus An actual workbook entry in the file-access list Selected worksheet cells, outside text editing The formula text editor, with its insertion caret Selected column headings and their right boundary The small fill handle of the selected seed cells The worksheet tab of the sheet being moved The worksheet grid and its active cell A cell entry or formula-bar editing target A real worksheet range, then its status-bar summary Only the selected true blanks, with a relative formula being entered The side or bottom selection border, away from the fill handle The workbook command area, outside cell text editing Which boundary matters here?Choose an explanation Applied borders remain distinct from gridlines, particularly over a fill. Changing gridline visibility creates persistent explicit cell borders. Check method context This context check does not apply worksheet changes or complete the course exercise. Complete and check the actual workbook below.
Save this checked exercise Navigation does not record a passing attempt.
Applied lesson settings, explanations and source prediction: still needed ← All practice Change decoration, keep the workbook Remove selected layers, inspect what survives, then build a readable report over the same actual cells.
Original source Small purchases Zero quantity and zero price Returns and small amounts Teaching · read-only Your turn · edit this sheet Reset original workbook
Check the current report Check current workbook All four report outputs and unchanged formulas are recalculated on three prepared originals and three independent source probes. Worksheet checks and course explanations are separate.
Download current formulas Download frozen values Files without a fresh complete workbook check are explicitly named unchecked. A frozen copy retains current styles and results without executable formulas. Nothing is uploaded.
Inspect actual worksheet capture [] 