Extend current selection to the top edge of data – Microsoft Excel shortcut
This shortcut follows the same concept of extending your selection, but does so on a larger scale. Use this shortcut when you have a data-filled cell selected and you will instantly select all filled cells above. If the cell you are working on is empty, all blank cells to the end of the spreadsheet will be selected.
`
1
2
3
4
5
6
7
8
9
0
-
=
[
]
Lock
;
'
,
.
/
`
1
2
3
4
5
6
7
8
9
0
-
=
[
]
\
;
'
,
.
/
Ctrl Shift ↑
Table of contents
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 CellsGet more Reference tips and tricks
Subscribe to our email updates and get Reference tips direct to your inbox.