Excel Shortcut: Ctrl + Enter in Excel

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:

MS Excel Course in Hindi

  • Get 2-Year Access with unlimited views of 220+ videos
  • 100+ case studies you won't find ANYWHERE

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

5% Discount
No prize
30% Discount
Almost!
10% Discount
Almost
70% Discount
No luck today
Almost!
50% Discount
No prize
Unlucky
Get your chance to win a price! on Excel Mastery Program Bundle
Enter your email address and spin the wheel. This is your chance to win amazing Upto 70% discounts!
Our in-house rules:
  • One game per user
  • Cheaters will be disqualified.