• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Typing and Editing Cell Data

Typing and Editing Cell Data

When you are typing data, you can save time with these shortcut keys:

To execute this command Do this
Edit the current cell Press F2
Start a new formula Press = (equal sign)
Start an AutoSum formula Press Alt+=(equal sign)
Start a new line in the same cell Press Alt+Enter
Insert today’s date Press Ctrl+’ (apostrophe)
Insert the current time Press Ctrl+Shift+: (colon)
Cancel typing entry Press Esc
Undo the last action Press Ctrl+Z
Repeat last action Press Ctrl+Y
Cut Press Ctrl+X
Copy Press Ctrl+C
Paste Press Ctrl+V
Clear cell contents Press Delete
Delete the selected cells Press Ctrl+- (hyphen)
Insert blank cells. Press Ctrl+Shift++ (plus sign)
Insert a hyperlink Press Ctrl+K
Fill down Press Ctrl+D
Fill right Press Ctrl+R
Insert a new worksheet Press Shift+F11



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint