Office Address

123/A, Miranda City Likaoli Prikano, Dope

Phone Number

8716808360

87168 08360

Email Address

info@example.com

example.mail@hum.com

October 27, 2023 0 Comments

Google Sheet Shortcut Keys

Google Sheet Shortcut Keys For Window And Mac

In today’s fast-paced world, time is of the essence. Every second saved counts towards productivity and success. One tool that has revolutionised the way we handle data and spreadsheets is Google Sheets. To make the most of this powerful tool, it’s essential to familiarize yourself with its shortcut keys. In this guide brought to you by SMART ITBOX, we’ll delve into the essential Google Sheet shortcut keys that can significantly enhance your efficiency and effectiveness. In this article, I have listed 100+ Google Sheets Shortcuts that will save you a lot of time.

Enabling Compatible Shortcuts in Google Sheets

To ensure you have access to all of these shortcuts, there is something you need to do before I lead you to the shortcuts. Since Google Sheets is an online tool, you will need to enable many of the keyboard shortcuts that are accessible in other spreadsheet programs, including Microsoft Excel. Below are the steps to enable compatible shortcuts in Google Sheets:
  1. Click the Help option in the menu
Google Sheet Shortcut key
How to enable compatible spreadsheet shortcuts in Google Sheets
2. Click on Keyboard shortcuts
Google Sheet Shortcut Keys
Google Sheet Shortcut Keys
3. At the bottom of the pop-up window, toggle “Enable compatible spreadsheet shortcuts” on

Google Sheet Shortcut keys for Navigation

Google Sheets shortcut keys for navigation allow users to swiftly move around their spreadsheet, saving valuable time. Some essential navigation shortcuts include:
Edit
Google Sheet Shortcut Keys For General Window Mac
Undo Ctrl + z ⌘ + Z
Redo Ctrl + Y ⌘ + y
Repeat the last action F4 F4
Insert/edit notes (comments) Shift + F2 Shift + F2
Find within the sheet Ctrl + F ⌘ + F
Opens the find and replace dialogue box Ctrl + H ⌘ + H
Save (every change is automatically saved in the drive) Ctrl + S ⌘ + S
Open a file Ctrl + O ⌘ + O
Print Ctrl + P ⌘ + P
Show the common keyboard shortcuts Ctrl + / ⌘ + /
Compact controls Ctrl + Shift + F ⌘ + Shift + F
Open a hyperlink (when the cell with a link is selected) Alt + Enter Option + Enter
Enable the screen reader support Ctrl+ Alt + Z ⌘+ Option + Z
By utilizing these shortcuts, users can efficiently navigate through their Google Sheets, ultimately enhancing their productivity.

Google Sheet Shortcut keys For Copy/Cut/Paste

The content likely discusses Google Sheet Shortcut Keys for Cut, Copy, and Paste functions in spreadsheet. These shortcuts are essential for efficient data manipulation and organization within the spreadsheet application
Edit
Google Sheet Shortcut Keys For Cut/Copy/Paste Window Mac
Copy the selected cells Ctrl +C ⌘+ C
Cut the selected cells Ctrl + X ⌘+ X
Paste the content of the selected cells Ctrl + V ⌘+ V
Paste the values only Ctrl + Shift + V ⌘+ Shift + V
Google Sheet Shortcut keys For General
Mastering the art of productivity in Google Sheets is now at your fingertips with SMART ITBOX. Discover a set of essential Google Sheet shortcut keys for general tasks. Save time and streamline your workflow with these efficient commands. Increase your proficiency in navigating, editing, and managing your spreadsheets like a pro.
Edit
Google Sheet Shortcut Keys For General Window Mac
Undo Ctrl + z ⌘ + Z
Redo Ctrl + Y ⌘ + y
Repeat the last action F4 F4
Insert/edit notes (comments) Shift + F2 Shift + F2
Find within the sheet Ctrl + F ⌘ + F
Opens the find and replace dialogue box Ctrl + H ⌘ + H
Save (every change is automatically saved in the drive) Ctrl + S ⌘ + S
Open a file Ctrl + O ⌘ + O
Print Ctrl + P ⌘ + P
Show the common keyboard shortcuts Ctrl + / ⌘ + /
Compact controls Ctrl + Shift + F ⌘ + Shift + F
Open a hyperlink (when the cell with a link is selected) Alt + Enter Option + Enter
Enable the screen reader support Ctrl+ Alt + Z ⌘+ Option + Z

Google Sheet Shortcut Keys – Selection

