## Most Commonly Used Excel Keyboard Shortcuts

Microsoft Excel Cheatsheet reference guide…

Selecting

**Ctrl + Spacebar** – Selects the entire column in a worksheet.

**Shift + Spacebar **– Selects the entire row in a worksheet.

Copy and Paste

**Ctrl + C** – Copy selected text.

**Ctrl + V **– Paste copied text.

**Ctrl + Alt + V **– Opens Paste Special dialogue box.

**Ctrl + D** – Uses Fill Down function to copy contents and formatting of top cell to selected cells below.

General

**Ctrl + 1** – Format Cells dialogue box.

**Ctrl + Z **– Undo

**Ctrl + Y** – Redo

**Ctrl + F2 **– Print Preview

**Ctrl + F **– Find and Replace dialogue box

**Alt + Shift + F1** – Inserts new worksheet.

Navigation

**Ctrl + Home** – Returns to cell A-1

**Ctrl + End **– Moves to the last used cell in the worksheet.

Function Keys

**F1 **– Help

**F2 **– Edits active cell, puts insertion cursor at end of cell contents.

**F4** – Repeat last command or action.

**F7 **– Spellcheck

**F11 **– Creates a chart of data in the current selected range.

**F12** – Save As…

## Formula Components Explained

Cell Expressions

**Name of a Cell** – Examples: A10 (Column A, Row 10), or F36 (Column F, Row 36)

**Multiple Individual Cells **– Examples: A9,G22 (Cell A9 *and* G22), or B12, Z24,AA13 (Cells B12, Z24, and AA13)

**Cell Ranges** – Examples: C11:C95 (Cells in column C and rows 11-95), or D14:H22 (cells in columns D through H, and cells 14-22)

**Formula Writing** – All formulas begin with "=", include a function like SUM, and a range of cells. Example: =SUM(A12:A27) will display the sum of all numbers in rows 12-27 in column A.

More Excel Formula tips and tricks.

## Common Excel Math Functions

**Average **– Finds the average value of the selected range. Example: =Average(A2:C14)

**Count **– Returns the number of cells that contain numbers. Example: If you had numbers in cells A1, A2, and A6 and words in cells A3, A4, and A5, you could use the formula =Count(A1:A6) and it would return 3, since three of the cells in the range are number contents.

**Max **– Finds the largest value in the selected range. Example: =Max(B2:B88) would find the highest number in that range and display it.

**Min** – Finds the smallest value in the selected range. Example: =Min(B2:B88) would find the lowest number in that range and display it.

**Product** – Multiplies numbers in the selected range and returns the answer. Example: =Product(B4,B5) would multiply the values in cells B4 and B5 and display the product.

**Sum** – Adds the values in the selected range and returns the answer: Example: =Sum(B4,B5) would add the values of B4 and B5 and return the sum.

**Trunc** – Truncates the number in the selected cell to the designated number of decimal spaces. Example =Trunc(B7, 2) where B7=36.251 would return the value 36.25. =Trunc(B7, -1) would return the value 30.