Purchase Windows and Office keys with the discount code [KSW35]

Enjoy preferential price + extra 35% off = up to 90% DISCOUNT!
Take a Guess to Get Windows 10 Pro Key!
previous arrow
next arrow
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

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 *