801-637-0818 support@wpfixall.com

Google Sheets Keyboard Shortcuts for Mac Customers

Uncategorized

Do you employ a Mac and paintings with Google Sheets? Spice up your productiveness with our detailed information to Google Sheets Mac keyboard shortcuts. Whether or not you’re coping with elementary navigation or intricate information dealing with, those shortcuts are a vital support for the ones aiming to optimize their workflow.

google sheets mac keyboard shortcutsgoogle sheets mac keyboard shortcuts

Google Sheets shortcuts for:

Not unusual Movements
Motion Shortcut
Choose column Ctrl + House
Choose row Shift + House
Choose all ⌘ + a, ⌘ + Shift + House
Undo ⌘ + z
Redo ⌘ + y, ⌘ + Shift + z, Fn + f4
To find ⌘ + f
To find and substitute ⌘ + Shift + h
Fill vary ⌘ + Input
Fill down ⌘ + d
Fill proper ⌘ + r
Save (each alternate is stored robotically in Power) ⌘ + s
Open ⌘ + o
Print ⌘ + p
Replica ⌘ + c
Lower ⌘ + x
Paste ⌘ + v
Paste values handiest ⌘ + Shift + v
Display not unusual keyboard shortcuts ⌘ + /
Insert new sheet Shift + Fn + f11
Compact controls Ctrl + Shift + f
Enter gear on/off (to be had in non-Latin languages) ⌘ + Shift + okay
Choose enter gear ⌘ + Possibility + Shift + okay
Instrument finder (previously Seek the menus) Possibility + /
Choose present area round decided on cellular ⌘ + Shift + *, Ctrl + Shift + *
Presentations or hides the menus ⌘ + Possibility + r, Ctrl + Shift + f
Layout Cells
Motion Shortcut 1 Shortcut 2 Shortcut 3
Daring ⌘ + b ⌘ + 2 Ctrl + 2
Underline ⌘ + u ⌘ + 4 Ctrl + 4
Italic ⌘ + i ⌘ + 3 Ctrl + 3
Strikethrough ⌘ + Shift + x ⌘ + 5 Ctrl + 5
Heart align ⌘ + Shift + e    
Left align ⌘ + Shift + l    
Proper align ⌘ + Shift + r    
Practice best border Possibility + Shift + 1    
Practice proper border Possibility + Shift + 2    
Practice backside border Possibility + Shift + 3    
Practice left border Possibility + Shift + 4    
Take away borders Possibility + Shift + 6    
Practice outer border Possibility + Shift + 7 ⌘ + Shift + 7 Ctrl + Shift + 7
Insert hyperlink ⌘ + okay    
Insert time ⌘ + Shift + ;    
Insert date ⌘ + ;    
Insert date and time ⌘ + Possibility + Shift + ;    
Layout as decimal Ctrl + Shift + 1    
Layout as time Ctrl + Shift + 2    
Layout as date Ctrl + Shift + 3    
Layout as forex Ctrl + Shift + 4    
Layout as share Ctrl + Shift + 5    
Layout as exponent Ctrl + Shift + 6    
Transparent formatting ⌘ +  
Navigate the Spreadsheet
Edit Notes and Feedback
Motion Macbook
Insert/edit be aware Shift + f2
Insert/edit remark ⌘ + Possibility + m
Open remark dialogue thread ⌘ + Possibility + Shift + a
Input present remark dangle Ctrl + ⌘, press e then c
Transfer to subsequent remark dangle Ctrl + ⌘, press n then c
Transfer to earlier remark dangle Ctrl + ⌘, press p then c
Use Keyboard Shortcuts on Decided on Feedback
Motion Macbook
Respond to present remark R
Transfer to subsequent remark J
Transfer to earlier remark Ok
Unravel present remark E
Go out present remark U
Open a Menu
Open Document menu Ctrl + Possibility + f
Open Edit menu Ctrl + Possibility + e
Open View menu Ctrl + Possibility + v
Open Insert menu Ctrl + Possibility + i
Open Layout menu Ctrl + Possibility + o
Open Information menu Ctrl + Possibility + d
Open Gear menu Ctrl + Possibility + t
Open insert menu (with cells decided on) ⌘ + Possibility + =
Open delete menu (with cells decided on) ⌘ + Possibility + –
Open Shape menu (when hooked up to a kind) Ctrl + Possibility + m
Open Upload-ons menu Ctrl + Possibility + n
Open Assist menu Ctrl + Possibility + h
Open Accessibility menu (display reader make stronger) Ctrl + Possibility + a
Open Sheet menu (reproduction, delete, different sheet movements) Possibility + Shift + s
Open Context menu ⌘ + Shift + or Shift + f10
Upload or Trade Rows and Columns
Motion Shortcut
Insert rows above ⌘ + Possibility + = (with rows decided on)
Insert rows under  
Insert columns to the left ⌘ + Possibility + = (with columns decided on)
Insert columns to the correct  
Delete rows ⌘ + Possibility + – (with rows decided on)
Delete columns ⌘ + Possibility + – (with columns decided on)
Cover row ⌘ + Possibility + 9
Unhide row ⌘ + Shift + 9
Cover column ⌘ + Possibility + 0
Unhide column ⌘ + Shift + 0
Crew rows or columns Possibility + Shift + proper Arrow
Ungroup rows or columns Possibility + Shift + left Arrow
Make bigger grouped rows or columns Possibility + Shift + down Arrow
Cave in grouped rows or columns Possibility + Shift + up Arrow
Use Formulation
Motion Shortcut
Display all formulation Ctrl + ~
Insert array system ⌘ + Shift + Input
Cave in an expanded array system ⌘ + e
Display/cover system lend a hand (when getting into a system) Shift + Fn + f1
Complete/compact system lend a hand (when getting into a system) Fn + f1
Absolute/relative references (when getting into a system) Fn + f4
Toggle system end result previews (when getting into a system) Fn + f9
Resize system bar (transfer up or down) Ctrl + Possibility + up and Ctrl + Possibility + down
Toggle system vary variety (when getting into a system) F2, Ctrl + e
Assist for Display Readers
Motion Shortcut
Activate display reader make stronger ⌘ + Possibility + z
Be told extra about the usage of Google Sheets with a display reader ⌘ + Possibility + z
Allow braille make stronger ⌘ + Possibility + h
Learn column ⌘ + Possibility + Shift + c
Learn row ⌘ + Possibility + Shift + r

The put up Google Sheets Keyboard Shortcuts for Mac Customers gave the impression first on Hongkiat.

WordPress Website Development Source: https://www.hongkiat.com/blog/google-sheets-mac-shortcuts/

[ continue ]

Submit a Comment