Excel Shortcut Keys are time-saver in order to make your work done within a minute but many people don’t know how to apply it. So in this tutorial, I will be showing you an amazing shortcut key in order to autofill the cells with a common value in Excel
Example:
Now let us understand that in all the cells you have to write a text called “Accepted” which means all the data should be named as “Accepted”. So to write the text I have one simple and amazing trick which I use every time that is:
Excel Shortcut keys: Ctrl + Enter
Step 1: Choose the first 3 cells
Step 2: Press Ctrl
Step 3: Choose the last 3 cells
Step 4: Write the text “Accepted”
Step 5: Press Ctrl + Enter
Step 6: Lastly, you can see the cells which you have chosen has filled with the text called “Accepted”
Conclusion:
So learn and practice this amazing shortcut key called Ctrl + E in Excel in order to autofill the cells with a common value. Also if you have any doubt while applying this shortcut key then do comment below. I will be glad to help you out