Use Excel to replace a feature to bulk enter hard to lose characters

Source: Internet
Author: User

Sometimes I have to enter a special symbol (such as "Φ") multiple times in a table, and it is very troublesome to switch the soft keyboard every time. We can use the replacement method to speed up the input:

First enter a letter (such as "Z") where you want to enter a special symbol. When the entire entry is complete, press the "Ctrl+h" key combination (or perform the edit → replace command), open the Find and Replace dialog box (figure), and enter the letter "Z" in "Find what" in the "Replace with" Enter the special symbol "Φ" and press the "Replace All" button on the line.

Replace

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.