If the user currently has cell A2 selected and presses ctrl + down, Excel will move to cell A4.If the current active cell is at the end of a group of data and before a gap of empty cells, pressing this shortcut will jump the gap to the nearest cell with data in it in the direction of the arrow key. If the user currently has cell A2 selected and presses the right arrow key, Excel will activate cell B2.Ĭtrl + Arrow Keys will move to the end of a group of data in the direction of the arrow key.The first group of Excel shortcut keys involves navigational shortcuts.Īrrow keys move to the next cell in the direction of the arrow key. We will use this data to demonstrate the following Excel shortcut keys. In other words, column F multiplies quantity by price to find total price. Column F contains cells with a formula that multiplies the corresponding row in column B with the corresponding row in column E. Sample DataĪll columns except column F contain hardcoded data. These shortcut keys allow the user to move across cells or worksheets. Navigational shortcut keys help the user move around within Excel.

Excel shortcut keys select all data