Excel में Automatic Border कैसे लगाएँ ? Automatic Border in MS Excel

नमस्कार दोस्तों
मै विनय आपका दोस्त
आपका बहुत बहुत स्वागत है
आशा करता हूँ आप अच्छे और स्वस्थ होंगे

Excel में Automatic Border कैसे लगाएँ?

1. सबसे पहले Excel, Open करना है। 

2. इसके बाद Excel के First Cell पर Click करना है। 

3. इसके बाद Excel में Ctrl + A , दबाके सभी Cells को सेलेक्ट करना है। 

4. इसके बाद Conditional Formatting पे Click करना है। 

5. इसके बाद New Rule पर Click करना है। 

6. इसके बाद "Use a formula to determine which cells to format" पे Click करना है। 

7. इसके बाद "Format values where this formula is true" इस लाइन के नीचे वाले बॉक्स में फॉर्मूला टाइप करना है। 

8. सबसे पहले = टाइप करना है। 

9. इसके बाद First Cell को Select करना है। 

10. इसके बाद डॉलर का Symbol हटाना है। 

11. इसके बाद < > टाइप करना है। 

12. इसके बाद "" टाइप करना है। 

आप नीचे चित्र में देख सकते है। 

13. इसके बाद Format पर Click करना है। 

14. इसके बाद Border पर Click करना है। 

15. इसके बाद Outline पर Click करना है। 

16. इसके बाद Ok करना है। 

17. फिर इसके बाद Ok करना है। 

उम्मीद करता हूँ दोस्तों आप Excel में Automatic Border लगाना अच्छे से सीख गए होंगे। यदि आपको Excel में Automatic Border लगाने में किसी भी प्रकार की कोई प्रॉब्लम आती है तो आप हमें WhatsApp करके पूछ सकते है।

WhatsApp Number : +91 9650597419  

दोस्तों यदि यह जानकारी आपको अच्छी लगी हो तो इसे अपने दोस्तों के साथ शेयर जरूर करें ताकि आपके दोस्तों को भी इसके बारे में पता चल सके।

-----------------------------------------------------------------------------------------------------------------------------

ALL COMPUTER PDF NOTES AVAILABLE IN HINDI & ENGLISH MEDIUM

BUY NOW     DOWNLOAD NOW

-----------------------------------------------------------------------------------------------------------------------------

COMPUTER NOTES FOR TEACHERS AVAILABLE IN HINDI & ENGLISH MEDIUM

Dear Teachers ऐसा कंप्यूटर नोट्स जिसे आप पढ़कर बच्चों को आसानी से पढ़ा सकते हैं। यह नोट्स केवल कंप्यूटर इंस्टिट्यूट एवं टीचर्स के लिए हैं। इस नोट्स में आप अपना Watermark, Header / Footer और या Logo भी लगा सकते हैं। यदि आपको नोट्स खरीदने से रिलेटेड कोई भी problem आती है तो आप हमें Call या WhatsApp कर सकते हैं। Call / WhatsApp: +91 9650597419

BUY NOW     DOWNLOAD NOW

-----------------------------------------------------------------------------------------------------------------------------

COMPUTER PDF NOTES IN ENGLISH

BUY NOW     DOWNLOAD NOW

-----------------------------------------------------------------------------------------------------------------------------

COMPUTER PDF NOTES IN HINDI

BUY NOW     DOWNLOAD NOW

-----------------------------------------------------------------------------------------------------------------------------

BASIC COMPUTER PDF NOTES IN ENGLISH

BUY NOW     DOWNLOAD NOW

-----------------------------------------------------------------------------------------------------------------------------

BASIC COMPUTER PDF NOTES IN HINDI

BUY NOW     DOWNLOAD NOW

-----------------------------------------------------------------------------------------------------------------------------

MS WORD PDF NOTES IN ENGLISH

BUY NOW     DOWNLOAD NOW

-----------------------------------------------------------------------------------------------------------------------------

MS WORD PRACTICE ASSIGNMENT FILE

BUY NOW     DOWNLOAD NOW

-----------------------------------------------------------------------------------------------------------------------------

MS WORD PDF NOTES IN HINDI

BUY NOW     DOWNLOAD NOW

-----------------------------------------------------------------------------------------------------------------------------

MS EXCEL PDF NOTES IN ENGLISH

BUY NOW     DOWNLOAD NOW

-----------------------------------------------------------------------------------------------------------------------------

MS EXCEL PDF NOTES IN HINDI

BUY NOW     DOWNLOAD NOW

-----------------------------------------------------------------------------------------------------------------------------

MS EXCEL PRACTICE ASSIGNMENT FILE

BUY NOW     DOWNLOAD NOW

-----------------------------------------------------------------------------------------------------------------------------

INTERNET PDF NOTES IN HINDI

BUY NOW     DOWNLOAD NOW

