Clever deletion of error characters with F2 in Excel

Source: Internet
Author: User

According to most people's input habits, after the wrong text is very likely to use the arrow keys to move the cursor next to the wrong characters, and then use BACKSPACE or del keys to delete them. However, it is not convenient to enter the wrong data in Excel. Because when you enter data in Excel, the input box will be moved to other cells, such as the input "123", the cursor stay behind the "3", want to use the direction of the key to move directly to the "1" before you can do.

Although you can use the mouse to double-click the cell to locate the cursor, but in the case of entering large amounts of data, it can be a waste of time to click the mouse back and forth because of such a small problem. We still have one way, that is to use the F2 key. As long as you press the direction key before pressing the F2 key, you will find that you can move the cursor in this cell, and then click the F2 key to exit this state. Is it more convenient?

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.