How to Type Same Data in Multiple Cell?

Published by admin on

How to Type Same Data in Multiple Cell

(Hindi के लिए  यहाँ क्लिक करे)

Have you ever need to write same content in multiple cells in Microsoft Excel Workbook?It is very Time Consuming work and boaring work. Even copy paste same data in multiple cell also time consuming work.

We have one simple trick which can be help to save our time to do type same data in multiple cell.

How to Type Same Data in Multiple Cell

  • Open a Microsoft Excel Sheet
  • Select Multiple cells of one sheet of Microsoft Excel where you want to type same data.You May Select Cells by Hold Control Key (Ctrl) key and select individual  multiple cells by click each cell.If cells serially then just Drag and highlight cells .
  • After Select All Required cells in sheet then Write Data in any one of cell from Sheet which you have type in all cells.
  • Now Just Hold Ctrl (control) and Press Enter key.  That’s it….same data now available in all selected cells.

One Important things that there is no character limitation in cell. So can write as long you want and should be paste automatically.

You like to refer :How to Add Drop down list in Excel

How to Type Same Data in Multiple Cell (Hindi)

  • माइक्रोसॉफ्ट एक्सेल का फाइल ओपन करिए .
  • एक्सेल के Sheet में आपको जो भी सेल में डाटा लिखना है वो सब सेल को सेलेक्ट कर लीजिये. सेलेक्ट करने कीबोर्ड के Ctrl key को  प्रेस करके होल्ड करिये एन्ड जीस सेल को सेलेक्ट करना हो वो सब सेल पे क्लिक करिए. एसा करने से सब सेल सेलेक्ट हो जायेंगे.आप सिंपल Drag करके भी सेल सेलेक्ट कर सकते है.
  • अब सेलेक्ट किये हुए कोई भी एक सेल में जो डाटा सभी सेल में लिखना है वो लिखिए.
  • डाटा लिखने के बाद Ctrl key के साथ Enter Press करिए. जैसे ही आप Enter key प्रेस करेंगे सब सेल में डाटा लिखा हुआ मिलेगा.
You May like to refer:How to Use Exact Function in Excel
(Visited 30 times, 1 visits today)


Ashok · July 17, 2018 at 10:32 am

Good, but if i want to wright same in other sheets then

Subhendu Bera · July 17, 2018 at 12:49 pm

Awesome post I read it and my some doubt is now clear. THX bro

    admin · July 18, 2018 at 9:24 pm

    welcome bro.
    subscribe Site for regular updates.

Steve Anc · August 20, 2018 at 8:44 pm

Very good post. Well written and informative. Thanks for this

Leave a Reply

Your email address will not be published. Required fields are marked *