Excel Paste Special | Every excel user must know in depth uses

Подписаться 149 тыс.

Просмотров 52 тыс.

50% 1

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

Опубликовано:

18 янв 2020

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 117

@techbing2639 3 дня назад

ऐसा तो पूरे यूट्यूब पर किसी ने नही पढाया सर थैंक्स यू ❤

@Innozant 3 дня назад

Thanks...Keep learning

@sushilchoudhary1328 3 года назад

Never used these many options because didn't know much about Special Paste. Well Done brother.

@Innozant 3 года назад

Thanks Sushil Ji

@rahmatshalmani3210 7 месяцев назад

Good work .... great ❤❤

@aatifrashid5413 Год назад

Awesome Lecture!

@huzefakhan3252 Год назад

Sir you are my fav teacher

@harpreetsingh_singhfootwea199 3 года назад

I have seen a lot of videos related to excel. The way you teach is awesome.

@Innozant 3 года назад

Thanks Harpreet Singh ji for such a valuable and lovely comment. Will try to make awesome content for all of you 🙏❤️

@mdayubkhan8544 2 года назад

Thanks for teach us in very easy way

@arunkumarsinghark3024 2 года назад

Amazing sir ji thanks continue

@sanjaysingh-ci1hc Год назад

Amazing sir 🙏🙏🙏🙏

@deepshivhare Год назад

Thank you so much sir 😊

@princemjprasanth8954 3 года назад

Thanks for the helpful video bro.. You are so kind and humble.

@Innozant 3 года назад

Thanks Dear Prince ..Happy learning

@shahzadsiddiqui5117 Год назад

Superb....!

@Riyavlogs_24 Месяц назад

Wao we never know how dynamic paste special option is. Thank you so much sir

@Innozant Месяц назад

Thanks Riya..Keep Learning and Keep Growing ❤️

@shashanksingh5170 3 года назад

Enjoying your videos... Great way of teaching... 👍

@Innozant 3 года назад

Thanks Shashank Ji...Love you Dear...Aaj Ka video jarur dekhna ..Special episode hai aaj..Aap enjoy kroge m sure .👍❤️🙏

@sohrabali6080 3 года назад

Extremely thanks. Really great job.

@Innozant 3 года назад

Thanks

@pratyushnigam8956 2 года назад

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

@narayanbadatya2387 2 года назад

This is an Extremely informative video.

@Innozant 2 года назад

Thanks Narayan Ji..Happy learning dear

@shuvashishdey7389 3 года назад

Was looking for something like this. Big thanks.

@Innozant 3 года назад

Thanks Shubhaahish 🙏❤️

@atulgoodify Год назад

Nice video

@arpitadebnath15 3 года назад

wow got to know about Paste link feature first time !!!!!

@Innozant 3 года назад

Thanks Arpita..Bus aap step by step seekhte jaiye..Bht amazing tricks and other features seekhenge aap..m sure you enjoy your course dear❤️

@nikhilsinger6306 2 года назад

osm sir

@str5148 Год назад

Nice

@artiverma5122 3 года назад

Aa jata h sb jo b ap btatey ho, apka way hi bhut acha h

@Innozant 3 года назад

Thanms Verma ji..Really means a lot to me dear Arti..Seekhiye achese..phir achisi job ka offet lettet leke dikhaiye . .Phir hogi party❤❤❤🙏🙏🙏

@nikhilved484 Год назад

Thnk you sir ji superb ... Method of teaching is awesome sir

@Innozant Год назад

Thanks Nikhil ji

@pawanverma7220 3 года назад

Amazing Operation Of Paste Special

@Innozant 3 года назад

Thanks Pawan

@ravikagrwa 2 года назад

I love Your Classes Please Make a Complete Couse Class SQL Course

@keyasen8798 3 года назад

Your teaching quality is wow

@Innozant 3 года назад

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.

@artiverma5122 3 года назад

Ap sbko answer, dete ho bo b bhut acha way h

@Innozant 3 года назад

Thanks Arti..Haan bhg expectations ke saath students msg krte hain to banta hai na answer karna

@arunkumarsinghark3024 2 года назад

🌹राधे राधे 🌹ARK 🔥🏹हमेसा हंसते मुस्कुराते रहिये l

@abcabc05 2 года назад

ek excel file se dusare micros enable file me value paste special karne ka sahi tarika kya hai?

@gauravbhatia7987 3 года назад

Good

@saritadimri3192 Год назад

bhayi ap ka sikhana very nice

@Innozant Год назад

Thanks dear

@kishoreallampallu7485 3 года назад

awesome teaching

@Innozant 3 года назад

Thanks Kishore.We welcome you to experience the taste of success with Innozant-Seed of Success. Happy Learning dear.

@Baghelscorner 2 года назад

Thank you sir

@Innozant 2 года назад

Thanks Jyoti

@someonefrom2002 3 года назад

Sir MS Office 2007 me Paste Link ka option toh hai per inactive dikha rha hai Usper click hi nhi hota Sir koi solution

