(CTRL + ALT + V) + B | |
Purpose: | Use this excel shortcut key to Paste special, skipping blanks |
(CTRL + ALT + V) + C | |
Purpose: | Use this excel shortcut key to Paste cell comments. |
(CTRL + ALT + V) + D | |
Purpose: | Use this excel shortcut key to Paste special, performing an addition |
(CTRL + ALT + V) + E | |
Purpose: | Use this excel shortcut key to Transpose when pasting |
(CTRL + ALT + V) + H | |
Purpose: | Use this excel shortcut key to Paste all, keeping source formatting |
(CTRL + ALT + V) + I | |
Purpose: | Use this excel shortcut key to Paste special, performing a division |
(CTRL + ALT + V) + M | |
Purpose: | Use this excel shortcut key to Paste special, performing a multiplication |
(CTRL + ALT + V) + N | |
Purpose: | Use this excel shortcut key to Paste data validation |
(CTRL + ALT + V) + S | |
Purpose: | Use this excel shortcut key to Paste special, performing a subtraction |
(CTRL + ALT + V) + U | |
Purpose: | Use this excel shortcut key to Paste values and number formatting |
(CTRL + ALT + V) + V | |
Purpose: | Use this excel shortcut key to Paste values |
(CTRL + ALT + V) + X | |
Purpose: | Use this excel shortcut key to Paste all, except borders |
ALT + A + M | |
Purpose: | Use this excel shortcut key to Displays the Remove Duplicates dialog box |
ALT + A + W + G | |
Purpose: | Use this excel shortcut key to Display the Goal Seek dialog box |
ALT + A + W + S | |
Purpose: | Use this excel shortcut key to Display the Scenario Manager dialog box |
ALT + A + W + T | |
Purpose: | Use this excel shortcut key to Display the Data Table dialog box |
ALT + ENTER | |
Purpose: | Use this excel shortcut key to start new line within cell |
ALT + H + C + P | |
Purpose: | Use this excel shortcut key to Display the Copy as Picture dialog |
ALT + H + E + A | |
Purpose: | Use this excel shortcut key to Clear all cell contents. |
ALT + H + E + L | |
Purpose: | Use this excel shortcut key to Clear hyperlinks of selected cells. |
ALT + H + E + M | |
Purpose: | Use this excel shortcut key to Clear comments from cell. |
ALT + H + E + R | |
Purpose: | Use this excel shortcut key to Remove hyperlinks from selected cells |
ALT + H + FI + A | |
Purpose: | Use this excel shortcut key to Display the Fill Across Worksheets dialog box |
ALT + H + FI + J | |
Purpose: | Use this excel shortcut key to Fill justify alignment |
ALT + H + FI + L | |
Purpose: | Use this excel shortcut key to Fill left as follows: (A) Copy right-most cell of a selected range into cells to the left; or (B) Copy from right cell into active cell |
ALT + H + FI + S | |
Purpose: | Use this excel shortcut key to Display the Series dialog box |
ALT + H + FI + U | |
Purpose: | Use this excel shortcut key to Fill up as follows: (A) Copy lower cell of a selected range into cells above; or (B) Copy from cell below into active cell |
ALT + H + FO | |
Purpose: | Use this excel shortcut key to Display the Clipboard task pane |
ALT + H + V + E | |
Purpose: | Use this excel shortcut key to Paste values, keeping source formatting |
ALT + H + V + I | |
Purpose: | Use this excel shortcut key to Paste linked picture |
ALT + H + V + U | |
Purpose: | Use this excel shortcut key to Paste picture into the sheet. |
ALT + R + A | |
Purpose: | Use this excel shortcut key to Show all comments in a sheet |
ALT + R + D | |
Purpose: | Use this excel shortcut key to Delete comment from cell. |
BACKSPACE | |
Purpose: | Use this excel shortcut key to (A) Within Formula Bar or cell (in cell-editing mode), deletes 1 character to the left or deletes the selection (if any); or (B) When not in cell-editing mode, clears the contents of selected/active cell(s) |
CTRL + ' | |
Purpose: | Use this excel shortcut key to Copy formula/text from cell above into active cell or Formula Bar |
CTRL + " | |
Purpose: | Use this excel shortcut key to Copy values/text from cell above into active cell or Formula Bar |
CTRL + ; | |
Purpose: | Use this excel shortcut key to Enter current date in a selected cells. |
CTRL + ALT + V | |
Purpose: | Use this excel shortcut key to Display the Paste Special dialog box where There must be data in the Clipboard for command to be available. |
CTRL + C | |
Purpose: | Use this excel shortcut key to Copy the cell content. |
CTRL + D | |
Purpose: | Use this excel shortcut key to Fill down as follows: (A) Copy top cell of a selected range into cells below; or (B) Copy from cell above into active cell |
CTRL + DELETE | |
Purpose: | Use this excel shortcut key to Delete to the end of current line |
CTRL + E | |
Purpose: | Use this excel shortcut key to Flash Fill the cells with selected pattern. |
CTRL + ENTER | |
Purpose: | Use this excel shortcut key to (A) Enter current entry in selected range and stay in same active cell; or (B) Complete cell entry and stay in same active cell |
CTRL + K | |
Purpose: | Use this excel shortcut key to (A) Within a cell without hyperlinks, display the Insert Hyperlink dialog box; or (B) Within a cell with a hyperlink, display the Edit Hyperlink dialog box |
CTRL + Q | |
Purpose: | Use this excel shortcut key to Expand the Quick Analysis tool |
CTRL + R | |
Purpose: | Use this excel shortcut key to Fill right as follows: (A) Copy left-most cell of a selected range into cells to the right; or (B) Copy from left cell into active cell |
CTRL + SHIFT + : | |
Purpose: | Use this excel shortcut key to Enter current time in a single/active cell. |
CTRL + V | |
Purpose: | Use this excel shortcut key to Paste. Pastes at the insertion point and replaces any selection. There must be data in the Clipboard for command to be available. |
CTRL + X | |
Purpose: | Use this excel shortcut key to Cut the cell content. |
DELETE | |
Purpose: | Use this excel shortcut key to Clear contents of the selected/active cell(s). Within Formula Bar or cell (in cell-editing mode), deletes 1 character to the right or deletes the selection (if any) |
ENTER | |
Purpose: | Use this excel shortcut key to (A) Within cell or Formula Bar, complete cell entry and (by default) go to cell below; or (B) Within an AutoFilter list, filter the list using the selected item. Enter is also under the Navigation and Selection category |
ESC | |
Purpose: | Use this excel shortcut key to Within cell of Formula Bar, cancel entry. Esc is also under the Navigation and Selection category. |
F2 | |
Purpose: | Use this excel shortcut key to Edit active cell. Positions the insertion point at the end of cell contents. When Allow editing directly in cells is turned off, moves the insertion point to the Formula Bar. |
F7 | |
Purpose: | Use this excel shortcut key to Display the Spelling dialog box |
RIGHT MOUSE BUTTON + E | |
Purpose: | Use this excel shortcut key to When a row or column is selected, insert copied or cut cells |
SHIFT + ENTER | |
Purpose: | Use this excel shortcut key to Within cell of Formula Bar, complete cell entry and (by default) go to the cell above |
SHIFT + F10 + M | |
Purpose: | Use this excel shortcut key to Insert or delete cell comment |
SHIFT + F2 | |
Purpose: | Use this excel shortcut key to Insert or edit a cell comment |
SHIFT + F7 | |
Purpose: | Use this excel shortcut key to Display the Thesaurus dialog box or task pane |
No comments:
Post a Comment