Select the Current Region (Ctrl+Shift+*)

Most Excel errors are workflow errors, not math errors. Select contiguous data quickly to apply formulas and formats. In practice, this is one of those shortcuts that compounds: the more rows, formulas, and revisions you have, the more time it saves.

Shortcut

• Windows: Ctrl+Shift+*
• Mac: Ctrl+Shift+Space

Why it matters for formulas

Formula work is mostly navigation, selection, and controlled repetition. When you can apply an action without leaving the keyboard, you reduce mis-clicks, maintain focus, and keep reference patterns consistent. That consistency is what makes formulas easier to copy, easier to audit, and easier to hand off.

How to use it

• Select the correct cell or range first so Excel applies the action where you intend.
• Use the shortcut, then confirm the immediate change (dialog opens, selection changes, or formula updates).
• If you plan to copy a formula, check which parts must stay fixed and lock them before filling.
• Commit the change, then validate with a fast spot-check on a few rows and edge cases.

Real-world example

Example: toggle formula view to scan a whole block for inconsistent references. The goal is to build a reliable pattern once, then apply it across the dataset using selection-and-fill methods instead of manual edits.

Windows vs Mac notes

On many Macs, function keys may require the Fn key depending on system settings. If you switch between platforms, write down your top 10 shortcuts with both key combos so you do not lose speed while context-switching.

Common mistakes

• Running the shortcut in the wrong context (for example, not in cell edit mode).
• Forgetting to lock a constant input before copying formulas across a table.

Pro tip: Pair this with a quick formatting step so outputs communicate meaning (currency, percent, date) and reviewers can sanity-check results faster.

Once this shortcut is in muscle memory, you will spend less time navigating Excel and more time improving the logic, readability, and reliability of your formulas.

Related guides: Index , Excel Switch Panes F6 , Excel Edit Active Cell F2 Windows Mac Variant 82 , Excel Function Arguments Ctrl A Windows Mac Variant 84 , Excel Keyboard Shortcuts Starter Kit Windows Mac

Related guides: Excel Insert Argument Names Ctrl Shift A Windows Mac Variant 85 , Excel Keyboard Shortcuts Paste Special Cleanup , Excel Paste Name F3 Variant 90 , Excel Expand Collapse Formula Bar Ctrl Shift U Variant 89 , Excel Insert Note Comment Shortcuts

Related guides: Excel Keyboard Shortcuts Navigation Selection , Excel Jump To Edge Ctrl Arrow , Excel Keyboard Shortcuts Formatting Number Formats , Excel Keyboard Shortcuts Named Ranges Name Manager , Excel Copy Formula From Above Ctrl Apostrophe

Share this guide:

← Back to Overview

Frequently Asked Questions about Select the Current Region (Ctrl+Shift+*)

Is Select the Current Region (Ctrl+Shift+*) suitable for beginners?

Yes, absolutely. Our guide to Select the Current Region (Ctrl+Shift+*) explains all basics clearly.

How much does Select the Current Region (Ctrl+Shift+*) cost?

Costs vary depending on the provider. A comparison is always worth it.

Where can I find more information?

Right here in our expert area for consumerguidepro-excel-keyboard-shortcuts.