Keyboard Shortcuts in Excel
Keyboard shortcuts in Excel help you carry out tasks directly from the keyboard, which increases your working speed and efficiency. In this tutorial, you will learn about a few important Excel shortcuts and their uses.
π Basic Excel Shortcuts
Select cell B2.
1. Press CTRL + A to select the entire range of data. If you press CTRL + A again, Excel will select the entire worksheet.
2. Press CTRL + C if you want to copy the range. Press CTRL + X if you want to cut the range.
3. Go to cell A6 and press CTRL + V to insert the range.
4. Use the shortcut CTRL + Z to reverse the last change.
π Moving (Excel Navigation Shortcuts)
Select cell B2.
1. To move directly to the bottom of your data range, hold down the CTRL key and press the Down Arrow key.
2. Hold CTRL and press the right arrow (β) to navigate swiftly to the right edge of your data range.
Try it yourself. Hold the CTRL key and press the arrow keys to quickly move across the edges of a range.
π SelectingΒ
Select cell A1.
1. Press and hold the SHIFT key, then press the Down Arrow key repeatedly to select cells downward.
2. Press and hold SHIFT, then press the right arrow key repeatedly to select cells to the right.
3. Select cell A1 below (Sheet2).
4. Press CTRL + SHIFT + β to select all the data in a column at once.
Note: Use the shortcut CTRL + SHIFT + β to select data across a row in one step.
π Excel Formula Shortcuts
Select cell F2.
1. To apply the SUM function quickly, press ALT + =, and then press Enter.
2. Click on cell F2, then hold the SHIFT key and press the Down Arrow two times.
3. To apply the formula to the cells below, use CTRL + D.
Note: In the same way, you can copy a formula to the right by pressing CTRL + R.
π Excel Formatting Shortcuts
Select the range B2:F4.
1. To open the Format Cells dialog, press CTRL + 1 on your keyboard.
2. Press the TAB key, then press the Down Arrow key two times to choose the Currency format.
3. Press the TAB key, then press the down arrow twice to set the decimal places to 0.
4. Press Enter.
Result:
5. Select the range of cells and press CTRL + B to bold them quickly.
π Workbook
Open a workbook. In simple terms, a workbook is your Excel file.
1. To save your current workbook, press CTRL + S. To save it with a new name or location, press F12 to open the Save As dialog box.
2. To create a new workbook, hold CTRL and then press N.
3. To access an existing workbook, use the shortcut CTRL + O.
4. To exit the active workbook, use the keyboard shortcut CTRL + W.
5. To shut down Excel or other applications, press ALT + F4.
The workbook below has 3 worksheets. Click Sheet2 to make it the active sheet.
6. Press CTRL + Page Down to quickly switch to the next sheet (Sheet3).
7. Use CTRL + Page Up to jump to the previous worksheet (Sheet1).
1/11 Completed! Learn more about keyboard shortcuts β
Next Chapter: Count and Sum