Fill a Selected Range with the Same Data – MS Excel

 Need to enter the same data in a range of cells? Here’show:

1. Select a range of cells.
2. Type in some data.
3. Use the fill function in Microsoft Office Excel—press CTRL+ENTER, and the range selected will be filled with the same data.

Article by Hari Maurya

Hari Maurya is presently pursuing BE in Information Technology from Mumbai University. He also holds Diploma in Information Technology field.

Connect with him on Twitter and Facebook.

Leave a Reply