200 Excel Shortcuts for PC and Mac

So you think you’re fancy, huh? Just because you know how to copy and paste without the click of the mouse in Excel. Well, get ready to be even fancier (and more productive) because we've curated 200 of the best Excel keyboard shortcuts.

Add adjacent cells to current selection – Microsoft Excel shortcut

While a cell is selected, press Shift and click on another cell. All adjacent cells in between selections will be selected. This can be on a single row or column as well as a range on different rows and columns.

Shift

Ctrl

Alt

shift

control

optionalt

command⌘

Shift Click

Worksheets and Workbooks View Row and Column Selection Ribbon Control Pivot Tables Operating within a Cell Navigating and Selecting Cells Help and Menus Group Selection General Excel General Cell Control Formulas and Functions Formatting Text and Numbers Dialog Boxes Borders Advanced Selection Adding Content to Cells

Back to Row and Column Selection

Get more Reference tips and tricks

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

Add adjacent cells to current selection – Microsoft Excel shortcut

Table of contents

Loved this? Then you’ll love our courses.