I found this feature very useful when it comes to filling up information automatically in the excel sheet cells.
Assuming that you need an information to show up everytime you press the letter “D”, “E” and “N” in your excel sheet. D= Day Shift ( 6:00-14:00) E=Evening Shift (14:00-22:00) and N= Night Shift (22:00-6:00)
You can accomplish the task by using the Excel AutoCorrect Feature. AutoCorrect is a feature in Excel that quickly fixes common misspelling and grammatical errors that occur as we type. One good thing about this feature is that we can customize it to correct other common misspellings or to do some tricks and make it more useful than usual.
1. Go to Tools and select AutoCorrect Optins..
2. Enter the AutoCorrect function that you would like to add.
3. After accomplishing the first task, you can also add a simple computation, calculate the number of scheduled ”D” “E” and “N” for each name.
You can use COUNTIF in the following formula:
To tally “D” or for Day Shift
To tally “E” or for Evening Shift
To tally “N” or Night Shift
Thant’s All! =)