[Excel-Tips] Use F5 and Ctrl+Enter To Enter Same Data in Multiple Cells

Hi All, 

Here is the Quick Tip regarding Excel: 

Sometimes, we want to enter same data in to several cells. You can use CTRL+Enter to do this in a snap.

1. Select all the cells, Press F5
2. Select “Special”
3. Select “Blanks” to select all blank cells
4. Now type whatever you want
5. Press CTRL+Enter
6. Done!

See How Cool It is! 

Here is the pic Demo. 

Please share it.. Because Sharing is Gaining!