Shift + Ctrl + Page Up/Down selects adjacent worksheets in a group. Cell A2 will remain the active cell within the selection.Ĭtrl + Page Up/Down will move to previous or next worksheet/tab. If the user currently has cell A2 selected, and presses shift + down twice, Excel will select cells A2:A4.Shift + Arrow Keys will expand selection from the current active cell toward the direction of the pressed arrow key. If the user then presses ctrl + right another time, Excel will jump across the gap to the nearest non-empty cell to the right, thus moving to cell E4.If the user then presses ctrl + right, Excel will move to cell B4.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.

Pdf excel shortcut keys