Sunday, May 12, 2013

[Excel-Tips] Use 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 where you want to enter the same data.
  2. Type the data
  3. Press CTRL+Enter
  4. Done!


See How Cool It is! 

Here is the pic Demo. 


Please share it.. Because Sharing is Gaining!

*Source: chandoo.org