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!
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
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
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.
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.
![Diggy Graves - Red Vineyard [Official Lyric Video]](http://i.ytimg.com/vi/8Ro085T0mnQ/mqdefault.jpg)
Lots of useful tips here! one of my favorites is ctrl+\ to clear all formatting (background color, bolding, etc). cheers!
Cheers! Google Sheets forever!!!
This is GOLD. Thank you so much for sharing!
Nice concept of video!!! It looks much more like someone giving you USEFUL tips than just a regular tutorial.
Thanks a lot!
Thanks for the nice complement. I hope it helps you to work faster!
Respected Sir,
I am from India, and your video is very useful in my work.
Thank You.
Amazing exactly what I needed thank you!
Glad it helped!
The F4 key was just what I needed. thank you so much !!!!!!
Glad I could help!
Thank you. Best Sheets stuff anywhere!
Whoa, I love it! Thanks.
This was sooooooooooooo helpful!!! Best tutorial video I've watched in a LONG time. Thank you!
Glad you liked it. I had a fun time making this one.
Thank you. I had so much I needed to do to my data, you really cut down on a lot of it
Glad it helped
Ooo nice! Very helpful. Any tips on doing trace precedents?
No, that's more of an Excel thing.
That was awesome
🔥
Thanks for the video . Wish there was vim shortcuts for Google Sheets
I love this idea...but yeah, not a thing!
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!
Good. I restored an earlier version of the spreadsheet that's not as clean.
Thanks!
Oh wow! First Super Thanks ever. I just noticed it now. Thank you so much and happy spreadsheeting to you.
Hi - How do i jump to a Cell that is the reference in Excel it is CTRL + [ Thanks!!
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
Legend!!!!
Do you know how can i merge cells by using Keyboard Shortcuts
How do I move through the sheet numbers.
At the bottom
alt down arrow, ctl up arrow
Wow! 🎉
Whoot whoop
somehow i have disabled the ctrl+arrow up/down, how do i enable it?
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
@ProlificOaktee
How do you select ex, only columns B and D with only one hand?
Hmm, I really don't know. Good question!
how can I delete a row on Mac? Thanks
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.
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.
Ctrl + / and close again the shortcuts menu