Free Excel Tips & Tricks

Subscribe to Get Daily Excel Tips & Tricks to your Inbox for Free!

Tuesday, July 17, 2018

EXCEL SHORTCUT KEYS FOR DATA OPERATIONS

EXCEL SHORTCUT KEYS FOR DATA OPERATIONS

(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

EDITING CELLS USING EXCEL SHORTCUT KEYS

F2 Purpose: Use this excel shortcut key to Edit the active cell with cursor at end of the line. ALT +ENTER Purpose: Use this exc...