storylop.blogg.se

• #Excel shortcut keys select all data how to#

Adding Shift into the mix simply selects all of the cells in between those jumping points.

#Excel shortcut keys select all data how to#

Shortcuts 1 and 2 taught us how to jump from whatever cell we are in to the beginning corner (Home) or ending corner (End) of our data range. Shift + Space selects all cells in the current row, while Ctrl + Space selects all cells in the. To select large amounts of data containing many blanks, I recommend checking out this post for some alternatives:Ģ Keyboard Shortcuts to Select a Column with Blank Cells 6. Ctrl + A selects all the cells in the current data region. Complete cell entry in all cells in selected range. Complete cell entry and move cell cursor up one row. Complete cell entry and move cell cursor down one row. If so, this method may not be your best option. Arrow keys (,, , ) Complete cell entry and move cell cursor one cell in direction of the arrow. However, sometimes a column can have many blank cells. This process only selects cells that come before a blank cell. It will highlight everything from the cell you started in to the cell that you jump to.Īs before, the same concept applies using arrows that go in other directions. Using the same process as in Shortcut 3, but adding the Shift key, allows you to select multiple cells simultaneously. The keyboard shortcut to select multiple cells in a contiguous range is: That will jump you down to the last cell in the contiguous set of data for that column. Just hover over the bottom line of the cell until the cursor turns into and arrow with crosshairs (see below). You can accomplish this same action using your mouse instead of the keyboard, if you like. And of course, holding Ctrl while using the left or right arrow key accomplishes the same action horizontally instead of vertically. Repeating this process will move you further down the column to just before the next blank cell.Ĭtrl+ ? will reverse that process in the upward direction. For example, if you start at the top of a column and then press Ctrl+ ? you will jump to the last cell in that column before an empty cell. Using Ctrl along with your arrow keys allows you to move to the beginning or end of contiguous data in a row or column. The keyboard shortcut to select the last cell in a contiguous range is: