Paste.

Ctrl+V

Pastes formulas.

Alt, H, V, F

Pastes formulas & numbers.

Alt, H, V, O

Paste (Keeps source formatting)

Alt, H, V, K

Paste (No borders)

Alt, H, V, B

Pastes column widths

Alt, H, V, W

Paste (Transpose)

Alt, H, V, T

Pastes as Values.

Alt, H, V, V

Paste (Number formatting)

Alt, H, V, A

Paste (Source Formatting)

Alt, H, V, E

Pastes formatting.

Alt, H, V, R

Pastes a link.

Alt, H, V, N

Pastes a picture.

Alt, H, V, U

Pastes a linked picture.

Alt, H, V, I

Displays the Paste Special dialog box.

Ctrl+Alt+V

Cuts the selected cells.

Ctrl+X

Copies the selected cells.

Ctrl+C

Copies as picture.

Alt, H, C, P

Tip: Consider pasting format instead: Alt, H, V, S, T.

Alt, H, F, P

Displays the Office Clipboard Task Pane.

Alt, H, F, O

Changes the font face.

Alt, H, F, F

Increases the font size.

Alt, H, F, G

Decreases font Size.

Alt, H, F, K

Applies or removes bold formatting.

Ctrl+B

Applies or removes italic formatting.

Ctrl+I

Applies or removes underlining.

Ctrl+U

Double underlines the selected text.

Alt, H, 3, D

Bottom Border

Alt, H, B, O

Top Border

Alt, H, B, P

Left Border

Alt, H, B, L

Right Border

Alt, H, B, R

Removes the outline border from the selected cells.

Ctrl+Shift+Minus

All Borders

Alt, H, B, A

Applies the outline border to the selected cells.

Ctrl+Shift+7

Thick Box Border

Alt, H, B, T

Bottom Double Border

Alt, H, B, B

Thick Bottom Border

Alt, H, B, H

Top and Bottom Border

Alt, H, B, D

Top and Thick Bottom Border.

Alt, H, B, C

Top and Bottom Border

Alt, H, B, U

Draw Border

Alt, H, B, W

Draw Border Grid

Alt, H, B, G

Erase Border

Alt, H, B, E

More Border Colors

Alt, H, B, I, M

Line Style

Alt, H, B, Y

More Borders

Alt, H, B, M

Shading

Alt, H, H

More Colors

Alt, H, H, M

Font Color

Alt, H, F, C

More Font Colors

Alt, H, F, C, M

Shows the Font tab of the Format Cells dialog box.

Ctrl+Shift+F

Aligns text to the top of the cell.

Alt, H, A, T

Aligns text so that it is centered between the top and bottom of the cell.

Alt, H, A, M

Aligns text to the bottom of the cell.

Alt, H, A, B

Angle Counterclockwise

Alt, H, F, Q, O

Angle Clockwise

Alt, H, F, Q, L

Vertical Text

Alt, H, F, Q, V

Rotate Text Up

Alt, H, F, Q, U

Rotate Text Down

Alt, H, F, Q, D

Shows the Alignment tab of the Format Cells dialog box.

Alt, H, F, A

Applies align left.

Alt, H, A, L

Applies align center.

Alt, H, A, C

Applies align right.

Alt, H, A, R

Decreases the margin between the border and the text in the cell.

Alt, H, 5

Increases the margin between the border and the text in the cell.

Alt, H, 6

Tip: You can press Alt+Enter to start a new line within a cell without wrapping text.

Alt, H, W

Tip: Consider using Center Across Selection from the Alignment menu instead: Alt, H, F, A.

Alt, H, M, C

Merges each row of the selected cells into a larger cell.

Alt, H, M, A

Merge the selected cells into one cell.

Alt, H, M, M

Splits the current cell into multiple cells.

Alt, H, M, U

Choose how the values in a cell are displayed: as a percentage, as currency, as a date or time, etc.

Alt, H, N

Displays the value of the cell as a percentage.

Ctrl+Shift+5

Displays the value of the cell with a thousands separator. This will change the format of the cell to Accounting without a currency symbol.

Alt, H, K

Shows more decimal places for a more precise value.

Alt, H, 0

Shows fewer decimal places.

Alt, H, 9

Shows the Number tab of the Format Cells dialog box.

Alt, H, F, M

Highlight cell rules: greater than (Conditional formatting)

Alt, H, L, H, G

Highlight cell rules: less than (Conditional formatting)

