Slider

Tip to Quick Input Specified Text in Excel

Date:2019-8-6 Author:Cordelia

If you want to type a great many repeated data in an Excel file like gender, department, etc. There’s a quick way in addition to add drop-down list. Let’s see the detailed steps.

Assuming that I need type-in the gender of all employees in Excel. Should I input “Female” or “Male” in one after another cell constantly? It’s not necessary in deed. As the table below, I can now select the cells in Gender column and press Ctrl+1 (or right-click the selected area and choose Format Cells… in the menu).

Tip to Quick Input Specified Text in Excel

In the popping out window, select the Category as Custom. Then input or copy the formula [=1]”Female”;[=2]”Male” to the textbox below Type. It means when I type “1” this cell the text will be displayed as “Female”, type “2” and it will show as “Male”.

Note: the formula (including all the marks in it) must be typed in half-angle correctly.

Tip to Quick Input Specified Text in Excel

Hit OK to confirm the custom setting. Then you can check the result in the worksheet. Type “1” in the cell B2 and press Enter or click anywhere outside the cell, then “1” will be converted into “Female” immediately.

Tip to Quick Input Specified Text in Excel

Tip to Quick Input Specified Text in Excel

Type “2” and it will show as “Male”.

Tip to Quick Input Specified Text in Excel

Tip to Quick Input Specified Text in Excel

In this way you can type repeated content in Excel very conveniently.

Tip to Quick Input Specified Text in Excel

If you find our content useful, donations are always welcom. we'll keep going and hold more giveaways in the future.

Windows 10: Run Troubleshooter to Fix Network Connection Problems
Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *