Excel Workbook For Dummies, 2nd Edition
Book image
Explore Book Buy On Amazon

A large part of the work you do in Excel is editing the cell contents in worksheets. To save time editing, learn the following Excel shortcuts, including the key combinations and their functions:

Press To
F2 Edit current cell entry and position insertion point at the end of cell contents
Shift+F2 Edit comment attached to current cell and position insertion point in comment box
Backspace Delete character to left of insertion point when editing cell entry
Delete Delete character to right of insertion point when editing cell entry: otherwise, clear cell entries in current range
Esc Cancel editing in current cell entry
Enter Complete editing in current cell entry
Ctrl+C Copy cell selection to the Windows Clipboard
Ctrl+X Cut cell selection to the Windows Clipboard
Ctrl+V Paste last copied or cut cells from the Windows Clipboard
Ctrl+hyphen (-) Open Delete dialog box to delete cell selection and shift remaining cells left or up
Ctrl+Shift+plus (+) Open Insert dialog box to insert new cells and shift existing cells right or down
Ctrl+Z Undo last action
Ctrl+Y Redo last undone action

About This Article

This article is from the book:

About the book authors:

Greg Harvey, PhD, was president of Mind Over Media and a highly skilled instructor. He wrote computer books for more than 20 years, and his long list of best sellers included all editions of Excel For Dummies, Excel All-in-One For Dummies, and Excel Workbook For Dummies. He died in 2020. Paul McFedries is a true renaissance geek. He has been a programmer, consultant, database developer, and website builder. He's also the author of more than 90 books, including top sellers covering Windows, Office, and macOS.

This article can be found in the category: