How to enter a single value/formula in multiple excel cells?

If you want to enter the same value in many cells in excel, the easiest way is -

1. Select all the cells in which you want the value to be entered
2. Type the value
3. Press Ctrl+Enter