Hey friends!
I’m Tasia and this video will highlight the best Google Sheets keyboard shortcuts
for both Mac and PC.
I work in Google Sheets a lot and having time-saving keyboard shortcuts are a must.
There are a TON of shortcuts, so efficiency in this video is top priority.
Here we go!
I work off a Mac, but I’m going to provide you shortcuts for Mac and PC in tandem.
So I’ll start with what the shortcut is on a Mac and then immediately follow it up
with what the shortcut looks like if you’re on a PC...because most are very similar and
some are even the exact same.
So let’s start with how to select an entire column at once.
This is the same on both Mac and PC.
All you have to do is hit Crtl+Spacebar.
You can also achieve this with a single mouse click at the top of the column as well.
To select an entire row, select Shift+Spacebar, on either a Mac or PC.
You can also click the row number to select the entire thing too.
To select all fields, select Command+A on a Mac or Ctrl+A on a PC.
So we all know that Command+Z on a Mac or Ctrl+Z on a PC will undo an action, but if
you go too far and you want to redo an action, just select Command+Y on a Mac or Ctrl+Y on
a PC.
And keep in mind, if you like my videos, hit that subscribe button to tell YouTube you
like my content.
So this next one is probably one of my favorite shortcuts for any document I’m working on,
and that's pressing Command+F to find a word or phrase.
This is, of course, Ctrl+F on a PC.
In this little pop-up box here, you just type in the word you’re searching for and all
uses of the word will be highlighted for you.
Hot Tip: this actually works anywhere, so in Docs, or if you’re on the web and reading
an article online and you want to find a specific spot, you can use your shortcut for that too.
So this next one is one that’s very helpful and I actually use it a lot on Google Docs
when I’m writing scripts, but it applies to Sheets just the same.
And that’s to select Command+Shift+H in order to find and replace a word or phrase.
On a PC, it’s just Ctrl+H. You’ll have a little popup box appear where you can enter
the word you want to find and what you want to replace it with.
I do some video work for a financial client and there are certain things compliance won’t
allow, so that’s a really handy shortcut if I need to quickly fix a script I’m working
on.
Now let’s talk about quickly aligning values in your cells.
To center a value, select Command+Shift+E on a Mac or Ctrl+Shift+E on a PC.
To align the value to the left, select Command+Shift+L on a Mac or Ctrl+Shift+L on a PC.
To align the value to the right, select Command+Shift+R on a Mac or Ctrl+shift+R on a PC.
If you need to clear the formatting of a cell, select Command+\ on a Mac or Ctrl+\ on a PC.
Now let’s learn how to quickly insert rows and columns into your Sheet.
These are other ones I’m constantly using.
To insert a row above your current row, make sure your row is selected and you can use
the shortcut you just learned or click to select the row, then select Command+Option+Equals
on a Mac or press Ctrl+Alt+Shift+Equals on a PC.
To insert rows below the current row, again make sure it’s selected, and press Ctrl+Option+i+B
on a Mac or Alt+i+W if using the Chrome browser or Alt+Shift+i+W on a different browser for
PC.
To insert a column to the left of your current column, make sure your column is selected,
and press Command+Option+Equals on a Mac or Ctrl+Alt+Shift+Equals on a PC.
To insert a column to the right of your current column, make sure your column is selected,
press Ctrl+Option+i+O on a Mac or for a PC, Alt+i+O if using Chrome or Alt+Shift+i+O if
using another browser.
Now to delete an entire row or column, select the entire row or column and press Command+Option+Minus
on Mac or Ctrl+Alt+Minus on a PC.
Lastly, if you can’t remember all of these, just remember this one.
Command+/ on a Mac and Ctrl+/ on a PC will bring up all available shortcuts for you.
There are so many, it’s mind-blowing.
I’ve added a ton of links in the description below on other videos I’ve done that feature
some handy shortcuts for Mac, iPad, and Google Calendar, so be sure to check those out.
So those are just a few of the best Google Sheets keyboard shortcuts.
Now I want to hear from you.
What is your most-used shortcut?
Let everyone know in the comments below.
As always, if you liked this video, I want to know so give it a like, a share, or leave
a comment below.
You can click right about here to subscribe to my channel and right about here and here
for even more content.
Thanks for watching and see ya next time.