Clicky

44 Google Sheets Shortcuts You Must Know

44 Google Sheets Shortcuts You Must Know

Whether you’re a beginner in Google Sheets or a long-time user, getting the hang of using keyboard shortcuts can be quite challenging. However, making it a habit is sure to improve your productivity and reduce the time it takes for you to complete certain tasks. If you don’t find the shortcut you want below you can ask the FileDrop Bot for help.

In this guide, we’ll cover Google Sheets shortcuts you should be using on a regular basis. Mastering these shortcuts will surely reduce the time you spend getting lost trying to find buttons so you can spend your workday doing fruitful labor efficiently.

Don’t worry, this guide works great for both Mac and Windows PC users!

black computer keyboard on orange table

Basic Google Sheets Keyboard Shortcuts

Before we proceed to the more advanced shortcuts, let’s make sure we know the basics first!

  1. Common Actions

These are the most basic shortcuts everyone should be using including Undo, Redo, Select all, Print, etc.

ActionMacWindows PC
UndoCmd+ZCtrl+Z
RedoCmd+Shift+Z
or Cmd+Y
Ctrl+Shift+Z
or Ctrl+Y
Select allCmd+ACtrl+A
Open another fileCmd+OCtrl+O
Show all keyboard shortcuts in-appCmd+/Ctrl+/
Show or hide formulasCtrl+~Ctrl+~
Insert new sheetShift+Fn+F11Shift+F11
Search the menusOption+/Alt+/
  1. Copy, Cut, and Paste 

    There’s more than just the vanilla copy and paste.
    Paste Values Only omits the source’s formatting and allows you to follow the destination’s formatting upon Paste.
    Paste Formatting Only applies the source’s formatting to the destination.

ActionMacWindows PC
CopyCmd+CCtrl+C
CutCmd+XCtrl+X
PasteCmd+VCtrl+V
Paste Values OnlyCmd+Shift+VCtrl+ShiftV
Paste Formatting OnlyCmd+Option+VCtrl+Shift+V
  1. Bold, Underline, Italic, Strikethrough

Format text like it’s your second nature.

ActionMacWindows PCExample
BoldCmd+BCtrl+BShortcut
UnderlineCmd+UCtrl+UShortcut
ItalicCmd+iCtrl+iShortcut
StrikethroughCmd+Shift+XAlt+Shift+5Shortcut
  1. Alignment

Never leave you’re sheets looking unprofessional with messed up and irregular alignments again.

ActionMacWindows PCExample
Align centerCmd+Shift+ECtrl+Shift+EKeyboard
Align leftCmd+Shift+LCtrl+Shift+LKeyboard
Align rightCmd+Shift+RCtrl+Shift+RKeyboard
  1. Hyperlink

Make your spreadsheet more interactive by adding links to it. You can even link to other docs and sheets! Just have your URL ready and don’t forget to edit the text if you need to.

ActionMacWindows PC
Add LinkCmd+KCtrl+K
Open LinkOption+KAlt+K

Bonus tip: Want to do more than just the standard linking? How about cloud file management for your sheets? Try FileDrop which allows you to efficiently attach files like PDFs, images, and anything within your Google Drive to cells while also keeping tabs on your uploads.

Download the add-on for free here and start your Pro membership to access premium features like File Library, batch file uploads, powerful Google Drive integration, and more productivity features for individuals and teams.

Advanced Google Sheets Shortcut Keys

We swear by this list of Google Sheets shortcuts. Go over this curated list to learn new shortcuts as well as the underlying features they activate.

  1. FormattingClear formatting

    is one of the most convenient shortcuts when revising your spreadsheets. It strips away a cell of its current text formatting such as bold, italic, text and fill colors, and alignment.

    You don’t have to jump into Format > Number each time you apply formatting as decimal, time, date, currency, percentage, or exponent. Use these shortcuts to apply the format you need to a cell.

See also  Exploring Various Ways to Visually Represent Data in Google Sheets

Note however that the number format will use the default formats. If you need a different currency, number, or time format, you should still configure that through Format > Number > Custom.

ActionMacWindows PCExample
Clear FormattingCmd+\Ctrl+\100
Format number as decimalCtrl+Shift+1Ctrl+Shift+1100.00
Format number as timeCtrl+Shift+2Ctrl+Shift+25:00 AM
Format number as dateCtrl+Shift+3Ctrl+Shift+312/25/2022
Format number as currencyCtrl+Shift+4Ctrl+Shift+4$100.00
Format number as percentageCtrl+Shift+5Ctrl+Shift+5100%
Format number as exponentCtrl+Shift+6Ctrl+Shift+61.25E+06
  1. Find and Replace

Find (Ctrl+F or Cmd+F) is one of the most useful universal shortcuts ever to be invented. It exists not only in Google Sheets but also your browser, email, calendar, and most of your work apps.

If you aren’t already using it in Google Sheets, it helps you navigate by just typing words, phrases, or numbers from a page and highlights the result while also letting you hop to every instance.