Alt, H, L, H, L

Highlights cell rules: between (Conditional formatting)

Alt, H, L, H, B

Highlight cell rules: equal to (Conditional formatting)

Alt, H, L, H, E

Highlight cell rules: text that contains (Conditional formatting)

Alt, H, L, H, T

Highlight cell rules: a date occurring (Conditional formatting)

Alt, H, L, H, A

Highlight cell rules: duplicate values (Conditional formatting)

Alt, H, L, H, D

Highlight cell rules: more rules (Conditional formatting)

Alt, H, L, H, M

Top-bottom rules: Top 10 Items (Conditional formatting)

Alt, H, L, T, T

Top-bottom rules: Top 10 % (Conditional formatting)

Alt, H, L, T, P

Top-bottom rules: Bottom 10 Items (Conditional formatting)

Alt, H, L, T, B

Top-bottom rules: Bottom 10 % (Conditional formatting)

Alt, H, L, T, O

Top-bottom rules: Above Average (Conditional formatting)

Alt, H, L, T, A

Top-bottom rules: Below Average (Conditional formatting)

Alt, H, L, T, V

Top-bottom rules: More Rules (Conditional formatting)

Alt, H, L, T, M

Data Bars More

Alt, H, L, D, M

Applies a color gradient to a range of cells. The color indicates where each cell value falls within that range.

Alt, H, L, S, M

Icon Sets - More Rules

Alt, H, L, I, M

Tip: Select Use a Formula to Determine which Cells to Format and enter the formula =MOD(ROW(),2)=0 to shade every other row.

Alt, H, L, N

Clears rules from selected cells.

Alt, H, L, C, S

Clears rules from entire sheet.

Alt, H, L, C, E

Clears rules from this table.

Alt, H, L, C, T

Clears rules from this PivotTable.

Alt, H, L, C, P

Manage Conditional Formatting Rules.

Alt, H, L, R

New Table Style

Alt, H, T, N

New PivotTable Style

Alt, H, T, P

New Cell Style

Alt, H, J, N

Merge Styles

Alt, H, J, M

Displays the Insert dialog box to insert blank cells.

Ctrl+Shift+=

Insert Sheet Rows

Alt, H, I, R

Insert columns

Alt, H, I, C

Delete cells, rows, columns, or sheets from your workbook. FYI: To delete multi

Delete Sheet Rows

Alt, H, D, R

Delete Sheet Columns

Alt, H, D, C

Row height

Alt, H, O, H

AutoFit Row Height

Alt, H, O, A

Column Width

Alt, H, O, W

AutoFit Column Width

Alt, H, O, I

Default Width

Alt, H, O, D

Hides the selected rows.

Ctrl+9

Hides the selected columns.

Ctrl+0

Hide Sheet

Alt, H, O, U, S

Unhides any hidden rows within the selection.

Ctrl+Shift+9

Unhides any hidden columns within the selection.

Ctrl+Shift+0

Unhide Sheet

Alt, H, O, U, H

Rename Sheet

Alt, H, O, R

Move or Copy Sheet

Alt, H, O, M

More Sheet Tab Colors

Alt, H, O, T, M

Prevents unwanted changes from others by limiting their ability to edit.

Alt, H, O, P

Locks the selected cells to keep people from making changes to them. You must turn on Protect Sheet in order for this feature to work.

Alt, H, O, L

Shows the Format Cells dialog box.

Ctrl+1

Displays the sum of the selected cells directly after the selected cells.

Alt+=

Inserts an Average function.

Alt, H, U, A

Inserts a Count function.

Alt, H, U, C

Inserts a Maximum function.

Alt, H, U, M

Inserts a Minimum function.

Alt, H, U, I

Shows the Insert function dialog.

Alt, H, U, F

Fill Down.

Ctrl+D

Fill Right.

Ctrl+R

Fill Up

Alt, H, F, I, U

Fill Left

Alt, H, F, I, L

Fill Across Worksheets

Alt, H, F, I, A

Fill Series

Alt, H, F, I, S

Fill Justify

Alt, H, F, I, J

Flash Fill - Automatically fills in values.

Ctrl+E

Clears everything from the selected cells.

Alt, H, E, A

Clears only the formatting that is applied to the selected cells.

Alt, H, E, F

Clears the content of selected cells. If editing text, deletes one character to the right.

Delete

Clears any comments that are attached to the selected cells.

Alt, H, E, M

