Google Sheets Keyboard Shortcuts for Mac Customers

by | Aug 17, 2023 | Etcetera | 0 comments

Do you utilize a Mac and artwork with Google Sheets? Boost your productivity with our detailed data to Google Sheets Mac keyboard shortcuts. Whether or not or now not you’re dealing with fundamental navigation or intricate data coping with, the ones shortcuts are an important fortify for those aiming to optimize their workflow.

google sheets mac keyboard shortcutsgoogle sheets mac keyboard shortcuts

Google Sheets shortcuts for:

No longer abnormal Actions
Movement Shortcut
Select column Ctrl + Space
Select row Shift + Space
Select all + a, + Shift + Space
Undo + z
Redo + y, + Shift + z, Fn + f4
To seek out + f
To seek out and exchange + Shift + h
Fill range + Enter
Fill down + d
Fill correct + r
Save (every change is saved routinely in Energy) + s
Open + o
Print + p
Reproduction + c
Decrease + x
Paste + v
Paste values most effective + Shift + v
Show now not abnormal keyboard shortcuts + /
Insert new sheet Shift + Fn + f11
Compact controls Ctrl + Shift + f
Input equipment on/off (available in non-Latin languages) + Shift + ok
Select input equipment + Chance + Shift + ok
Tool finder (prior to now Search the menus) Chance + /
Select provide space spherical made up our minds on mobile + Shift + *, Ctrl + Shift + *
Shows or hides the menus + Chance + r, Ctrl + Shift + f
See also  How you can Setup WordPress E mail Logs (and WooCommerce E mail Logs)
Format Cells
Movement Shortcut 1 Shortcut 2 Shortcut 3
Bold + 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    
Right kind align + Shift + r    
Observe very best border Chance + Shift + 1    
Observe correct border Chance + Shift + 2    
Observe bottom border Chance + Shift + 3    
Observe left border Chance + Shift + 4    
Remove borders Chance + Shift + 6    
Observe outer border Chance + Shift + 7 + Shift + 7 Ctrl + Shift + 7
Insert link + ok    
Insert time + Shift + ;    
Insert date + ;    
Insert date and time + Chance + Shift + ;    
Format as decimal Ctrl + Shift + 1    
Format as time Ctrl + Shift + 2    
Format as date Ctrl + Shift + 3    
Format as foreign exchange Ctrl + Shift + 4    
Format as proportion Ctrl + Shift + 5    
Format as exponent Ctrl + Shift + 6    
Clear formatting +  
Navigate the Spreadsheet
See also  How To Upload Meta Containers and Customized Fields To Posts in Gutenberg
Edit Notes and Comments
Movement Macbook
Insert/edit bear in mind Shift + f2
Insert/edit statement + Chance + m
Open statement discussion thread + Chance + Shift + a
Enter provide statement hang Ctrl + , press e then c
Switch to next statement hang Ctrl + , press n then c
Switch to previous statement hang Ctrl + , press p then c
Use Keyboard Shortcuts on Made up our minds on Comments
Movement Macbook
Reply to provide statement R
Switch to next statement J
Switch to previous statement Good enough
Get to the bottom of provide statement E
Pass out provide statement U
Open a Menu
Open File menu Ctrl + Chance + f
Open Edit menu Ctrl + Chance + e
Open View menu Ctrl + Chance + v
Open Insert menu Ctrl + Chance + i
Open Format menu Ctrl + Chance + o
Open Knowledge menu Ctrl + Chance + d
Open Tools menu Ctrl + Chance + t
Open insert menu (with cells made up our minds on) + Chance + =
Open delete menu (with cells made up our minds on) + Chance +
Open Form menu (when hooked as much as a type) Ctrl + Chance + m
Open Add-ons menu Ctrl + Chance + n
Open Help menu Ctrl + Chance + h
Open Accessibility menu (show reader beef up) Ctrl + Chance + a
Open Sheet menu (replica, delete, other sheet actions) Chance + Shift + s
Open Context menu + Shift + or Shift + f10
Add or Business Rows and Columns
Movement Shortcut
Insert rows above + Chance + = (with rows made up our minds on)
Insert rows beneath  
Insert columns to the left + Chance + = (with columns made up our minds on)
Insert columns to the right kind  
Delete rows + Chance + (with rows made up our minds on)
Delete columns + Chance + (with columns made up our minds on)
Duvet row + Chance + 9
Unhide row + Shift + 9
Duvet column + Chance + 0
Unhide column + Shift + 0
Staff rows or columns Chance + Shift + correct Arrow
Ungroup rows or columns Chance + Shift + left Arrow
Make larger grouped rows or columns Chance + Shift + down Arrow
Collapse grouped rows or columns Chance + Shift + up Arrow
See also  Navigating the Yr-Finish Crunch: 15 Very important Assets for Startups to End Robust
Use System
Movement Shortcut
Show all components Ctrl + ~
Insert array machine + Shift + Enter
Collapse an expanded array machine + e
Show/quilt machine have the same opinion (when coming into a machine) Shift + Fn + f1
Whole/compact machine have the same opinion (when coming into a machine) Fn + f1
Absolute/relative references (when coming into a machine) Fn + f4
Toggle machine finish consequence previews (when coming into a machine) Fn + f9
Resize machine bar (switch up or down) Ctrl + Chance + up and Ctrl + Chance + down
Toggle machine range selection (when coming into a machine) F2, Ctrl + e
Help for Show Readers
Movement Shortcut
Turn on show reader beef up + Chance + z
Be informed additional about the use of Google Sheets with a show reader + Chance + z
Permit braille beef up + Chance + h
Be told column + Chance + Shift + c
Be told row + Chance + Shift + r

The submit Google Sheets Keyboard Shortcuts for Mac Customers appeared first on Hongkiat.

WordPress Website Development

Supply: https://www.hongkiat.com/blog/google-sheets-mac-shortcuts/

[ continue ]

WordPress Maintenance Plans | WordPress Hosting

read more

0 Comments

Submit a Comment

DON'T LET YOUR WEBSITE GET DESTROYED BY HACKERS!

Get your FREE copy of our Cyber Security for WordPress® whitepaper.

You'll also get exclusive access to discounts that are only found at the bottom of our WP CyberSec whitepaper.

You have Successfully Subscribed!