Lots of useful tips here! one of my favorites is ctrl+\ to clear all formatting (background color, bolding, etc). cheers!
@ProlificOaktree3 сағат бұрын
Cheers! Google Sheets forever!!!
@fernandopaiva852 жыл бұрын
This is GOLD. Thank you so much for sharing!
@MegaArti20003 жыл бұрын
Nice concept of video!!! It looks much more like someone giving you USEFUL tips than just a regular tutorial. Thanks a lot!
@ProlificOaktree3 жыл бұрын
Thanks for the nice complement. I hope it helps you to work faster!
@hozefadaruwala3527 Жыл бұрын
Respected Sir, I am from India, and your video is very useful in my work. Thank You.
@MrMuhamad1994Ай бұрын
Amazing exactly what I needed thank you!
@ProlificOaktree12 күн бұрын
Glad it helped!
@NicolasMajdalani-c7u6 ай бұрын
The F4 key was just what I needed. thank you so much !!!!!!
@ProlificOaktree6 ай бұрын
Glad I could help!
@zummliller3 жыл бұрын
Thank you. Best Sheets stuff anywhere!
@ProlificOaktree3 жыл бұрын
Whoa, I love it! Thanks.
@CassietheK Жыл бұрын
This was sooooooooooooo helpful!!! Best tutorial video I've watched in a LONG time. Thank you!
@ProlificOaktree Жыл бұрын
Glad you liked it. I had a fun time making this one.
@pyran25972 жыл бұрын
Thank you. I had so much I needed to do to my data, you really cut down on a lot of it
@ProlificOaktree2 жыл бұрын
Glad it helped
@davidpang325 Жыл бұрын
Ooo nice! Very helpful. Any tips on doing trace precedents?
@ProlificOaktree Жыл бұрын
No, that's more of an Excel thing.
@proyectodereciclaje156610 ай бұрын
That was awesome
@ProlificOaktree10 ай бұрын
🔥
@rafaelmartineztomas49112 жыл бұрын
Thanks for the video . Wish there was vim shortcuts for Google Sheets
@ProlificOaktree2 жыл бұрын
I love this idea...but yeah, not a thing!
@harryfloyd23202 жыл бұрын
The link to the sheet is for the cleaned version. Do you have a link for the uncleaned copy as well? Might be useful to include in the description. Great video!
@ProlificOaktree2 жыл бұрын
Good. I restored an earlier version of the spreadsheet that's not as clean.
@910371922 жыл бұрын
Thanks!
@ProlificOaktree2 жыл бұрын
Oh wow! First Super Thanks ever. I just noticed it now. Thank you so much and happy spreadsheeting to you.
@RobPitzel Жыл бұрын
Hi - How do i jump to a Cell that is the reference in Excel it is CTRL + [ Thanks!!
@icesummer388 Жыл бұрын
any topics for filters shortcuts? i am used to in excel for the ALtDFF clearing the filers without removing the filter itself. But somehow this doesnt work in gsheet
@yankos_ Жыл бұрын
Legend!!!!
@MahmoudMonglish Жыл бұрын
Do you know how can i merge cells by using Keyboard Shortcuts
@zuidygeneral22 күн бұрын
How do I move through the sheet numbers. At the bottom
@ProlificOaktree12 күн бұрын
alt down arrow, ctl up arrow
@mexid25696 ай бұрын
Wow! 🎉
@ProlificOaktree6 ай бұрын
Whoot whoop
@CesarMartinez-wx3mi2 жыл бұрын
somehow i have disabled the ctrl+arrow up/down, how do i enable it?
@nohandle4742 жыл бұрын
Omg how do I add a column to the left or right that is BLANK please. It always adds a column that copies whats in the left or right column! So say the left column includes drop downs, if I click add column the right it copies the left one and includes the drop downs! 2 thinks, I don't know how to simply remove or delete the column data including drop downs. And I don't know how to add multiple columns at ones 😭 please helpppp
@conradkotze4615 Жыл бұрын
@ProlificOaktee How do you select ex, only columns B and D with only one hand?
@ProlificOaktree Жыл бұрын
Hmm, I really don't know. Good question!
@mircokampfer4512 жыл бұрын
how can I delete a row on Mac? Thanks
@ProlificOaktree2 жыл бұрын
I'd like to look at my keyboard and tell you, but I don't have a Mac! I think it'd cost a fortune to buy one that can do solid 4K editing like I do with this sub $1,000 Windows box. Sorry, a bit of a sideways non-answer for you.
@DankAudioStash242 жыл бұрын
Cmd+Alt+-(minus) opens the delete menu from any cell and you can select delete row or column using the arrow keys from there. Easiest way I've found so far.