200 Excel Shortcuts for PC and Mac

Learn Microsoft Excel Download PDF

Select all other cells in "region"

With an active cell selected, use this shortcut to select all other cells within the region. By region, Excel is referring to all clustered cells around that which you have selected until a break in the data.

Ctrl Shift *

Shift Control Space

Get more Excel tips and tricks

Subscribe to our email updates and get Excel tips direct to your inbox.