Google Sheets - Keyboard Shortcuts for Speed

Рет қаралды 37,644

Күн бұрын

Learn core keyboard shortcuts to use right away in your spreadsheets. Forget learning the giant list of obscure key combinations and use these half a dozen principles to get through your work faster.
🔗 Link to the Sheet: bit.ly/sheets-shortcuts
🕒 Timestamps:
0:00 Intro
0:38 Moving around
4:26 Formulas
6:22 Minimize repetition
9:50 Use menus
Learn more from Prolific Oaktree:
🌳 Next Video - Pivot Tables in Sheets vs. Excel - • Pivot Tables | Google ...
🌳 Related Playlist - Google Apps | Full Tutorials - bit.ly/google-tutorials
#googlesheets #shortcuts #spreadsheet

Пікірлер: 36

@fernandopaiva85 2 жыл бұрын

This is GOLD. Thank you so much for sharing!

@MegaArti2000 3 жыл бұрын

Nice concept of video!!! It looks much more like someone giving you USEFUL tips than just a regular tutorial. Thanks a lot!

@ProlificOaktree 3 жыл бұрын

Thanks for the nice complement. I hope it helps you to work faster!

@zummliller 3 жыл бұрын

Thank you. Best Sheets stuff anywhere!

@ProlificOaktree 3 жыл бұрын

Whoa, I love it! Thanks.

@jc4lyfable Жыл бұрын

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.

@hozefadaruwala3527 11 ай бұрын

Respected Sir, I am from India, and your video is very useful in my work. Thank You.

@pyran2597 2 жыл бұрын

Thank you. I had so much I needed to do to my data, you really cut down on a lot of it

@ProlificOaktree 2 жыл бұрын

Glad it helped

@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

@91037192 2 жыл бұрын

Thanks!

@ProlificOaktree 2 жыл бұрын

Oh wow! First Super Thanks ever. I just noticed it now. Thank you so much and happy spreadsheeting to you.

@user-vb1uj8wp5q 3 ай бұрын

The F4 key was just what I needed. thank you so much !!!!!!

@ProlificOaktree 3 ай бұрын

Glad I could help!

@user-lz1rf8iu5d Жыл бұрын

Hi - How do i jump to a Cell that is the reference in Excel it is CTRL + [ Thanks!!

@CesarMartinez-wx3mi Жыл бұрын

somehow i have disabled the ctrl+arrow up/down, how do i enable it?

@user-lc3tz2gf2c Жыл бұрын

Do you know how can i merge cells by using Keyboard Shortcuts

@yankos_ Жыл бұрын

Legend!!!!

@proyectodereciclaje1566 7 ай бұрын

That was awesome

@ProlificOaktree 7 ай бұрын

🔥

@nohandle474 Жыл бұрын

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

@mexid2569 3 ай бұрын

Wow! 🎉

@ProlificOaktree 3 ай бұрын

Whoot whoop

@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!

@rafaelmartineztomas4911 2 жыл бұрын

Thanks for the video . Wish there was vim shortcuts for Google Sheets

@ProlificOaktree 2 жыл бұрын

I love this idea...but yeah, not a thing!

@davidpang325 Жыл бұрын

Ooo nice! Very helpful. Any tips on doing trace precedents?

@ProlificOaktree Жыл бұрын

No, that's more of an Excel thing.

@harryfloyd2320 Жыл бұрын

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!

@ProlificOaktree Жыл бұрын

Good. I restored an earlier version of the spreadsheet that's not as clean.

@mircokampfer451 2 жыл бұрын

how can I delete a row on Mac? Thanks

@ProlificOaktree 2 жыл бұрын

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.

@DankAudioStash24 Жыл бұрын

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.