Excel Workbook For Dummies
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:

Paul McFedries is a technical writer who has been authoring computer books since 1991 and has over 100 books to his credit. These books include Alexa For Dummies, Amazon Fire TV For Dummies, and Cord Cutting For Dummies. You can visit Paul on the web at www.mcfedries.com.

Greg Harvey has authored tons of computer books, the most recent being Excel 2007 For Dummies, Windows Vista For Dummies Quick Reference, and Excel Workbook For Dummies. He started out training business users on how to use IBM personal computers and their attendant computer software in the rough-and-tumble days of DOS, WordStar, and Lotus 1-2-3 in the mid-80s of the last century. After working for a number of independent training firms, he went on to teaching semester-long courses in spreadsheet and database management software at Golden Gate University in San Francisco.
His love of teaching has translated into an equal love of writing. For Dummies books are, of course, his all-time favorites to write because they enable him to write to his favorite audience, the beginner. They also enable him to use humor (a key element to success in the training room) and, most delightful of all, to express an opinion or two about the subject matter at hand.

This article can be found in the category: