Shortcuts to Insert and Edit Data in Excel Worksheet
As we know Excel is
very important tool in our daily life to maintain our records very efficiently.
In our last post "Shortcutsto Navigate and Data Selection Inside Excel Worksheets" we
mentioned few shortcuts to work upon. Here are few more shortcuts to improve
your working in Excel.
Insert
and Edit Data in Excel Worksheet
|
|
Undo
/ Redo Shortcuts
|
|
Ctrl + z
|
Undo last action (multiple levels).
|
Ctrl + y
|
Redo last action (multiple levels).
|
Work with Clipboard
|
|
Ctrl + c
|
Copy contents of selected cells.
|
Ctrl + x
|
Cut contents of selected cells.
|
Ctrl + v
|
Paste content from clipboard into
selected cell.
|
Ctrl + Alt + v
|
If data exists in clipboard: Display
the Paste Special dialog box.
|
Ctrl + Shift + [ + ]
|
If data exists in clipboard: Display
the Insert dialog box to insert blank cells.
|
Edit Inside Cells
|
|
F2
|
Edit the active cell with cursor at
end of the line.
|
Alt + Enter
|
Start a new line in the same cell.
|
Enter
|
Complete a cell entry and move down
in the selection. With multiple cells selected: fill cell range with current
cell.
|
Shift + Enter
|
Complete a cell entry and move up in
the selection.
|
Tab / Shift + Tab
|
Complete a cell entry and move to the
right / to the left in the selection.
|
Esc
|
Cancel a cell entry.
|
Backspace
|
Delete the character to the left of the
insertion point, or delete the selection.
|
Delete
|
Delete the character to the right of
the insertion point, or delete the selection.
|
Ctrl + Delete
|
Delete text to the end of the line.
|
Ctrl + ; (semicolon)
|
Insert current date.
|
Ctrl + Shift + : (colon)
|
Insert current time.
|
Edit Active or Selected Cells
|
|
Ctrl + d
|
Fill complete cell down (Copy above
cell).
|
Ctrl + r
|
Fill complete cell to the right (Copy
cell from the left).
|
Ctrl + "
|
Fill cell values down and edit (Copy above
cell values).
|
Ctrl + ' (apostrophe)
|
Fill cell formulas down and edit
(Copy above cell formulas).
|
Ctrl + l
|
Insert a table (display Create Table
dialog box).
|
Ctrl + -
|
Delete Cell / Row / Column Menu
|
Ctrl + - with row /
column selected
|
Delete row /
delete column.
|
Ctrl + Shift + +
|
Insert Cell / Row / Column Menu
|
Ctrl + Shift + +
with row / column selected
|
Insert row / insert column.
|
Shift + F2
|
Insert /
Edit a cell comment.
|
Shift + f10, then m
|
Delete comment.
|
Alt + F1
|
Create and insert chart with data in
current range as embedded Chart Object.
|
F11
|
Create and insert chart with data in
current range in a separate Chart sheet.
|
Ctrl + k
|
Insert a hyperlink.
|
enter (in a cell with a hyperlink)
|
Activate a hyperlink.
|
Hide and Show Elements
|
|
Ctrl + 9
|
Hide the selected rows.
|
Ctrl + Shift + 9
|
Unhide any hidden rows within the
selection.
|
Ctrl + 0 (zero)
|
Hide the selected columns.
|
Ctrl + Shift + 0 (zero)
|
Unhide any hidden columns within the
selection*.
|
Ctrl + ` (grave accent)
|
Alternate between displaying cell
values and displaying cell formulas. Accent grave / not a quotation mark.
|
Alt + Shift + Arrow Right
|
Group rows or columns.
|
Alt + Shift + Arrow Left
|
Ungroup rows or columns.
|
Ctrl + 6
|
Alternate between hiding and
displaying objects.
|
Ctrl + 8
|
Display or hides the outline symbols.
|
Ctrl + 6
|
Alternate between hiding objects,
displaying objects, and displaying placeholders for objects.
|
Adjust Column Width and Row Height
|
|
Alt + o, ca
|
Adjust Column width to fit content.
Select complete column with Ctrl + Space first, otherwise column adjusts to
content of current cell). Remember Format, Column Adjust.
|
Alt + o, cw
|
Adjust Columns width to specific
value: Option, Cow, width
|
Alt + o, ra
|
Adjust Row height to fit content:
Option, Row, Adjust
|
Alt + o, re
|
Adjust Row height to specific value:
Option, Row, Height
|
Use these shortcuts to improve your working and help others!
