Microsoft Excel 2000 Basic Tutorial

Index Button Previous Button Editing Hot Keys for Excel Next Button


You can use hot key combinations in Excel to edit text. This table lists the most commonly used key combinations.

Hot Keys for Text Editing
ALT+ENTERStart a new line in the same cell
BACKSPACEEdit the active cell and then clear it, or delete the preceding character in the active cell as you edit cell contents
CTRL+' (apostrophe)Copy the information from the cell above the active cell into the cell or the formula bar
CTRL+; (semicolon)Enter the date
CTRL+DELETEDelete text to the end of the line
CTRL+SHIFT+" (quotation mark)Copy the value from the cell above the active cell into the cell or the formula bar
CTRL+SHIFT+: (colon)Enter the time
CTRL+YRepeat the last action
DELETEDelete the character to the right of the insertion point, or delete the selection
ENTERComplete a cell entry and move down in the selection
ESCCancel a cell entry
F2Edit the active cell and position the insertion point at the end of the line
F4Repeat the last action
F7Display the Spelling dialog box
SHIFT+ENTERComplete a cell entry and move up in the selection
SHIFT+TABComplete a cell entry and move to the left in the selection


Click here to go to the next lesson



Return to Index   Previous Page   Next Page

Introduction   Table of Contents   Link To This Ebook   Helpful Links   eBookGallery.com