Excel Paste Special | Every excel user must know in depth uses
ฝัง
- เผยแพร่เมื่อ 18 ม.ค. 2020
- Excel Paste Special helps to copy and paste data in a variety of interesting ways to accomplish many goals like We want to paste only Formula,Values,Formats only.
Using paste special option we are able to do calculation like sum,multiply divide etc without using formula,by using this useful option we are able to paste the link only and transpose the data from vertical to horizontal and many more.
Download the Assignment Master Practice Folder here (All Playlist Example at one place)
drive.google.com/drive/folder...
Website - "www.innozant.com"
Let's Connect:
Instagram ► / innozantofficial
Facebook ► / innozant
Twitter ► / innozant
Linkedin ► / inno. .
#PasteSpecial #SpecialPaste #ExcelTutorial #Innozant
Never used these many options because didn't know much about Special Paste. Well Done brother.
Thanks Sushil Ji
I have seen a lot of videos related to excel. The way you teach is awesome.
Thanks Harpreet Singh ji for such a valuable and lovely comment. Will try to make awesome content for all of you 🙏❤️
wow got to know about Paste link feature first time !!!!!
Thanks Arpita..Bus aap step by step seekhte jaiye..Bht amazing tricks and other features seekhenge aap..m sure you enjoy your course dear❤️
Wao we never know how dynamic paste special option is. Thank you so much sir
Thanks Riya..Keep Learning and Keep Growing ❤️
Awesome Lecture!
Thanks for teach us in very easy way
Good work .... great ❤❤
Sir you are my fav teacher
Was looking for something like this. Big thanks.
Thanks Shubhaahish 🙏❤️
Thanks for the helpful video bro.. You are so kind and humble.
Thanks Dear Prince ..Happy learning
Enjoying your videos... Great way of teaching... 👍
Thanks Shashank Ji...Love you Dear...Aaj Ka video jarur dekhna ..Special episode hai aaj..Aap enjoy kroge m sure .👍❤️🙏
Thnk you sir ji superb ... Method of teaching is awesome sir
Thanks Nikhil ji
Amazing sir ji thanks continue
Superb....!
Extremely thanks. Really great job.
Thanks
Thank you so much sir 😊
Amazing sir
🙏🙏🙏🙏
Nice
🌹राधे राधे 🌹ARK 🔥🏹हमेसा हंसते मुस्कुराते रहिये l
This is an Extremely informative video.
Thanks Narayan Ji..Happy learning dear
I love Your Classes Please Make a Complete Couse Class SQL Course
Amazing Operation Of Paste Special
Thanks Pawan
Nice video
Your teaching quality is wow
Thanks Keya..🙏♥️🙂 for such a lovely feedback.
Recommend you to start learning step by step from Basic Excel Playlist 1st Video onwards,Complete course i am uploading now,Aapko kahin fees deke course krne ki jarurat nhi padegi aisa main umeed krta hu.. Any doubt you may contact me -telegram id-@innozantofficial.
We welcome you to experience the taste of success.
bhayi ap ka sikhana very nice
Thanks dear
Good
osm sir
Aa jata h sb jo b ap btatey ho, apka way hi bhut acha h
Thanms Verma ji..Really means a lot to me dear Arti..Seekhiye achese..phir achisi job ka offet lettet leke dikhaiye . .Phir hogi party❤❤❤🙏🙏🙏
awesome teaching
Thanks Kishore.We welcome you to experience the taste of success with Innozant-Seed of Success.
Happy Learning dear.
Thank you sir
Thanks Jyoti
Excellent
♥️🙏
Very nice video Sir..
Thanks Palak..Happy learnjng dear❤🙏
Wow
superb
🙏❤️
wow😮😮😮
nice video
Thanks Manoj Ji
Super sir
Thanks ❤️🙏
Ap sbko answer, dete ho bo b bhut acha way h
Thanks Arti..Haan bhg expectations ke saath students msg krte hain to banta hai na answer karna
Sir is this paste special applicable on the multiple sheet of one workbook it is not working when I am trying to paste on another workbook's sheet
❤️
❤️❤️❤️❤️
💞👌
❤️❤️❤️
Love you sir🥰, I want to learn from you advance excel so what to do sir. ❤️
Hi Rishi, You may visit Innozant website or contact/whatsa is for more information about new upcoming batches.
@@Innozant okay sir ❤️
ek excel file se dusare micros enable file me value paste special karne ka sahi tarika kya hai?
Real banate ho bro
Thank you very much Sir ji. I never used these many options or I would say I didn't know how to use them. Once again nobody can beat your style.
Sir, why did you skip the blank option?
Thanks...oho blank option skip ho gya hoga video banate time flow me..will cover it in shorts videos
@@Innozant Sir notification me bathaiyega.. thanks
Hi sir, please let me explain what is the difference between Dynamic and static??
In computer terminology, dynamic usually means capable of action and/or change, while static means fixed.
Sir, on which version of excel are you teaching us? And on which version of excel should we learn?
Now using office 365 but earlier office 2016
Hello sir, Akansha is here , i have a question that is the paste linked in paste special not applicable with formulas table?
Hi Akansha,Kindly describe your query again as you said paste link is not applicable with formula table ? didn't get you
Sir.... jab paste link Karte hain toh blank cells mein 0 aata Hai aur usko hatane k liye jab paste as values Karte hain toh data change nahi Hota Hai... plz help on it sir
linked is not used with formulas ?
Kindly download assignment master link from video description
Sir MS Office 2007 me Paste Link ka option toh hai per inactive dikha rha hai
Usper click hi nhi hota
Sir koi solution
Sir Awesome Lecture! Is it feasible for you the XL sheet that you are working in this video - can you provide direct link. this would be much easier for the students who are following your channel and learning XL.
Kindly download it from the link given in video description-Assignment master -Basic excel playlist
Thank you so for teaching.
Sir aapne validation ke paste special ka use bataya hai but maine try same to same. Paste special than validation per click kiya mere pass validation blank arha hai.
Plz help me
Data tab me jake-Data validation-list (phir range select) - Validation lag Jayega list ke base par ..ab jahan validation laga hai wo cell Samer dart range select kren phir copy then oasf in anothr location..vakiday blank nhi aa rha hai aap check kisi aur cell me Kar rhe hai dear..phirse kijiye ek Baar Practice paste special ki. ❤️🙏
Paist special link me new entry bhi link hogi kya sr
Apka pucha gya question clear nhi hai ki aap puchna kya chahte hain.
Sir pest special ka shortcut alt+e+s
Ctrl alt v and alr e s both
Sir Shubham aur Aarti kon hai
Jaise aap hain student ❤️🙏Mehnat krenge khudpe to bht jald aapka bhi msg mujhe dekhne ko milega ki apne bhi spne career ki shuruwat kar li h.
Sir, I need Excel Paste Special Sheet for Practice, please help Sir.
Video description me jaiye .. assignment master folder me basic excel folder hai usme hai practice file
@@InnozantSir, I am not able to find it, Please let me know workbook name.
Sir paste link hum different sheets pr use kr skte hain?
It will work sir thank uh soo much for your guidance.
Haan Mamta kat skte h,Paste as i.age bhi kr skte h aur wo dynamically update bhi hoga
❤️
Sir,you miss blank topics
Blank baatya Hoga sayad..may be flow me miss ho gya hoga.Go to special ke video dekhiye..usme cover kiye h
How to paste in filtered visible cell
First select the destination area range where you want to paste filtered visible cells then =filtered data cell Reference (ex-A2) now press Ctrl+Enter
@@Innozant I want to paste data in filtered visible cell(eg A2,A5,A7,A24,A30)from same number of cell data(egC45:C49 )from another sheet
Copy and paste visible cells only or alt +;
Still issue you may send me the data sheet for the same
please Excel File send
Thanku karan for your valuable feedback..Keep in touch for latest video and study material.
HOW TO CONVERT NUMBER TO TEXT LIKE 12345 IN ONE TWO THREE FOUR FIVE
Soon .you may able to watch this video.🙏❤️
Sab to sahi hai but ye over acting Aarti Pooja ye achha nhi lga apka
Singh sahab ye live class video recording hain to kya student ke query nhi sunega teacher ?Kindly focus on the delivered content ,if you feel it's worth continue the session else quit😊