-
Insert a new worksheet by pressing Shift + F11.
-
Press Ctrl + Shift + * (asterisk) to select all
date in the current region.
-
To view formulas in your worksheet, press Ctrl +
` (accent mark). Press Ctrl + ` a second time stop viewing
formulas in the worksheet.
-
Press Ctrl + ; (semi-colon) to insert the
current date.
-
Press Ctrl + : (colon) to insert the current
time.
-
To create multiple lines of text in one cell,
press Alt + Enter after each line.
-
Press Ctrl + Shift + " (quotation mark) to copy
a value from cell above the active cell.
-
Press Ctrl + ' (apostrophe) to copy a formula
from the cell above the active cell.
-
To move an Excel worksheet, drag the selected
worksheet tab to the left or right.
-
To copy an Excel worksheet, press the CTRL key,
then drag the selected worksheet tab to the left or right.
-
Double-click the to or bottom edge of a cell to
navigate to the top or end of the column.
-
Double-click the right or left edge of a cell to
navigate to the right or left edge of a row.
-
Press Shift + spacebar to select a column.
-
Press Ctrl + space to select a row.
-
To insert the cents symbol (¢), turn on the
number keyboard pad by pressing NumLock, hold the Alt key and
enter 0162, then release the Alt key.
