Awesome function! This is going to help me tremendously
@noureddineIDALI6 күн бұрын
you're a legend
@pavankishore78276 күн бұрын
Thank you very much Its working and you made it very simple
@OrvilleScott6 күн бұрын
PRO TIP: You won't be able to freeze both a row and a column ( a.k.a Freeze Panes At Selection via just selecting one cell only ) if the cells in your Excel spreadsheet are too large.
@mysandeepc6 күн бұрын
Thanks for the video. Cells selected and locked and then sheet protected. But after protecting sheet, how can we do edit in unprotected cells which i didnt select ?
@Spreadsheeto7 күн бұрын
👋 3 ways I can help you! 1) *Free 30-minute Excel Course:* Try a course that adapts to your skill level, trusted by over 100,000 students! spreadsheeto.com 2) *Fast-Track Your Excel Learning:* "Zero to Hero" transforms you from a beginner to an Excel superuser in just 14 hours. spreadsheeto.com/zero-to-hero/ 3) *Custom Solutions for Busy Professionals:* Busy or stuck? Hire me to fix or build custom spreadsheets. spreadsheeto.com/excel-consultant/
@therencevaldez28418 күн бұрын
IS there a shortcut to delete rows from 101 row to last rows 1,048,576? Thanks
@bagwa88 күн бұрын
very clear instructions and I liked the variations you offered!
@vishalsaran45139 күн бұрын
How many users can work concurrently following this method. Is there a limit on number of users? Will it more for more than 50 people team? Please advise
@rcsontag9 күн бұрын
Barcode fonts may look OK, but they experience printing and reading issues.
@theharsh20059 күн бұрын
Thank you,
@sudheer73129 күн бұрын
you can find some auto saved versions of the sheet in recyclebin
@emirtm10 күн бұрын
i get a SPILL in my example :(
@Ranelbaba10 күн бұрын
happy sunday
@michelemelendez736211 күн бұрын
Helpful
@SaadMalik_EO11 күн бұрын
Great help...
@NonCompanyComedy12 күн бұрын
Thank you my man!
@getrekt851513 күн бұрын
is this possible in local network and how ?
@janihden628113 күн бұрын
Ho, great and promising video. But - which us surely not your fault !! - my excel does not allow get data from PDF. And now?
@erpampa9413 күн бұрын
you made it incredibly easy, thank you!
@Mary.L-cj4ej14 күн бұрын
Simple and easy to understand. Many thanks!
@990102871114 күн бұрын
How attach insert embedded objects pdf/excel/email/word using macro Code
@ufsta14 күн бұрын
Exactly what I was after. Thank you.
@Siddarth198715 күн бұрын
How is there a pdf option in the drop down. I dont have one
@nastykitten897017 күн бұрын
for the love of fucking christ i have tried this shit for months and cannot figure out what the fucking goddam hell im doing wrong
@ehsannabavi755117 күн бұрын
this method wont work if I protect my file. if I leave it out of protection anyone can delete it. is there any other way or maybe a way to protect my file while object link still work?
@dhruvgupta899318 күн бұрын
this is incomplete video, useless
@carlosdg231918 күн бұрын
Thank you 🎉 straight forward and definitely learned something new
@Spreadsheeto19 күн бұрын
👋 3 ways I can help you! 1) *Free 30-minute Excel Course:* Try a course that adapts to your skill level, trusted by over 100,000 students! spreadsheeto.com 2) *Fast-Track Your Excel Learning:* "Zero to Hero" transforms you from a beginner to an Excel superuser in just 14 hours. spreadsheeto.com/zero-to-hero/ 3) *Custom Solutions for Busy Professionals:* Busy or stuck? Hire me to fix or build custom spreadsheets. spreadsheeto.com/excel-consultant/
@irwanhalim741521 күн бұрын
Dear Spreadsheeto. REgarding the multiple dependent dropdown list, can we do it for by row instead of column? if we see your video, you put the country name side by side, and the assistant name below the country. can we do the assistant names beside the relating country, and the countries in a single column? thank you
@eslamfahmy8722 күн бұрын
Thnx, could you share with us if we have a duplicated valu as its only return the first match
@andymillard569222 күн бұрын
I cant seem to get the function to work with the “1”. Is this version specific? I am using excel 2016
@andymillard569222 күн бұрын
I added an additional index to handle the array…. Works!
@naruhach556626 күн бұрын
I love how you explain it in slow explanation and in sequence so I would understand it very quickly, thanks a whole lot sir
@solarzv180326 күн бұрын
how can we do it without sharing in one drive ?..
@ronalmr278927 күн бұрын
Hi, I learn a lot from your tutorial thanks, man. but I have a problem I hope you can solve, is it possible to remove an item from the data validation list once used in the indirect method?
@RayvinDomingo28 күн бұрын
My Guy you the man Thank You for the help really appreciate
@ghostyghost8322Ай бұрын
This was a miracle video for my online Excel class. Thanks a bunch!
@SanjayYadav-bm9ngАй бұрын
Thank you that was quick :-)
@liammurray9681Ай бұрын
Hi, this video is great, and I am doing something similar however my "customer name" which is "cables" to me has multiple tables for different types, then based on each table there is different sizes. Is there a way to select a certain table, then from there list only the sizes in that table and select which one?
@mawa8597Ай бұрын
taylor would be proud.
@KingKIK0Ай бұрын
link to leak?
@dayoupkeshupamomАй бұрын
Thank you so much It saved me a lot 😂😂
@KingKIK0Ай бұрын
link to leak?
@uberdumpАй бұрын
Thumbs up if you are also creating your new Taylor Swift concert tickets.
@KingKIK0Ай бұрын
link to leak?
@uberdumpАй бұрын
@@KingKIK0 haha, good try Swifty’s lawyers.
@stolengrilfriendclub8724Ай бұрын
This really amazing mannn
@nmap-p-Ай бұрын
Who is here from the ticketmaster breach? 👀
@KingKIK0Ай бұрын
link to leak?
@THELASTNUMBER1Ай бұрын
YOU FORGOT MOST IMPOTENT PART BRO AND INSTEAD PROMOTED YOUR BRAND
@wyattbonnette3414Ай бұрын
You didn't even show how the other person got the file? How was it shared? You missed the most important part!