ActionMacWindows PC
FindCmd+FCtrl+F
Find and ReplaceCmd+Shift+HCtrl+H

Now that was just the basic part. Doing Find and Replace is a different kind of beast that many long-time Sheets users aren’t using more of.

google sheet shortcut keys pdf

Find and replace is a powerful feature that allows you to substitute what you input in Find with your input in the Replace with field. To give you ideas on use cases for this feature, here are some scenarios and examples.

  • Revise spelling.
    • Misspelled customer or company names in your CRM,
  • Revising your vocabulary or terminology of choice.
    • Purple to lavender; freelancer to contractor;
  • Changing words due to regional differences like these US English to UK English examples:
    • color to color; gas to petrol; sedan to saloon; tires to tyres.
  • Replace identifying numbers like SKUs, product numbers, serial numbers, or other codes.
    • Change hex codes, hashtags, phone numbers, even email addresses, URLs
  • Replace a brand or company name with a new, different, or more appropriate one.
    • Google to Alphabet; Facebook to Meta; Figma to Adobe, etc

The possibilities with Find and replace are boundless and will definitely make it easier for you when the time comes you’d have to revise your spreadsheets.

  1. Open revision/version history

Remember Ctrl+S or Cmd+S for saving your spreadsheet? Seasoned Google Sheets and Docs users have forgotten about that shortcut already because it’s not necessary unless you’re working offline. Google Sheets is automatically saved to your Drive when you’re connected to the internet.

However, always-saved sessions could also make you wonder — what if you make a mistake and you forgot to undo (Cmd+Z or Ctrl+z) all the way? Or what if you accidentally deleted entire sections of your previous spreadsheet in error? Well, everyone makes mistakes! Thankfully the version history library is here and it’s one of the most underappreciated features within Google Sheets.

See also  How to Troubleshoot Common Issues in Google Sheets

You can pull up the version history of your Sheets file and find all of the recorded edits made in the copy of your document. You’ll also see who made the edits, the timestamp, and which parts of the document were affected.

This shortcut can be a handful (four keys!) but mastering it and the underlying function can be very rewarding. Learn more about viewing Google Sheets file history in our in-depth article.

ActionMacWindows PC
See version historyOption+Alt+Shift+HCtrl+Alt+Shift+H

Note that to be able to see the version history, you must have at least Editor access for the file. Also, older and much bigger file histories could be merged occasionally by Google Sheets to save storage space which means the further back in time you go, the less granular the history may become.

  1. Insert Current Time or Date

There’s a shortcut for inserting the current time or date so you won’t have to type manually anymore.

For clarity, this shortcut uses the semicolon ( ; ) and a variety of other modifiers for both Mac and Windows.

ActionMacWindows PCExample
Insert current dateCmd+;Ctrl+;12/01/2022
Insert current timeCmd+Shift+;Ctrl+Shift+;12:00:00 PM
Insert current date and timeCmd+Shift+Option+;Ctrl+Shift+Alt+;12/01/2022 12:00:00 PM

Please note that the actual output on the rightmost column depends on your default spreadsheet settings. Your region may have a different date and time format which you can change by going to File > Settings.

google sheet shortcut keys pdf 1

  1. Notes and Comments

These are shortcuts relevant to collaborating with your team. You need at least Commenter access to leave comments and Editor access to insert or edit notes.

ActionMacWindows PC
Insert or edit noteShift+Fn+F2Shift+F2
Insert or edit commentCmd+Option+MCtrl+Alt+M
Open comment threadCmd+Option+Shift+ACtrl+Alt+Shift+A
Hide CommentCmd+Alt+Shift+NCtrl+Alt+Shift+N
Reply to current commentRR
Move to next commentJJ
Move to previous commentKK
Resolve current commentEE
Exit current commentUU

Conclusion on Google Sheets Shortcuts You Must Know

There are hundreds of shortcuts you could use and master on Google Sheets. These are just a few curated ones that we’d love for you to start using now.

Don’t forget to use Ctrl+/ or Command+/ to display all the shortcuts available to you when you forget what you’ve learned here so you can become more productive on your day-to-day spreadsheet tasks.

google sheet shortcut keys pdf 2


Use FileDrop to Do Even More on Google Sheets

FileDrop is an add-on for Google Sheets, Docs, and Drive that you can install for free here. It’s a potent tool that unlocks file management, optical character recognition, and tighter Google Drive integration without leaving Sheets or Docs.

FileDrop’s core features include:

  • Insert PDF, images, or other files in cells
  • Add files from Google Drive do your Docs
  • Upload files from computer or URLs
  • Manage the attached files using File Library
  • Automatic file linking
  • Import tables from PDF
  • Extract text from PDF or images using optical character recognition (OCR)
  • Translate the extracted text to another language
  • And more + new features via our regular updates!

Try our limited free forever plan or subscribe now and unlock the entire set of features. Read more at GetFileDrop.com.

🎉 Save $50 with the Pro Yearly Plan
This is default text for notification bar