Alt + D + G + S – Show Grouped Rows / ColumnsĪpart from the above, here are few others shortcuts that you might find useful.Alt + D + G + H – Hide Grouped Rows / Columns.Alt + D + G + U – Ungroup Rows / Columns.This is useful if you need to routinely working with columns and rows and Excel formulas. Alt + H + L + C + S – Delete Conditional Format.Alt + E + S + V – Paste Values (after Ctrl + C ) * F4 repeats the same action to other cells after pasting once.Alt + E + S + T – Paste Formatting (after Ctrl + C ) * F4 repeats the same action to other cells after pasting once.Alt + E + S + F – Paste Formula (after Ctrl + C ) * F4 repeats the same action to other cells after pasting once.Alt + H + B + P – Top Border *for adding lines.
#Excel keyboard shortcuts cheat sheet 2013 full
If your Excel sheet is full of color you might want to master this section of keyboard shortcuts.
#Excel keyboard shortcuts cheat sheet 2013 plus
The selected pivot items can be in adjacent cells, as in the screen shotīelow, or non-adjacent cells (select the first cell, then press the Ctrl To group pivot items, select them on the worksheet, then press Alt + NOTE: If you select a Row or Column item, instead of a heading, a calculated Heading where you want to add the item, then press Chtr + Shift + = To open the Calculated Item dialog box, select the Row or Column field Microsoft Excel 2007 Charts & Tables Quick Reference Guide (Cheat Sheet of Instructions, Tips & Shortcuts - Laminated Card) Beezix Inc on. To open the Calculated Field dialog box, select any field in the ValuesĪrea, then press Chtr + Shift + = (equal sign) NOTE: If a cell in the Report Filter range is selected, that range willīe selected, and none of the pivot table body range cells. Ctrl + Shift + 8 (number at top of keyboard).Select any cell in the body of the pivot table.
To select the entire pivot table body (not the report filter range), follow these steps: There is a Pivot Table Shortcut Reference Chart in the next section, and here are a few details on using those pivot table keyboard shortcuts. Pivot Table Tutorials and Videos Keyboard Shortcut Notes