How To Use Shortcuts For Microsoft Excel

How To Use Shortcuts For Microsoft Excel

VideoJug presents a short film showing how best to use shortcuts for Microsoft Excel. Speed up your work on Microsoft Excel with these great shortcut tips from VideoJug.

---

Step 1:

Select the current column

Type CTRL + spacebar to select the current column

---

Step 2:

Select the current row

Type SHIFT + spacebar to select the current row

---

Step 3:

Move to the beginning

If you want to move to the beginning of the worksheet, use CTRL + Home

---

Step 4:

Move to the end

To move to the last cell of the worksheet, use CTRL + End.

---

Step 5:

Paste a function

To past a function into a formula, type SHIFT + F3

---

Step 6:

Select all

To select everything (when you are not editing or editing a formula) type CTRL + A

---

Step 7:

Calculate all the sheets

To calculate all the sheets in an active worksheet, use F9

---

Step 8:

Calculate active worksheet

Use SHIFT + F9 to calculate the active worksheet.

---

Step 9:

Display go to box

Press F5 to display the 'Go To' box

---

Step 10:

Date

To enter the current date into the active cell - type CTRL + ;

---

Step 11:

Time

To enter the current time into the active cell, type CTRL + :

---

Step 12:

Enter / edit cell comments

To enter or edit a cell comment in the active cell, type SHIFT + F2

---

Step 13:

Copy functions

To copy the contents of a cell to the cell directly to the right, select the cell in which you want the copy, and then press CTRL + R.

To copy the contents of a cell to the cell directly below it, select the cell you want to receive the copy, and type CTRL + D

---

Step 14:

Switch to formula view

If you want to view all the formulas in a worksheet, press CTRL + ~ . Use this shortcut again to switch back to normal view.