Sunday, May 12, 2013

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

Posted by Sharath Chandra
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!