When the insertion point is to the right of a function name in a formula, displays the Function Arguments dialog box. Pressing CTRL+A a second time selects the entire worksheet. If the worksheet contains data, CTRL+A selects the current region. In a PivotTable, it selects the entire PivotTable report.Д¬opies the value from the cell above the active cell into the cell or the Formula Bar.Дisplays the Insert dialog box to insert blank cells.Дisplays the Delete dialog box to delete the selected cells.ДЄlternates between displaying cell values and displaying formulas in the worksheet.Д¬opies a formula from the cell above the active cell into the cell or the Formula Bar.ДЄlternates between hiding and displaying objects. Selects the current region around the active cell (the data area enclosed by blank rows and blank columns). Removes the outline border from the selected cells.ДЄpplies the Currency format with two decimal places (negative numbers in parentheses).ДЄpplies the Percentage format with no decimal places.ДЄpplies the Scientific number format with two decimal places.ДЄpplies the Date format with the day, month, and the Time format with the hour and minute, and AM or PM.ДЄpplies the Number format with two decimal places, thousands separator, and minus sign (-) for negative values. Unhide item(s) (assume you have two fields 'color', and 'size' and you hid 'color'.Unhides any hidden rows within the selection.ДЄpplies the outline border to the selected cells. Type over any field with the value hidden Unhide item(s) by opening header drop-down and using Arrow Keys and Space to unhide item Follow up with Alt+ E for existing worksheet if desired, Tab, and type the cell reference where it should go (e.g. I nsert Pi votTable after selecting data range. This will automatically extend all column widths which reverses when pressed againД¬reating Pivot Tables with Shortcuts only seems to be nearly impossible managing existing tables is doable. Some keyboards seem to distinguish between left and right Shift key Remember that each time editing the formula will require the Ctrl+ Shift+ Enter. Select all Formulas ( Home - Fin d - Form ulasД®nter a formula as an array formula. Repeat if you want to toggle from absolute reference to partial or complete removal ($E$4 -> E$4 -> $E4 -> returning to E4.Д®dit arguments of formula at cursor position Select or unselect one word to the left/ rightДelete one character to the right/ left of cursorД¬omplete cell entry and move one cell down/ upД¬omplete cell entry and move one cell right/ leftД¬omplete cell entry and don't move selectionДuplicate value from Cell above into current cell at cursor positionДЄfter typing cell reference (eg =E4) makes reference absolute (=$E$4). Select from the insertion point to beginning/ end of cell Select one character to the left/ right (or one line up/down) Navigate by one character left/ right or one line up/ down Selects from current end of cursor to beginning These assume you are inside a cell, typically after pressing F2 With cells that are not complete rows/columns - Open delete cell/ row/ column menuДЇill single cell content down to all cells selected with Shift+ Arrow DownДЇill single cell content up to all cells selected with Shift+ Arrow Down With cells that are not complete rows/columns - Open insert cell/ row/ column menu Paste Insert - paste column(s) from clipboard and shift existing content to the right Paste Insert - paste row(s) from clipboard and shift existing content downwardД¬trl+ Shift+ + with column(s) in clipboard and column selected Select multiple rows to insert multiple rowsД¬trl+ Shift+ + with row(s) in clipboard and a row selected

Select single row, then insert row below. Select single (or multiple) columns, then delete

Select multiple rows then insert the same number rows below

Shift+ Space, then Shift+ Arrow Up/ Arrow Down, then Ctrl+ Shift+ + Select single row then insert one row above Shift+ Space, then Shift+ Arrow Up/ Arrow Down, then Ctrl+. 1.4 Insert Rows, Columns and Duplicate Content

Excel keyboard shortcuts 2010