CORE EXCEL · Step 16 of 23
Remove decoration without erasing meaning Before this step: Read the actual formula bar and distinguish stored data from its appearance.
No Fill and No Border remove selected layers. Clear Formats also removes number formats and fonts. Neither operation should replace your underlying calculations.
Inspect the current A1:E5 report, including its currency, percentage, header font and italic unit price. Teaching steps locate real cells; reset the original before independent practice. In Practice select A1:E5, enable both fill and border removal and clear those two layers once. Undo and Redo that operation: both layers must recover together. Keep every font, alignment, number format, source and formula; the outside ID and zero must remain intact. Explain the selected layers, predict the original report total and check this lesson. Windows / Mac methods and focus Desktop reference platformWindows Mac Method in this lessonRemove only the intended decoration
Start here: Select the bounded range and identify which appearance layers to remove.
Use the desktop pointer or menu method below.
Use Home > Borders > No Border to remove the selected cells’ applied borders. Remove fill separately when needed; do not substitute Clear Formats if other formats must remain. No Border removes applied borders; Clear Formats removes additional formats and is a different operation.
In this worksheet: Choose Fill/Borders in the selective layer controls, inspect the complete report and recover the grouped change with 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 No Border removes applied borders; Clear Formats removes additional formats and is a different operation. Clear Formats retains all number formats and font choices while removing only 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 [] 