You can explore a data block, or jump to the next data block, wherever it is, using the Control + Arrow keys. This shortcut moves to the edges of a block of data, or it jumps to the next block of data, or, if you are in an empty cell, it moves to the next cell with data in it.
So, if you are in a block of data, Control + Arrow keys will take you to the edge of that block of data, in the direction you are moving.
If you are already on the edge of a block of data, Control + Arrow keys will take you to the next block of data, in the direction you are moving.
If you are in an empty cell, Control + Arrow keys will bring you to the next block of data, in the direction you are moving.
And if you are already on the edge of the all the data in a spreadsheet, Control + Down arrow will jump you to row 1048576, and Control + Right arrow will jump you to column XFD! But don’t worry, just use Control + Up arrow or Control + Left arrow, respectively, to get back to your data, wherever it is!
Jump around Data Blocks in an Excel Spreadsheet
posted in: Shortcut of the Week
0
Leave a Reply