What are the shortcut keys for Office Excel to enter data in a worksheet

Source: Internet
Author: User
Apply OFFICE version: Office 2003 , Office 2007 , office2010 Start Edition, office2010 Professional Edition.
Complete the cell entry and move down in the selected area: ENTER
to wrap a row in a cell: Alt+enter
fills the selected range of cells with the current entry: Ctrl+enter
Complete the cell entry and move up in the selected range: Shift+enter
Complete the cell entry and move to the right in the selected area: TAB
Complete the cell entry and move left in the selected range: Shift+tab
To cancel a cell entry: ESC
Delete the character to the left of the insertion point, or delete the selected range: BACKSPACE
Delete the character to the right of the insertion point, or delete the selected range: DELETE
Delete the text from the insertion point to the end of the line: Ctrl+delete
move one character up or down:                   Arrow keys
move to the beginning of the line: Home
To edit a cell annotation: SHIFT+F2
To create a name from a row or column label: CTRL+SHIFT+F3
Fill down: Ctrl+d
Fill Right: Ctrl+r
Definition Name: ctrl+f3
Note: office2010 Start the Edit cell annotation function key is not available because the edition does not have the Insert approval feature.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.