Larger and non-adjacent selections

Why this lesson matters: Larger and non-adjacent selections

Work safely with large ranges and separate areas. In this module, the skill supports a larger goal: Navigate, select, fill, and edit large worksheets with fewer mouse actions. The practical application is to apply one format to several input areas without touching formulas.

Ctrl/Command + click additional ranges

Build it step by step

Work from the business question toward the formula or tool. Keep the source data separate from the output and make every important assumption visible to the reviewer.

• Choose a safe starting cell.
• Use the smallest shortcut that selects the intended range.
• Pause and verify the selection before editing or deleting.

Check the result and common failure points

Check the name box and highlighted boundaries before applying a change to a large selection. Also test a known record, a missing or blank value, and a boundary case. Confirm that ranges are the same size, units are consistent, and copied references move only where intended.

• Compare at least one result with a manual calculation or filtered source record.
• Test blanks, zeros, duplicates, errors, and the exact rule boundary.
• Reconcile row counts or totals before relying on the output.

Use the result in a decision

Apply one format to several input areas without touching formulas. Label the output clearly, state its period and unit, and explain the action it supports. A technically correct result is only complete when another person can understand, refresh, and review it.