Unlock the power of precise data selection in Google Sheet. Explore a range of Google Sheet shortcut keys for seamless cell and data range selection. Whether it’s entire columns, rows, or non-adjacent cells, our expertly crafted shortcuts empower you to effortlessly manage your spreadsheets with precision and efficiency. Elevate your Google Sheets experience with selection shortcuts.
Edit
Shortcut Keys Window Mac
Select column Ctrl + Space ⌘ + Space
Select row Shift + Space Shift + Space
Select all Ctrl + A ⌘ + A
Google Sheet Shortcut Keys For Data Entry
Find a carefully selected list of keyboard shortcut for Google Sheets designed to facilitate quick and effective data entry. These knowledgeable shortcuts guarantee that you work more efficiently, not more laboriously, when browsing cells and entering formulas and numbers. 
Edit
Shortcuts Key For Data Entry Window Mac
Complete the data entry and move to the cell below Enter Enter
Completes the data entry and moves to the cell above Shift + Enter Shift + Enter
Insert a new line in the same cell Alt + Enter Option + Enter
Complete the data entry and move to the cell on the right Tab Tab
Completes the data entry and moves to the cell on the left Shift + Tab Shift + Tab
Open the edit mode F2 F2
Fill all the selected cells Ctrl + Enter ⌘ + Enter
Copy the content of the selected cell in the cell below (all cells should be selected) Ctrl + D ⌘ + D
Copy the content of the selected cell in the cell to the right (all cells should be selected) Ctrl + R ⌘ + R
Move one character to the left (when in cell edit mode) Left arrow Left arrow
Move one character to the right (when in cell edit mode) Right arrow Right arrow
Select all the content to the left of the cursor Shift + Page Up Shift + Page Up
Select all content to the right of the cursor Shift + Page Down Shift + Page Down
Move to the end of the cell content (when in cell edit mode) Ctrl + End ⌘ + End
Move to the beginning of the cell content (when in cell edit mode) Ctrl + Home ⌘ + Home

Google Sheets Insert Shortcuts For Window Mac

Edit
Google Sheet Shortcut Keys For Insert Window Mac
Insert a new sheet Shift + F11 Shift + Fn + F11
Insert a hyperlink Ctrl + k ⌘ + k
Insert the current time Ctrl + Shift + ; ⌘ + Shift + ;
Insert the current date Ctrl + ; ⌘ + ;
Insert the row above (in Google Chrome) Alt + I + R Option + I + R
Insert the row above (in other browsers) Alt + Shift + I + R Option + Shift + I + R
Insert the row below (in Google Chrome) Alt + I + W Option + I + W
Insert the row below (in other browsers) Alt + Shift + I + w Option + Shift + I + W
Insert a column to the left (in Google Chrome) Alt + I + C Option + I + C
Insert a column to the left (in other browsers) Alt + Shift + I + C Option + Shift + I + C
Insert a column to the right (in Google Chrome) Alt + I + G Option + I + G
Insert a column to the right (in other browsers) Alt + Shift + I + G Option + Shift + I + G
Google Sheet Shortcut Keys for Formatting
Edit
Keyboard Shortcuts for Google Sheets – Formatting Window Mac
Bold the contents of the selected cell Ctrl + B ⌘ + B
Underline the contents of the selected cell Ctrl + U ⌘ + U
Italicize the contents of the selected cell Ctrl + I ⌘ + I
Apply the strikethrough format Alt + Shift + 5 Option + Shift + 5
Align the cell contents to the center Ctrl + Shift + E ⌘+ Shift + E
Align the cell contents to the left Ctrl + Shift + L ⌘+ Shift + L
Align the cell contents to the right Ctrl + Shift + R ⌘+ Shift + R
Apply a top border to the selected cells Alt + Shift + 1 Option + Shift + 1
Apply the right border to the selected cells Alt + Shift + 2 Option + Shift + 2
Apply the bottom border to the selected cells Alt + Shift + 3 Option + Shift + 3
Apply a left border to the selected cells Alt + Shift + 4 Option + Shift + 4
Remove the borders from the selected cells Alt + Shift + 5 Option + Shift + 5
Apply the outer border to the selected cells Alt + Shift + 6 Option + Shift + 6
Apply the decimal format Ctrl + Shift + 1 ⌘+ Shift + 1
Apply the time format Ctrl + Shift + 2 ⌘+ Shift + 2
Apply the date format Ctrl + Shift + 3 ⌘+ Shift + 3
Apply the currency format Ctrl + Shift + 4 ⌘+ Shift + 4
Apply the percentage format Ctrl + Shift + 5 ⌘+ Shift + 5
Apply the exponential format Ctrl + Shift + 6 ⌘+ Shift + 6
Clear all formatting Ctrl + ⌘+

Google Sheet Shortcut Keys For Menu

Edit
Google Sheets Keyboard Shortcuts For Menu Window Mac
Open the file menu (in Google Chrome) Alt + F Option + F
Open the edit menu (in Google Chrome) Alt + E Option + E
Open the view menu (in Google Chrome) Alt + V Option + V
Open the insert menu (in Google Chrome) Alt + I Option + I
Open the format menu (in Google Chrome) Alt + O Option + O
Open the data menu (in Google Chrome) Alt + D Option + D
Open the tools menu (in Google Chrome) Alt + T Option + T
Open the add-ons menu Alt + N Option + N
Help menu (in Google Chrome) Alt + H Option + H
Sheet menu (copy, delete, and other sheet actions) Alt +Shift + S Option + Shift + S
Context menu Ctrl + Shift + Option + Shift +
If You Want Google sheets Automate ,WhatsApp Marketing And Digital marketing Service Please say Hi +91-7011892984 on WhatsApp.
Share:

Post Comments