This video is very helpful to me ❤

The numbers can be whatever I want, is it??

Thanks a whole bunch. Major thumbs up! 👍👍👍

This saved me hours of work. Cheers!

Awesome function! This is going to help me tremendously

you're a legend

Thank you very much Its working and you made it very simple

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.

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 ?

👋 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/

IS there a shortcut to delete rows from 101 row to last rows 1,048,576? Thanks

very clear instructions and I liked the variations you offered!

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

Barcode fonts may look OK, but they experience printing and reading issues.

Thank you,

you can find some auto saved versions of the sheet in recyclebin

i get a SPILL in my example :(

happy sunday

Helpful

Great help...

Thank you my man!

is this possible in local network and how ?

Ho, great and promising video. But - which us surely not your fault !! - my excel does not allow get data from PDF. And now?

you made it incredibly easy, thank you!

Simple and easy to understand. Many thanks!

How attach insert embedded objects pdf/excel/email/word using macro Code

Exactly what I was after. Thank you.

How is there a pdf option in the drop down. I dont have one

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

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?

this is incomplete video, useless

Thank you 🎉 straight forward and definitely learned something new

👋 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/

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

Thnx, could you share with us if we have a duplicated valu as its only return the first match

I cant seem to get the function to work with the “1”. Is this version specific? I am using excel 2016

I love how you explain it in slow explanation and in sequence so I would understand it very quickly, thanks a whole lot sir

how can we do it without sharing in one drive ?..

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?

My Guy you the man Thank You for the help really appreciate

This was a miracle video for my online Excel class. Thanks a bunch!

Thank you that was quick :-)

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?

taylor would be proud.

Thank you so much It saved me a lot 😂😂

Thumbs up if you are also creating your new Taylor Swift concert tickets.

This really amazing mannn

Who is here from the ticketmaster breach? 👀

YOU FORGOT MOST IMPOTENT PART BRO AND INSTEAD PROMOTED YOUR BRAND

You didn't even show how the other person got the file? How was it shared? You missed the most important part!