วีดีโอ

Thank you! The second method worked best for the way my data is formatted.

Thanks so much

This title should be "how to swap columns in google sheets' not cells.

doesn't work for me either; i also read somewhere that it has to be in english/usa, your device and i'm italian and mine is in italian, so maybe that's why?

Thanks so much! This made total sense and helped so much!

This is exactly what I wanted -- a formula-based auto-sort, no macros or add-ins needed! Your explanation is clear and precise! Thanks so much! I want the users to see only the sorted table, so I put the source table where they won't see it. Another wrinkle I might try: put the source data on another sheet and protect the sheet with the sorted data so users can't mess with it.

Thank you

Thanks you so much for your help❤❤❤❤❤

When I do it it showes Date in the cell why?

This works for me WITHIN a Sheet. However, is there a way to copy conditional formatting BETWEEN DIFFERENT sheets? I can't seem to make this work

This is a ridiculously misnamed video and a waste of our time. The correct name is how to copy-paste contents of the columns, not even separate cells

Thank you for this google sheets trick. Very heplful.

Thank you for this google sheets trick! Very helpful.

Hell yeah! thank you!

thank you so much man you deserve more appriciation:)

thanks sir

Plz teach how to fill ye total spread row

It's not swapping

This is clearing the cells, or deleting the content. This is not deleting the cells...

Doesnt work for me. The box is already checked for auto capitalization and it does not capitalize the first word of a sentence.

Those are columns, not cells. This is frustrating.

Just shut up and explain it. 30 seconds of introduction for a video that needs to be 30 seconds or shorter

Seriously so helpful!! I could not figure this out.

All I"m thinking is MS Word probably COPYRIGHTED that feature because 1. Why couldn't they easily make is accessible as MS Word, 2. I have the "Autocatalyze" activated but its not working...What a jive!!

This is what I was looking for, thank you!

Awesome!!! Thanks for the video!

Thank you so much!!! This was very helpful!!!

I too was looking for how to just swap 2 cells. :(

But how do you delete them all at once.

Thank you sir. I was high and you still helped me figure it out ~

Good info, but what if you open through Google Drive?

10min that I'm looking for a tuto for my team to understand the different options for the "Find and replace", your video has 30 views but it is exactly what I need, thanks !

2024 that line bold for spreadsheet is missing 😀

Great! thank you very much

That’s not deleting the cells that’s simply clearing the contents of the cells. The cells are still there.

This app is paid nowadays, if using Chat GPT's API. A real bummer. No wonder they have 4 stars now, and by the time of the video they had 4.7

I did this but getting an error?.

Three dots is called a kabab, or context, menu. Three lines is a hamburger menu

Thank you!

one thing i learned in another video is if you are using indirect functions for sheets that aren't created yet, add a *randbetween(1,1) formula so when you add it it will automatically update in google sheets. It doesn't update if the sheet hasn't been created yet.

Thanks! You saved me!

Thank you very much. 🙏

There is no longer the option to autocapitalize the I, or the first letter of a sentence. It's only happened in the last couple of days for me in the UK. Why would they stop doing this? So silly.

Clear and direct!!👏

You are freaking amazing brother I love you so much for this video. I've been stuck for over an hour trying to figure this out. You are a life saver.

This kind of garbage is one of the reasons why we need dislike count!

I dont find that on my preference

niiiice thank you so much

Thank you.

Doesn't work for me. The auto cap is already checked but it does not capitalize new sentences.