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. 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).
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.
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.
Type “2” and it will show as “Male”.
In this way you can type repeated content in Excel very conveniently.