Clears the hyperlinks from the selected cells.

Alt, H, E, L

Remove the hyperlinks and formatting from the selected cells.

Alt, H, E, R

Sorts the selection so that the lowest values are at the top of the column.

Alt, H, S, S

Sorts the selection so that the highest values are at the top of the column.

Alt, H, S, O

Sort - Shows the Sort dialog box to sort data based on several criteria at once.

Alt, H, S, U

Applies a data filter.

Ctrl+Shift+L

Clears the filter and sorts state for the current range of data.

Alt, A, C

Reapplies the filter and sort in the current range.

Ctrl+Alt+L

Displays the Find and Replace dialog box, with the Find tab selected.

Ctrl+F

Searches for text you would like to change, and replaces it with something else.

Ctrl+H

Displays the Go To dialog box.

F5

Go To Special

Alt, H, F, D, S

Find & Select Formulas

Alt, H, F, D, U

Find & Select Constants

Alt, H, F, D, N

Find & Select Conditional Formatting

Alt, H, F, D, C

Find & Select Data Validation

Alt, H, F, D, V

Selects objects including ink, shapes, and text areas. This is especially useful when working with objects that are behind the text.

Alt, H, F, D, O

Displays the Selection Pane to help select individual objects and to change their order and visibility.

Alt, P, A, P

Find add-ins that add new functionality to Office, simplify tasks, and connect y

Alt, H, A, S

Discover more about your data. Analyze Data looks for patterns in your data tha

Alt, H, F, E

Recommended PivotTable

Alt, N, S, P

Tip: Consider simply using Sort & Filter instead: Alt, H, S.

Ctrl+T

Inserts ready-made shapes, such as rectangles and circles, arrows, lines, flowchart symbols, and callouts.

Alt, N, S, H

Insert an icon to visually communicate using symbols.

Alt, N, N, S

Inserts a SmartArt graphic to visually communicate information.

Alt, N, M, 1

Recommended Charts

Alt, N, R

Insert a column chart. Column charts are used to compare values across categories.

Alt+F1

More Pie Charts... - Open the Insert Chart dialog to see previews of your data in a variety of pie charts. You can also browse previews of your data in other chart types within this dialog box.

Alt, N, Q, M

More Scatter Charts... - Open the Insert Chart dialog to see previews of your data in a variety of scatter charts. You can also browse previews of your data in other chart types within this dialog box.

Alt, N, D, M

Create Custom Combo Chart... - Open the Insert Chart dialog to see a preview and choose different chart types for your data series or move your data series to the secondary axis. You can also browse previews of your data in other chart types within this dialog box.

Alt, N, S, D, C

Inserts a PivotChart.

Alt, N, S, Z, C

Inserts Pivot Chart and Table.

Alt, N, S, Z, P

Shows the Chart dialog box to choose a chart type to insert.

Alt, N, K

Inserts a line chart within a single cell.

Alt, N, S, L

Inserts a column chart within a single cell.

Alt, N, S, O

Inserts a win/loss chart within a single cell.

Alt, N, S, W

Inserts a slicer to filter data interactively. Slicers make it faster and easier to filter PivotTables and cube functions.

Alt, N, S, F

Creates a Timeline to filter dates interactively.

Alt, N, S, T

Creates a link to a Web page, a picture, an e-mail address, or a program.

Ctrl+K

Adds a comment about the selection.

Alt, R, C

Inserts a text box that can be positioned anywhere on the page.

Alt, N, X

Edits the Header or Footer of the document.

Alt, N, H, 1

Inserts decorative text in your document.

Alt, N, W

Add Signature Services

Alt, N, G, A

Inserts an embedded object.

Alt, N, J

Insert New Equation

Alt, N, E, I

Inserts characters that are not on your keyboard, such as copyright symbols, trademark symbols, paragraph marks, and Unicode characters.

Alt, N, U

Use pens, eraser, lasso, and shape tools with your finger.

Alt, J, I, W

Automatically refine hand-drawn shapes.

Alt, J, I, H

Convert handwritten math equations into typed numbers and symbols.

Alt, J, I, M

Automatically replay the creation of visible ink strokes.

Alt, J, I, K

Get pen and ink help in Microsoft Office.

Alt, J, I, I

Changes the overall design of the entire document, including colors, fonts, and effects.

Alt, P, T, H

Browse for Themes

Alt, P, T, H, B

Save Current Theme

Alt, P, T, H, A