Excel shortcut keys come in handy to maneuver through Excel much faster and more efficiently. In fact, using shortcut keys is much quicker than using the mouse.
Navigational shortcut keys help the user move around within Excel. These shortcut keys allow the user to move across cells or worksheets.
All columns except column F contain hardcoded data. Column F contains cells with formula that multiply the corresponding row in column B with the corresponding row in column E. In other words, column F multiplies quantity with price to find total price. We will use this data to demonstrate the following excel shortcut keys.
The first group of excel shortcut keys involves navigational shortcuts.
Arrow keys move to next cell in the direction of the arrow key.
Ctrl + Arrow Keys will move to the end of a group of data in the direction of the arrow key. 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.
Shift + Arrow Keys will expand selection from current active cell towards direction of pressed arrow key.
Ctrl + Page Up/Down will move to previous or next worksheet/tab.
Shift + Ctrl + Page Up/Down selects adjacent worksheets in a group.
The next series of excel shortcut keys involves function and formula shortcuts. This helps you manipulate the data within the cells more efficiently.
Ctrl + D will fill down formula using the top most cells. This shortcut intuitively performs differently with different selections.
If the user has cell A2 selected before pressing Ctrl + D, cell A2 will fill with cell A1.
If the user has cell F3 selected, which contains the formula “=B3*E3”, cell F3 will fill with cell F2, which contains the formula “=B2*E2”. However, the formula is relative so it will adjust itself to “=B3*E3”
In this example, row 2 was selected before pressing Ctrl + D. Row 2 has filled itself with data from the row above.
In this example, the user has selected A2:F4 and pressed ctrl + D. Excel has taken the contents of the topmost cells (row 2) and filled the cells below.