Exceljet

Quick, clean, and to the point

Extend selection by one cell up

Windows shortcut

Shift↑

Mac shortcut

⇧↑

If multiple cells are selected, Excel will extend the entire top edge of the current selection.

See all shortcuts

Related videos

The videos below demonstrate this shortcut.

Shortcuts for selecting cells in Excel

In this video we show you some of Excel's shortcuts for selecting cells.

Shortcuts for extending selections

In this lesson, we cover shortcuts you can use to extend selections.

Download 200+ Excel Shortcuts

Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.

Topics

Key functions

Hi - I'm Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts. Read more.

I just wanted to say thank you for building such an amazing resource. I'm an intern at a tech company and a lot of my projects require heavy use of excel. I've been using this website for everything from formatting to building a fully functional financial modeling tool. I have never used excel before but resources like this leave me feeling confident and capable. :) -Sunny

Extend selection by one cell up

Related videos

Download 200+ Excel Shortcuts

Excel video training