UPDATES

Google Sheets Keyboard Shortcuts for Mac Customers







Google Sheets Keyboard Shortcuts for Mac Customers – Hongkiat





















Please allow JavaScript in your browser to take pleasure in a greater expertise.

Do you utilize a Mac and work with Google Sheets? Enhance your productiveness with our detailed information to Google Sheets Mac keyboard shortcuts. Whether or not you’re coping with primary navigation or intricate knowledge dealing with, these shortcuts are a major support for these aiming to optimize their workflow.

google sheets mac keyboard shortcuts

Google Sheets shortcuts for:

Frequent Actions
Motion Shortcut
Choose column Ctrl + House
Choose row Shift + House
Choose all + a, + Shift + House
Undo + z
Redo + y, + Shift + z, Fn + f4
Discover + f
Discover and change + Shift + h
Fill vary + Enter
Fill down + d
Fill proper + r
Save (each change is saved routinely in Drive) + s
Open + o
Print + p
Copy + c
Minimize + x
Paste + v
Paste values solely + Shift + v
Present widespread keyboard shortcuts + /
Insert new sheet Shift + Fn + f11
Compact controls Ctrl + Shift + f
Enter instruments on/off (accessible in non-Latin languages) + Shift + okay
Choose enter instruments + Choice + Shift + okay
Software finder (previously Search the menus) Choice + /
Choose present area round chosen cell + Shift + *, Ctrl + Shift + *
Shows or hides the menus + Choice + r, Ctrl + Shift + f
Format 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
Middle align + Shift + e    
Left align + Shift + l    
Proper align + Shift + r    
Apply prime border Choice + Shift + 1    
Apply proper border Choice + Shift + 2    
Apply backside border Choice + Shift + 3    
Apply left border Choice + Shift + 4    
Take away borders Choice + Shift + 6    
Apply outer border Choice + Shift + 7 + Shift + 7 Ctrl + Shift + 7
Insert hyperlink + okay    
Insert time + Shift + ;    
Insert date + ;    
Insert date and time + Choice + Shift + ;    
Format as decimal Ctrl + Shift + 1    
Format as time Ctrl + Shift + 2    
Format as date Ctrl + Shift + 3    
Format as forex Ctrl + Shift + 4    
Format as proportion Ctrl + Shift + 5    
Format as exponent Ctrl + Shift + 6    
Clear formatting +  
Navigate the Spreadsheet
Edit Notes and Feedback
Use Keyboard Shortcuts on Chosen Feedback
Open a Menu
Add or Change Rows and Columns
Motion Shortcut
Insert rows above + Choice + = (with rows chosen)
Insert rows beneath  
Insert columns to the left + Choice + = (with columns chosen)
Insert columns to the suitable  
Delete rows + Choice + (with rows chosen)
Delete columns + Choice + (with columns chosen)
Disguise row + Choice + 9
Unhide row + Shift + 9
Disguise column + Choice + 0
Unhide column + Shift + 0
Group rows or columns Choice + Shift + proper Arrow
Ungroup rows or columns Choice + Shift + left Arrow
Broaden grouped rows or columns Choice + Shift + down Arrow
Collapse grouped rows or columns Choice + Shift + up Arrow
Use Formulation
Motion Shortcut
Present all formulation Ctrl + ~
Insert array system + Shift + Enter
Collapse an expanded array system + e
Present/conceal system assist (when getting into a system) Shift + Fn + f1
Full/compact system assist (when getting into a system) Fn + f1
Absolute/relative references (when getting into a system) Fn + f4
Toggle system outcome previews (when getting into a system) Fn + f9
Resize system bar (transfer up or down) Ctrl + Choice + up and Ctrl + Choice + down
Toggle system vary choice (when getting into a system) F2, Ctrl + e
Assist for Display screen Readers
Motion Shortcut
Activate display screen reader help + Choice + z
Be taught extra about utilizing Google Sheets with a display screen reader + Choice + z
Allow braille help + Choice + h
Learn column + Choice + Shift + c
Learn row + Choice + Shift + r


Web siteFbTwitterInstagramPinterestLinkedInGoogle+YoutubeRedditDribbbleBehanceGithubCodePenWhatsappE mail

One thought on “Google Sheets Keyboard Shortcuts for Mac Customers

Leave a Reply

Your email address will not be published. Required fields are marked *