दोस्तों Excel Sheet में अगर बहुत सारे फ़ॉर्मूलास लगे हों और डाटा भी बहुत ज्यादा हो तो Excel Sheet Ka Size तो ज्यादा हो ही जाता है अक्सर एक्सेल वर्कबुक बहुत स्लो भी हो जाती है और आज 2021 के टाइम में ना स्लो चीज़े कसम से बहुत इर्रिटेट करती हैं तो अगर आपके भी यही सवाल हैं की Excel Sheet Ka Size Kaise Kam Kare और स्लो एक्सेल वर्कबुक को सुपरतस्त कैसे बनाएं तो इस पोस्ट में हम आपको एक्सेल की एक कमाल की छोटी सी ट्रिक बता रहें हैं जिससे Excel Workbook का Size भी 3 गुना Reduce होगा और Workbook सुपरफास्ट काम करेगी और ये 7 एक्सेल की बेस्ट 2021 टिप्स भीआप जरूर सीख लो
Excel Sheet Ka Size Aise Kam Kare
- Excel File को ओपन करना है और File टैब में Save As पे जाना है Save As के लिए आप F12 शॉर्टकट भी उसे कर सकते हो
- पहले Excel Sheet का कोई दूसरा नाम देना है और नीचे आपको Save As की लिस्ट पे क्लिक करना है और Excel Binary Workbook सेलेक्ट करके एक्सेल वर्कबुक को सेव कर देता है बस मैजिक हो गया
अब ये एक्सेल फाइल Binary Format में सेव हो गयी है आप इस Excel Sheet ka Size चेक करोगे तो लगभग 3 गुना काम मिलेगा और अब वर्कबुक सुपरफास्ट वर्क करेगी
अब आपके मन में एक सवाल जरूर टिक टिक कर रहा होगा की क्या Binary Format में एक्सेल वर्कबुक को सेव करने के बाद फ़ॉर्मूलास प्रॉपर काम करेंगे मैक्रोस प्रॉपर काम करेंगे तो जबाब है हाँ सबकुछ प्रॉपर काम करेगा
ये ट्रिक तब आपके बहुत काम आएगी जब आपको कोई ज्यादा साइज की एक्सेल वर्कबुक किसी को मेल करनी है या स्लो वर्कबुक में आपको काम करना हो ! काम होने के बाद या मेल से डाउनलोड करने के बाद आप इसको फिर से नार्मल एक्सेल फॉर्मेट में सेव भी कर सकते हो बस इसके लिए आपको Save As Type लिस्ट में से Excel Workbook सेलेक्ट करके अपनी वर्कबुक सेव कर लेनी है
दोस्तों हमारी ये पोस्ट आपको कैसी लगी कमेंट करके अपना फीडबैक जरूर दें ! और हां हमारे YouTube चैनल को आप जरूर सब्सक्राइब कर ले वहां पर हम आपके लिए नए-नए एक्सेल के काम आने वाले वीडियोस अपलोड करते रहते हैं
BRO YOU ARE GREAT …
I quite like looking through a post that can make people think.
Also, many thanks for permitting me to comment!
No matter if some one searches for his essential
thing, thus he/she desires to be available that in detail, so that thing is maintained over here.
If some one desires expert view concerning blogging and site-building afterward i suggest him/her to go to see this blog,
Keep up the pleasant work.
Keep on writing, great job!
I visited various websites but the audio quality for audio
songs present at this web page is really superb.
Hey I know this is off topic but I was wondering if you knew of
any widgets I could add to my blog that automatically tweet my
newest twitter updates. I’ve been looking for a plug-in like this for quite
some time and was hoping maybe you would have some experience with something like this.
Please let me know if you run into anything.
I truly enjoy reading your blog and I look forward to your new updates.
You actually make it seem so easy with your presentation however I in finding this matter to be really something that
I believe I would by no means understand. It kind of
feels too complex and very large for me. I’m taking a look ahead to your
subsequent publish, I will attempt to get the dangle of it!
My spouse and I absolutely love your blog and find most of your post’s to be what precisely I’m looking for.
Does one offer guest writers to write content in your case?
I wouldn’t mind publishing a post or elaborating on a lot of the subjects you
write regarding here. Again, awesome site!
hi
Deepak Bhai
i have one stock sheet i need vlook up in this sheet can u help me and also if any formula is required can u guide me please
naturally like your website however you need
to test the spelling on several of your posts. Several of
them are rife with spelling problems and I in finding it very troublesome
to tell the reality on the other hand I’ll certainly come again again.
Enjoyed every bit of your blog.Much thanks again.
magnificent points altogether, you just gained a new reader.
What could you recommend in regards to your submit that you simply made some days in the
past? Any certain?
Thank you for the auspicious writeup. It in fact was a amusement account it.
Look advanced to more added agreeable from you!
However, how can we communicate?
Thanks to my father who stated to me concerning this blog, this blog is in fact remarkable.
Terrific work! This is the type of info that are meant to be shared around the net.
Disgrace on Google for not positioning this publish higher!
Come on over and discuss with my website . Thank you =)
Hello! I realize this is somewhat off-topic but I had to ask.
Does operating a well-established blog like yours require a lot of work?
I’m completely new to blogging however I do write in my journal daily.
I’d like to start a blog so I can easily share my personal
experience and views online. Please let me know if you have
any recommendations or tips for new aspiring blog owners.
Thankyou!
It’s not my first time to visit this web site, i am browsing
this web site dailly and get good data from here all the time.
each time i used to read smaller posts that also
clear their motive, and that is also happening with this post which I am reading now.
The next time I read a blog, I hope that it doesnt disappoint me as much as this one. I mean, I know it was my choice to read, but I actually thought youd have something interesting to say. All I hear is a bunch of whining about something that you could fix if you werent too busy looking for attention.
Wow that was strange. I just wrote an really long comment but after I clicked
submit my comment didn’t appear. Grrrr… well I’m not writing
all that over again. Anyhow, just wanted to say wonderful blog!
Good write-up, I am regular visitor of one¦s web site, maintain up the nice operate, and It is going to be a regular visitor for a lengthy time.
Once I initially commented I clicked the -Notify me when new comments are added- checkbox and now each time a comment is added I get four emails with the identical comment. Is there any method you can remove me from that service? Thanks!