@palakgoel34 3 года назад

Very nice video Sir..

@Innozant 3 года назад

Thanks Palak..Happy learnjng dear❤🙏

@rsfastnersfixingsltd 11 месяцев назад

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

@Jayuchalwadi 3 года назад

Excellent

@Innozant 3 года назад

♥️🙏

@mrvikas2089 10 месяцев назад

wow😮😮😮

@tripathiashish06 3 года назад

superb

@Innozant 3 года назад

🙏❤️

@ravidaksh4348 4 года назад

Wow

@manojrudra6007 2 года назад

nice video

@Innozant 2 года назад

Thanks Manoj Ji

@jayveersingh2583 3 года назад

Super sir

@Innozant 3 года назад

Thanks ❤️🙏

@PankajSharma-vf2qd 2 года назад

Hi sir, please let me explain what is the difference between Dynamic and static??

@nikhilsinger6306 2 года назад

In computer terminology, dynamic usually means capable of action and/or change, while static means fixed.

@ManjeetSingh-th4fu 2 года назад

Sir, on which version of excel are you teaching us? And on which version of excel should we learn?

@Innozant 2 года назад

Now using office 365 but earlier office 2016

@rishimandal7508 2 года назад

Love you sir🥰, I want to learn from you advance excel so what to do sir. ❤️

@Innozant 2 года назад

Hi Rishi, You may visit Innozant website or contact/whatsa is for more information about new upcoming batches.

@rishimandal7508 2 года назад

@@Innozant okay sir ❤️

@meriawaazhindi5217 Год назад

❤️❤️❤️❤️

@Altaf_Alam Год назад

❤️

@akansharathore7346 Год назад

linked is not used with formulas ?

@Innozant Год назад

Kindly download assignment master link from video description

@RA-rh5lb Год назад

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?

@Innozant Год назад

Thanks...oho blank option skip ho gya hoga video banate time flow me..will cover it in shorts videos

@RA-rh5lb Год назад

@@Innozant Sir notification me bathaiyega.. thanks

@akansharathore7346 Год назад

Hello sir, Akansha is here , i have a question that is the paste linked in paste special not applicable with formulas table?

@Innozant Год назад

Hi Akansha,Kindly describe your query again as you said paste link is not applicable with formula table ? didn't get you

@virendersroha1754 4 года назад

Paist special link me new entry bhi link hogi kya sr

@Innozant 4 года назад

Apka pucha gya question clear nhi hai ki aap puchna kya chahte hain.

@pushpapal5030 3 года назад

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

@Innozant 3 года назад

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. ❤️🙏

@ryanhawk366 2 года назад

Real banate ho bro

@pa2happiness13 3 года назад

💞👌

@Innozant 3 года назад

❤️❤️❤️

@subashkumar-es2sn 2 года назад

Sir, I need Excel Paste Special Sheet for Practice, please help Sir.

@Innozant 2 года назад

Video description me jaiye .. assignment master folder me basic excel folder hai usme hai practice file

@subashkumar-es2sn 2 года назад

@@InnozantSir, I am not able to find it, Please let me know workbook name.

@mamtamishra7882 2 года назад

Sir paste link hum different sheets pr use kr skte hain?

@mamtamishra7882 2 года назад

It will work sir thank uh soo much for your guidance.

@Innozant 2 года назад

Haan Mamta kat skte h,Paste as i.age bhi kr skte h aur wo dynamically update bhi hoga

@Innozant 2 года назад

❤️

@AS-uz2gf 2 года назад

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.

@Innozant 2 года назад

Kindly download it from the link given in video description-Assignment master -Basic excel playlist

@shashibhushan4515 4 года назад

How to paste in filtered visible cell

@Innozant 4 года назад

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

@shashibhushan4515 4 года назад

@@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

@Innozant 4 года назад

Copy and paste visible cells only or alt +;

@Innozant 4 года назад

Still issue you may send me the data sheet for the same

@johndas8173 3 года назад

Sir pest special ka shortcut alt+e+s

@Innozant 3 года назад

Ctrl alt v and alr e s both

@someonefrom2002 3 года назад

Sir Shubham aur Aarti kon hai

@Innozant 3 года назад

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.

@omparkashpatlan 3 года назад

HOW TO CONVERT NUMBER TO TEXT LIKE 12345 IN ONE TWO THREE FOUR FIVE

@Innozant 3 года назад

Soon .you may able to watch this video.🙏❤️

@karankapoor200 4 года назад

please Excel File send

@Innozant 4 года назад

Thanku karan for your valuable feedback..Keep in touch for latest video and study material.

@ajaysaroha2539 3 года назад

Sir,you miss blank topics

@Innozant 3 года назад

Blank baatya Hoga sayad..may be flow me miss ho gya hoga.Go to special ke video dekhiye..usme cover kiye h

@dharamveersingh812 2 года назад

Sab to sahi hai but ye over acting Aarti Pooja ye achha nhi lga apka

@Innozant 2 года назад

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😊