Header Ads

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!

Powered by Blogger.