-----------------------------------------------------------------------------------------------------------------------------

COMPUTER / LAPTOP REPAIRING NOTES IN HINDI

BUY NOW     DOWNLOAD NOW

-----------------------------------------------------------------------------------------------------------------------------

HTML PDF NOTES IN ENGLISH

BUY NOW     DOWNLOAD NOW

-----------------------------------------------------------------------------------------------------------------------------

HTML PDF NOTES IN HINDI

BUY NOW     DOWNLOAD NOW

-----------------------------------------------------------------------------------------------------------------------------

CSS PDF NOTES IN ENGLISH

BUY NOW     DOWNLOAD NOW

-----------------------------------------------------------------------------------------------------------------------------

CSS PDF NOTES IN HINDI

BUY NOW     DOWNLOAD NOW

-----------------------------------------------------------------------------------------------------------------------------

JAVASCRIPT PDF NOTES IN ENGLISH

BUY NOW     DOWNLOAD NOW

-----------------------------------------------------------------------------------------------------------------------------

JAVASCRIPT PDF NOTES IN HINDI

BUY NOW     DOWNLOAD NOW

-----------------------------------------------------------------------------------------------------------------------------

JQUERY PDF NOTES IN ENGLISH

BUY NOW     DOWNLOAD NOW

-----------------------------------------------------------------------------------------------------------------------------

JQUERY PDF NOTES IN HINDI

BUY NOW     DOWNLOAD NOW

-----------------------------------------------------------------------------------------------------------------------------

BOOTSTRAP PDF NOTES IN ENGLISH

BUY NOW     DOWNLOAD NOW

-----------------------------------------------------------------------------------------------------------------------------

BOOTSTRAP PDF NOTES IN HINDI

BUY NOW     DOWNLOAD NOW

-----------------------------------------------------------------------------------------------------------------------------

SQL LANGUAGE PDF NOTES IN ENGLISH

BUY NOW     DOWNLOAD NOW

-----------------------------------------------------------------------------------------------------------------------------

SQL LANGUAGE PDF NOTES IN HINDI

BUY NOW     DOWNLOAD NOW

-----------------------------------------------------------------------------------------------------------------------------

PHP PDF NOTES IN ENGLISH

BUY NOW     DOWNLOAD NOW

-----------------------------------------------------------------------------------------------------------------------------

PHP PDF NOTES IN ENGLISH

BUY NOW     DOWNLOAD NOW

-----------------------------------------------------------------------------------------------------------------------------

PHP PDF NOTES IN HINDI

BUY NOW     DOWNLOAD NOW

-----------------------------------------------------------------------------------------------------------------------------

WODPRESS PDF NOTES IN ENGLISH

BUY NOW     DOWNLOAD NOW

-----------------------------------------------------------------------------------------------------------------------------

WORDPRES PDF NOTES IN HINDI

BUY NOW     DOWNLOAD NOW

-----------------------------------------------------------------------------------------------------------------------------

C  LANGUAGE PDF NOTES IN ENGLISH

BUY NOW     DOWNLOAD NOW

-----------------------------------------------------------------------------------------------------------------------------

C LANGUAGE PDF NOTES IN HINDI

BUY NOW     DOWNLOAD NOW

-----------------------------------------------------------------------------------------------------------------------------

C++ PDF NOTES IN ENGLISH

BUY NOW     DOWNLOAD NOW

-----------------------------------------------------------------------------------------------------------------------------

C++ PDF NOTES IN HINDI

BUY NOW     DOWNLOAD NOW

-----------------------------------------------------------------------------------------------------------------------------

JAVA PDF NOTES IN ENGLISH

BUY NOW     DOWNLOAD NOW

-----------------------------------------------------------------------------------------------------------------------------

JAVA PDF NOTES IN HINDI

BUY NOW     DOWNLOAD NOW

-----------------------------------------------------------------------------------------------------------------------------

PYTHON PDF NOTES IN ENGLISH

BUY NOW     DOWNLOAD NOW

-----------------------------------------------------------------------------------------------------------------------------

PYTHON PDF NOTES IN HINDI

BUY NOW     DOWNLOAD NOW

-----------------------------------------------------------------------------------------------------------------------------

CLOUD COMPUTING PDF NOTES IN ENGLISH

BUY NOW     DOWNLOAD NOW

-----------------------------------------------------------------------------------------------------------------------------

CLOUD COMPUTING PDF NOTES IN HINDI

BUY NOW     DOWNLOAD NOW

-----------------------------------------------------------------------------------------------------------------------------

DIGITAL MARKETING PDF NOTES IN ENGLISH

BUY NOW     DOWNLOAD NOW

-----------------------------------------------------------------------------------------------------------------------------

DIGITAL MARKETING PDF NOTES IN HINDI

BUY NOW     DOWNLOAD NOW

-----------------------------------------------------------------------------------------------------------------------------