top of page
Search

MS Excel: Special Cells Selection Shortcuts for windows, mac, web

  • Writer: Fakhriddinbek
    Fakhriddinbek
  • 3 hours ago
  • 2 min read

Excel offers a wide array of shortcuts to help users work faster and more efficiently. One particularly powerful feature is the ability to quickly select special types of cells, such as blanks, constants, formulas, and more. These shortcuts are essential for data cleaning, auditing, and efficient formatting. Below is a comprehensive guide to all the Special Cells Selection shortcuts in Excel 2021 for Windows, Mac, and Excel for Web.


Excel window showing a spreadsheet. The title reads "Comprehensive Special Cells Shortcuts in Microsoft Excel 2021." A logo is in the corner.

Why Use Special Cells Selection Shortcuts?


  • Speed Up Workflow: Quickly identify and select cells of interest (e.g., blanks or formulas).

  • Improve Data Quality: Useful for cleaning and validating large datasets.

  • Consistency Across Platforms: Knowing the right shortcut works similarly across Windows, Mac, and Web versions.


Full Table of Special Cells Selection Shortcuts

Action

Windows Shortcut

Mac Shortcut

Excel for Web

Open Go To dialog box

F5

Fn + F5

Ctrl + G

Open Go To Special dialog box

Ctrl + G → Alt + S

Cmd + Fn + F5

Ctrl + G → Alt + S

Select all constants

F5 → Alt + S → Alt + O

Cmd + Fn + F5 → O

Ctrl + G → Alt + S → Alt + O

Select all formulas

F5 → Alt + S → Alt + F

Cmd + Fn + F5 → F

Ctrl + G → Alt + S → Alt + F

Select all blanks

F5 → Alt + S → Alt + K

Cmd + Fn + F5 → K

Ctrl + G → Alt + S → Alt + K

Select all visible cells only

Alt + ;

Cmd + Shift + Z

Alt + ;

Select current region (data block)

Ctrl + Shift + *

Cmd + Shift + *

Ctrl + Shift + *

Select entire worksheet

Ctrl + A (twice)

Cmd + A (twice)

Ctrl + A (twice)

Practical Use Cases


  • Select blanks: Replace missing values or highlight data gaps.

  • Select formulas: Check for calculation errors or inconsistencies.

  • Select visible cells: Copy/paste only visible data when filters are applied.


These shortcuts, once mastered, can drastically reduce your time spent navigating through large spreadsheets.


Whether you're a data analyst, financial professional, or student, incorporating these Excel shortcuts into your daily workflow will enhance your productivity and data-handling capabilities.




Comments

bottom of page