{"id":68609,"date":"2023-08-17T18:01:47","date_gmt":"2023-08-17T10:01:47","guid":{"rendered":"https:\/\/www.hongkiat.com\/blog\/?p=68609"},"modified":"2023-08-24T17:06:26","modified_gmt":"2023-08-24T09:06:26","slug":"google-sheets-mac-shortcuts","status":"publish","type":"post","link":"https:\/\/www.hongkiat.com\/blog\/google-sheets-mac-shortcuts\/","title":{"rendered":"Google Sheets Keyboard Shortcuts for Mac Users"},"content":{"rendered":"<p>Do you use a Mac and work with Google Sheets? Boost your productivity with our detailed guide to Google Sheets Mac keyboard shortcuts. Whether you\u2019re dealing with basic navigation or intricate data handling, these shortcuts are a significant aid for those aiming to optimize their workflow.<\/p>\n<figure><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/assets.hongkiat.com\/uploads\/google-sheets-mac-shortcuts\/google-sheets-keyboard-shortcuts.jpg\" alt=\"google sheets mac keyboard shortcuts\" width=\"1600\" height=\"900\"><\/figure>\n<p><strong>Google Sheets shortcuts for:<\/strong><\/p>\n<ul>\n<li><a href=\"#common_actions\">Common Actions<\/a><\/li>\n<li><a href=\"#format_cells\">Format Cells<\/a><\/li>\n<li><a href=\"#navigate_spreadsheets\">Navigate the Spreadsheet<\/a><\/li>\n<li><a href=\"#edit_notes_comments\">Edit Notes and Comments<\/a><\/li>\n<li><a href=\"#selected_comments\">Use Keyboard Shortcuts on Selected Comments<\/a><\/li>\n<li><a href=\"#open_menu\">Open a Menu<\/a><\/li>\n<li><a href=\"#add_change_rows_columns\">Add or Change Rows and Columns<\/a><\/li>\n<li><a href=\"#use_formulas\">Use Formulas<\/a><\/li>\n<li><a href=\"#help_screen_readers\">Help for Screen Readers<\/a><\/li>\n<\/ul>\n<hr>\n<h3>Common Actions<\/h3>\n<table id=\"common_actions\">\n<thead>\n<tr>\n<td>Action<\/td>\n<td>Shortcut<\/td>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>Select column<\/td>\n<td><span class=\"key\">Ctrl<\/span> + <span class=\"key\">Space<\/span><\/td>\n<\/tr>\n<tr>\n<td>Select row<\/td>\n<td><span class=\"key\">Shift<\/span> + <span class=\"key\">Space<\/span><\/td>\n<\/tr>\n<tr>\n<td>Select all<\/td>\n<td><span class=\"key\">\u2318<\/span> + <span class=\"key\">a<\/span>, <span class=\"key\">\u2318<\/span> + <span class=\"key\">Shift<\/span> + <span class=\"key\">Space<\/span><\/td>\n<\/tr>\n<tr>\n<td>Undo<\/td>\n<td><span class=\"key\">\u2318<\/span> + <span class=\"key\">z<\/span><\/td>\n<\/tr>\n<tr>\n<td>Redo<\/td>\n<td><span class=\"key\">\u2318<\/span> + <span class=\"key\">y<\/span>, <span class=\"key\">\u2318<\/span> + <span class=\"key\">Shift<\/span> + <span class=\"key\">z<\/span>, <span class=\"key\">Fn<\/span> + <span class=\"key\">f4<\/span><\/td>\n<\/tr>\n<tr>\n<td>Find<\/td>\n<td><span class=\"key\">\u2318<\/span> + <span class=\"key\">f<\/span><\/td>\n<\/tr>\n<tr>\n<td>Find and replace<\/td>\n<td><span class=\"key\">\u2318<\/span> + <span class=\"key\">Shift<\/span> + <span class=\"key\">h<\/span><\/td>\n<\/tr>\n<tr>\n<td>Fill range<\/td>\n<td><span class=\"key\">\u2318<\/span> + <span class=\"key\">Enter<\/span><\/td>\n<\/tr>\n<tr>\n<td>Fill down<\/td>\n<td><span class=\"key\">\u2318<\/span> + <span class=\"key\">d<\/span><\/td>\n<\/tr>\n<tr>\n<td>Fill right<\/td>\n<td><span class=\"key\">\u2318<\/span> + <span class=\"key\">r<\/span><\/td>\n<\/tr>\n<tr>\n<td>Save (every change is saved automatically in Drive)<\/td>\n<td><span class=\"key\">\u2318<\/span> + <span class=\"key\">s<\/span><\/td>\n<\/tr>\n<tr>\n<td>Open<\/td>\n<td><span class=\"key\">\u2318<\/span> + <span class=\"key\">o<\/span><\/td>\n<\/tr>\n<tr>\n<td>Print<\/td>\n<td><span class=\"key\">\u2318<\/span> + <span class=\"key\">p<\/span><\/td>\n<\/tr>\n<tr>\n<td>Copy<\/td>\n<td><span class=\"key\">\u2318<\/span> + <span class=\"key\">c<\/span><\/td>\n<\/tr>\n<tr>\n<td>Cut<\/td>\n<td><span class=\"key\">\u2318<\/span> + <span class=\"key\">x<\/span><\/td>\n<\/tr>\n<tr>\n<td>Paste<\/td>\n<td><span class=\"key\">\u2318<\/span> + <span class=\"key\">v<\/span><\/td>\n<\/tr>\n<tr>\n<td>Paste values only<\/td>\n<td><span class=\"key\">\u2318<\/span> + <span class=\"key\">Shift<\/span> + <span class=\"key\">v<\/span><\/td>\n<\/tr>\n<tr>\n<td>Show common keyboard shortcuts<\/td>\n<td><span class=\"key\">\u2318<\/span> + <span class=\"key\">\/<\/span><\/td>\n<\/tr>\n<tr>\n<td>Insert new sheet<\/td>\n<td><span class=\"key\">Shift<\/span> + <span class=\"key\">Fn<\/span> + <span class=\"key\">f11<\/span><\/td>\n<\/tr>\n<tr>\n<td>Compact controls<\/td>\n<td><span class=\"key\">Ctrl<\/span> + <span class=\"key\">Shift<\/span> + <span class=\"key\">f<\/span><\/td>\n<\/tr>\n<tr>\n<td>Input tools on\/off (available in non-Latin languages)<\/td>\n<td><span class=\"key\">\u2318<\/span> + <span class=\"key\">Shift<\/span> + <span class=\"key\">k<\/span><\/td>\n<\/tr>\n<tr>\n<td>Select input tools<\/td>\n<td><span class=\"key\">\u2318<\/span> + <span class=\"key\">Option<\/span> + <span class=\"key\">Shift<\/span> + <span class=\"key\">k<\/span><\/td>\n<\/tr>\n<tr>\n<td>Tool finder (formerly Search the menus)<\/td>\n<td><span class=\"key\">Option<\/span> + <span class=\"key\">\/<\/span><\/td>\n<\/tr>\n<tr>\n<td>Select current region around selected cell<\/td>\n<td><span class=\"key\">\u2318<\/span> + <span class=\"key\">Shift<\/span> + <span class=\"key\">*<\/span>, <span class=\"key\">Ctrl<\/span> + <span class=\"key\">Shift<\/span> + <span class=\"key\">*<\/span><\/td>\n<\/tr>\n<tr>\n<td>Displays or hides the menus<\/td>\n<td><span class=\"key\">\u2318<\/span> + <span class=\"key\">Option<\/span> + <span class=\"key\">r<\/span>, <span class=\"key\">Ctrl<\/span> + <span class=\"key\">Shift<\/span> + <span class=\"key\">f<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3>Format Cells<\/h3>\n<table id=\"format_cells\">\n<thead>\n<tr>\n<td>Action<\/td>\n<td>Shortcut 1<\/td>\n<td>Shortcut 2<\/td>\n<td>Shortcut 3<\/td>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>Bold<\/td>\n<td><span class=\"key\">\u2318<\/span> + <span class=\"key\">b<\/span><\/td>\n<td><span class=\"key\">\u2318<\/span> + <span class=\"key\">2<\/span><\/td>\n<td><span class=\"key\">Ctrl<\/span> + <span class=\"key\">2<\/span><\/td>\n<\/tr>\n<tr>\n<td>Underline<\/td>\n<td><span class=\"key\">\u2318<\/span> + <span class=\"key\">u<\/span><\/td>\n<td><span class=\"key\">\u2318<\/span> + <span class=\"key\">4<\/span><\/td>\n<td><span class=\"key\">Ctrl<\/span> + <span class=\"key\">4<\/span><\/td>\n<\/tr>\n<tr>\n<td>Italic<\/td>\n<td><span class=\"key\">\u2318<\/span> + <span class=\"key\">i<\/span><\/td>\n<td><span class=\"key\">\u2318<\/span> + <span class=\"key\">3<\/span><\/td>\n<td><span class=\"key\">Ctrl<\/span> + <span class=\"key\">3<\/span><\/td>\n<\/tr>\n<tr>\n<td>Strikethrough<\/td>\n<td><span class=\"key\">\u2318<\/span> + <span class=\"key\">Shift<\/span> + <span class=\"key\">x<\/span><\/td>\n<td><span class=\"key\">\u2318<\/span> + <span class=\"key\">5<\/span><\/td>\n<td><span class=\"key\">Ctrl<\/span> + <span class=\"key\">5<\/span><\/td>\n<\/tr>\n<tr>\n<td>Center align<\/td>\n<td><span class=\"key\">\u2318<\/span> + <span class=\"key\">Shift<\/span> + <span class=\"key\">e<\/span><\/td>\n<td>\u00a0<\/td>\n<td>\u00a0<\/td>\n<\/tr>\n<tr>\n<td>Left align<\/td>\n<td><span class=\"key\">\u2318<\/span> + <span class=\"key\">Shift<\/span> + <span class=\"key\">l<\/span><\/td>\n<td>\u00a0<\/td>\n<td>\u00a0<\/td>\n<\/tr>\n<tr>\n<td>Right align<\/td>\n<td><span class=\"key\">\u2318<\/span> + <span class=\"key\">Shift<\/span> + <span class=\"key\">r<\/span><\/td>\n<td>\u00a0<\/td>\n<td>\u00a0<\/td>\n<\/tr>\n<tr>\n<td>Apply top border<\/td>\n<td><span class=\"key\">Option<\/span> + <span class=\"key\">Shift<\/span> + <span class=\"key\">1<\/span><\/td>\n<td>\u00a0<\/td>\n<td>\u00a0<\/td>\n<\/tr>\n<tr>\n<td>Apply right border<\/td>\n<td><span class=\"key\">Option<\/span> + <span class=\"key\">Shift<\/span> + <span class=\"key\">2<\/span><\/td>\n<td>\u00a0<\/td>\n<td>\u00a0<\/td>\n<\/tr>\n<tr>\n<td>Apply bottom border<\/td>\n<td><span class=\"key\">Option<\/span> + <span class=\"key\">Shift<\/span> + <span class=\"key\">3<\/span><\/td>\n<td>\u00a0<\/td>\n<td>\u00a0<\/td>\n<\/tr>\n<tr>\n<td>Apply left border<\/td>\n<td><span class=\"key\">Option<\/span> + <span class=\"key\">Shift<\/span> + <span class=\"key\">4<\/span><\/td>\n<td>\u00a0<\/td>\n<td>\u00a0<\/td>\n<\/tr>\n<tr>\n<td>Remove borders<\/td>\n<td><span class=\"key\">Option<\/span> + <span class=\"key\">Shift<\/span> + <span class=\"key\">6<\/span><\/td>\n<td>\u00a0<\/td>\n<td>\u00a0<\/td>\n<\/tr>\n<tr>\n<td>Apply outer border<\/td>\n<td><span class=\"key\">Option<\/span> + <span class=\"key\">Shift<\/span> + <span class=\"key\">7<\/span><\/td>\n<td><span class=\"key\">\u2318<\/span> + <span class=\"key\">Shift<\/span> + <span class=\"key\">7<\/span><\/td>\n<td><span class=\"key\">Ctrl<\/span> + <span class=\"key\">Shift<\/span> + <span class=\"key\">7<\/span><\/td>\n<\/tr>\n<tr>\n<td>Insert link<\/td>\n<td><span class=\"key\">\u2318<\/span> + <span class=\"key\">k<\/span><\/td>\n<td>\u00a0<\/td>\n<td>\u00a0<\/td>\n<\/tr>\n<tr>\n<td>Insert time<\/td>\n<td><span class=\"key\">\u2318<\/span> + <span class=\"key\">Shift<\/span> + <span class=\"key\">;<\/span><\/td>\n<td>\u00a0<\/td>\n<td>\u00a0<\/td>\n<\/tr>\n<tr>\n<td>Insert date<\/td>\n<td><span class=\"key\">\u2318<\/span> + <span class=\"key\">;<\/span><\/td>\n<td>\u00a0<\/td>\n<td>\u00a0<\/td>\n<\/tr>\n<tr>\n<td>Insert date and time<\/td>\n<td><span class=\"key\">\u2318<\/span> + <span class=\"key\">Option<\/span> + <span class=\"key\">Shift<\/span> + <span class=\"key\">;<\/span><\/td>\n<td>\u00a0<\/td>\n<td>\u00a0<\/td>\n<\/tr>\n<tr>\n<td>Format as decimal<\/td>\n<td><span class=\"key\">Ctrl<\/span> + <span class=\"key\">Shift<\/span> + <span class=\"key\">1<\/span><\/td>\n<td>\u00a0<\/td>\n<td>\u00a0<\/td>\n<\/tr>\n<tr>\n<td>Format as time<\/td>\n<td><span class=\"key\">Ctrl<\/span> + <span class=\"key\">Shift<\/span> + <span class=\"key\">2<\/span><\/td>\n<td>\u00a0<\/td>\n<td>\u00a0<\/td>\n<\/tr>\n<tr>\n<td>Format as date<\/td>\n<td><span class=\"key\">Ctrl<\/span> + <span class=\"key\">Shift<\/span> + <span class=\"key\">3<\/span><\/td>\n<td>\u00a0<\/td>\n<td>\u00a0<\/td>\n<\/tr>\n<tr>\n<td>Format as currency<\/td>\n<td><span class=\"key\">Ctrl<\/span> + <span class=\"key\">Shift<\/span> + <span class=\"key\">4<\/span><\/td>\n<td>\u00a0<\/td>\n<td>\u00a0<\/td>\n<\/tr>\n<tr>\n<td>Format as percentage<\/td>\n<td><span class=\"key\">Ctrl<\/span> + <span class=\"key\">Shift<\/span> + <span class=\"key\">5<\/span><\/td>\n<td>\u00a0<\/td>\n<td>\u00a0<\/td>\n<\/tr>\n<tr>\n<td>Format as exponent<\/td>\n<td><span class=\"key\">Ctrl<\/span> + <span class=\"key\">Shift<\/span> + <span class=\"key\">6<\/span><\/td>\n<td>\u00a0<\/td>\n<td>\u00a0<\/td>\n<\/tr>\n<tr>\n<td>Clear formatting<\/td>\n<td><span class=\"key\">\u2318<\/span> + \\<\/td>\n<td>\u00a0<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3>Navigate the Spreadsheet<\/h3>\n<table id=\"navigate_spreadsheet\">\n<thead>\n<tr>\n<td>Action<\/td>\n<td>Shortcut<\/td>\n<td>Shortcut(Macbook)<\/td>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>Move to beginning of row<\/td>\n<td><span class=\"key\">Fn<\/span> + <span class=\"key\">left Arrow<\/span><\/td>\n<td>\u00a0<\/td>\n<\/tr>\n<tr>\n<td>Move to beginning of sheet<\/td>\n<td><span class=\"key\">\u2318<\/span> + <span class=\"key\">Fn<\/span> + <span class=\"key\">left Arrow<\/span><\/td>\n<td>\u00a0<\/td>\n<\/tr>\n<tr>\n<td>Move to end of row<\/td>\n<td><span class=\"key\">Fn<\/span> + <span class=\"key\">right Arrow<\/span><\/td>\n<td>\u00a0<\/td>\n<\/tr>\n<tr>\n<td>Move to end of sheet<\/td>\n<td><span class=\"key\">\u2318<\/span> + <span class=\"key\">Fn<\/span> + <span class=\"key\">right Arrow<\/span><\/td>\n<td>\u00a0<\/td>\n<\/tr>\n<tr>\n<td>Scroll to active cell<\/td>\n<td><span class=\"key\">\u2318<\/span> + <span class=\"key\">Backspace<\/span><\/td>\n<td>\u00a0<\/td>\n<\/tr>\n<tr>\n<td>Move to next sheet<\/td>\n<td><span class=\"key\">Option<\/span> + <span class=\"key\">down Arrow<\/span><\/td>\n<td><span class=\"key\">Option<\/span> + <span class=\"key\">right Arrow<\/span><\/td>\n<\/tr>\n<tr>\n<td>Move to previous sheet<\/td>\n<td><span class=\"key\">Option<\/span> + <span class=\"key\">up Arrow<\/span><\/td>\n<td><span class=\"key\">Option<\/span> + <span class=\"key\">left Arrow<\/span><\/td>\n<\/tr>\n<tr>\n<td>Display list of sheets<\/td>\n<td><span class=\"key\">Option<\/span> + <span class=\"key\">Shift<\/span> + <span class=\"key\">k<\/span><\/td>\n<td>\u00a0<\/td>\n<\/tr>\n<tr>\n<td>Open hyperlink<\/td>\n<td><span class=\"key\">Option<\/span> + <span class=\"key\">Enter<\/span><\/td>\n<td>\u00a0<\/td>\n<\/tr>\n<tr>\n<td>Open Explore<\/td>\n<td><span class=\"key\">\u2318<\/span> + <span class=\"key\">Option<\/span> + <span class=\"key\">Shift<\/span> + <span class=\"key\">i<\/span><\/td>\n<td>\u00a0<\/td>\n<\/tr>\n<tr>\n<td>Go to side panel<\/td>\n<td><span class=\"key\">\u2318<\/span> + <span class=\"key\">Option<\/span> + <span class=\"key\">.<\/span> \/ <span class=\"key\">\u2318<\/span> + <span class=\"key\">Option<\/span> + <span class=\"key\">,<\/span><\/td>\n<td>\u00a0<\/td>\n<\/tr>\n<tr>\n<td>Move focus out of spreadsheet<\/td>\n<td><span class=\"key\">Ctrl<\/span> + <span class=\"key\">\u2318<\/span> + <span class=\"key\">Shift<\/span> + <span class=\"key\">m<\/span><\/td>\n<td>\u00a0<\/td>\n<\/tr>\n<tr>\n<td>Move to quicksum (when a range of cells is selected)<\/td>\n<td><span class=\"key\">Option<\/span> + <span class=\"key\">Shift<\/span> + <span class=\"key\">q<\/span><\/td>\n<td>\u00a0<\/td>\n<\/tr>\n<tr>\n<td>Move focus to popup (for links, bookmarks, images)<\/td>\n<td>hold <span class=\"key\">Ctrl<\/span> + <span class=\"key\">\u2318<\/span>, press <span class=\"key\">e<\/span> then <span class=\"key\">p<\/span><\/td>\n<td>\u00a0<\/td>\n<\/tr>\n<tr>\n<td>Open drop-down menu on filtered cell<\/td>\n<td><span class=\"key\">Ctrl<\/span> + <span class=\"key\">\u2318<\/span> + <span class=\"key\">r<\/span><\/td>\n<td>\u00a0<\/td>\n<\/tr>\n<tr>\n<td>Open revision history<\/td>\n<td><span class=\"key\">\u2318<\/span> + <span class=\"key\">Option<\/span> + <span class=\"key\">Shift<\/span> + <span class=\"key\">h<\/span><\/td>\n<td>\u00a0<\/td>\n<\/tr>\n<tr>\n<td>Close drawing editor<\/td>\n<td><span class=\"key\">\u2318<\/span> + <span class=\"key\">esc<\/span> \/ <span class=\"key\">Shift<\/span> + <span class=\"key\">esc<\/span><\/td>\n<td>\u00a0<\/td>\n<\/tr>\n<tr>\n<td>Show \u201cGo to range\u201d dialog<\/td>\n<td><span class=\"key\">Ctrl<\/span> + <span class=\"key\">G<\/span><\/td>\n<td>\u00a0<\/td>\n<\/tr>\n<tr>\n<td>Find and replace with Find tab selected<\/td>\n<td><span class=\"key\">Ctrl<\/span> + <span class=\"key\">f<\/span><\/td>\n<td>\u00a0<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3>Edit Notes and Comments<\/h3>\n<table id=\"edit_notes_comments\">\n<thead>\n<tr>\n<td>Action<\/td>\n<td>Macbook<\/td>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>Insert\/edit note<\/td>\n<td><span class=\"key\">Shift<\/span> + <span class=\"key\">f2<\/span><\/td>\n<\/tr>\n<tr>\n<td>Insert\/edit comment<\/td>\n<td><span class=\"key\">\u2318<\/span> + <span class=\"key\">Option<\/span> + <span class=\"key\">m<\/span><\/td>\n<\/tr>\n<tr>\n<td>Open comment discussion thread<\/td>\n<td><span class=\"key\">\u2318<\/span> + <span class=\"key\">Option<\/span> + <span class=\"key\">Shift<\/span> + <span class=\"key\">a<\/span><\/td>\n<\/tr>\n<tr>\n<td>Enter current comment<\/td>\n<td>hold <span class=\"key\">Ctrl<\/span> + <span class=\"key\">\u2318<\/span>, press <span class=\"key\">e<\/span> then <span class=\"key\">c<\/span><\/td>\n<\/tr>\n<tr>\n<td>Move to next comment<\/td>\n<td>hold <span class=\"key\">Ctrl<\/span> + <span class=\"key\">\u2318<\/span>, press <span class=\"key\">n<\/span> then <span class=\"key\">c<\/span><\/td>\n<\/tr>\n<tr>\n<td>Move to previous comment<\/td>\n<td>hold <span class=\"key\">Ctrl<\/span> + <span class=\"key\">\u2318<\/span>, press <span class=\"key\">p<\/span> then <span class=\"key\">c<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3>Use Keyboard Shortcuts on Selected Comments<\/h3>\n<table id=\"selected_comments\">\n<thead>\n<tr>\n<td>Action<\/td>\n<td>Macbook<\/td>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>Reply to current comment<\/td>\n<td><span class=\"key\">R<\/span><\/td>\n<\/tr>\n<tr>\n<td>Move to next comment<\/td>\n<td><span class=\"key\">J<\/span><\/td>\n<\/tr>\n<tr>\n<td>Move to previous comment<\/td>\n<td><span class=\"key\">K<\/span><\/td>\n<\/tr>\n<tr>\n<td>Resolve current comment<\/td>\n<td><span class=\"key\">E<\/span><\/td>\n<\/tr>\n<tr>\n<td>Exit current comment<\/td>\n<td><span class=\"key\">U<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3>Open a Menu<\/h3>\n<table id=\"open_menu\">\n<tbody>\n<tr>\n<td>Open File menu<\/td>\n<td><span class=\"key\">Ctrl<\/span> + <span class=\"key\">Option<\/span> + <span class=\"key\">f<\/span><\/td>\n<\/tr>\n<tr>\n<td>Open Edit menu<\/td>\n<td><span class=\"key\">Ctrl<\/span> + <span class=\"key\">Option<\/span> + <span class=\"key\">e<\/span><\/td>\n<\/tr>\n<tr>\n<td>Open View menu<\/td>\n<td><span class=\"key\">Ctrl<\/span> + <span class=\"key\">Option<\/span> + <span class=\"key\">v<\/span><\/td>\n<\/tr>\n<tr>\n<td>Open Insert menu<\/td>\n<td><span class=\"key\">Ctrl<\/span> + <span class=\"key\">Option<\/span> + <span class=\"key\">i<\/span><\/td>\n<\/tr>\n<tr>\n<td>Open Format menu<\/td>\n<td><span class=\"key\">Ctrl<\/span> + <span class=\"key\">Option<\/span> + <span class=\"key\">o<\/span><\/td>\n<\/tr>\n<tr>\n<td>Open Data menu<\/td>\n<td><span class=\"key\">Ctrl<\/span> + <span class=\"key\">Option<\/span> + <span class=\"key\">d<\/span><\/td>\n<\/tr>\n<tr>\n<td>Open Tools menu<\/td>\n<td><span class=\"key\">Ctrl<\/span> + <span class=\"key\">Option<\/span> + <span class=\"key\">t<\/span><\/td>\n<\/tr>\n<tr>\n<td>Open insert menu (with cells selected)<\/td>\n<td><span class=\"key\">\u2318<\/span> + <span class=\"key\">Option<\/span> + <span class=\"key\">=<\/span><\/td>\n<\/tr>\n<tr>\n<td>Open delete menu (with cells selected)<\/td>\n<td><span class=\"key\">\u2318<\/span> + <span class=\"key\">Option<\/span> + <span class=\"key\">\u2013<\/span><\/td>\n<\/tr>\n<tr>\n<td>Open Form menu (when connected to a form)<\/td>\n<td><span class=\"key\">Ctrl<\/span> + <span class=\"key\">Option<\/span> + <span class=\"key\">m<\/span><\/td>\n<\/tr>\n<tr>\n<td>Open Add-ons menu<\/td>\n<td><span class=\"key\">Ctrl<\/span> + <span class=\"key\">Option<\/span> + <span class=\"key\">n<\/span><\/td>\n<\/tr>\n<tr>\n<td>Open Help menu<\/td>\n<td><span class=\"key\">Ctrl<\/span> + <span class=\"key\">Option<\/span> + <span class=\"key\">h<\/span><\/td>\n<\/tr>\n<tr>\n<td>Open Accessibility menu (screen reader support)<\/td>\n<td><span class=\"key\">Ctrl<\/span> + <span class=\"key\">Option<\/span> + <span class=\"key\">a<\/span><\/td>\n<\/tr>\n<tr>\n<td>Open Sheet menu (copy, delete, other sheet actions)<\/td>\n<td><span class=\"key\">Option<\/span> + <span class=\"key\">Shift<\/span> + <span class=\"key\">s<\/span><\/td>\n<\/tr>\n<tr>\n<td>Open Context menu<\/td>\n<td><span class=\"key\">\u2318<\/span> + <span class=\"key\">Shift<\/span> + <span class=\"key\">\\<\/span> or <span class=\"key\">Shift<\/span> + <span class=\"key\">f10<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3>Add or Change Rows and Columns<\/h3>\n<table id=\"add_change_rows_columns\">\n<thead>\n<tr>\n<td>Action<\/td>\n<td>Shortcut<\/td>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>Insert rows above<\/td>\n<td><span class=\"key\">\u2318<\/span> + <span class=\"key\">Option<\/span> + <span class=\"key\">=<\/span> (with rows selected)<\/td>\n<\/tr>\n<tr>\n<td>Insert rows below<\/td>\n<td>\u00a0<\/td>\n<\/tr>\n<tr>\n<td>Insert columns to the left<\/td>\n<td><span class=\"key\">\u2318<\/span> + <span class=\"key\">Option<\/span> + <span class=\"key\">=<\/span> (with columns selected)<\/td>\n<\/tr>\n<tr>\n<td>Insert columns to the right<\/td>\n<td>\u00a0<\/td>\n<\/tr>\n<tr>\n<td>Delete rows<\/td>\n<td><span class=\"key\">\u2318<\/span> + <span class=\"key\">Option<\/span> + <span class=\"key\">\u2013<\/span> (with rows selected)<\/td>\n<\/tr>\n<tr>\n<td>Delete columns<\/td>\n<td><span class=\"key\">\u2318<\/span> + <span class=\"key\">Option<\/span> + <span class=\"key\">\u2013<\/span> (with columns selected)<\/td>\n<\/tr>\n<tr>\n<td>Hide row<\/td>\n<td><span class=\"key\">\u2318<\/span> + <span class=\"key\">Option<\/span> + <span class=\"key\">9<\/span><\/td>\n<\/tr>\n<tr>\n<td>Unhide row<\/td>\n<td><span class=\"key\">\u2318<\/span> + <span class=\"key\">Shift<\/span> + <span class=\"key\">9<\/span><\/td>\n<\/tr>\n<tr>\n<td>Hide column<\/td>\n<td><span class=\"key\">\u2318<\/span> + <span class=\"key\">Option<\/span> + <span class=\"key\">0<\/span><\/td>\n<\/tr>\n<tr>\n<td>Unhide column<\/td>\n<td><span class=\"key\">\u2318<\/span> + <span class=\"key\">Shift<\/span> + <span class=\"key\">0<\/span><\/td>\n<\/tr>\n<tr>\n<td>Group rows or columns<\/td>\n<td><span class=\"key\">Option<\/span> + <span class=\"key\">Shift<\/span> + <span class=\"key\">right Arrow<\/span><\/td>\n<\/tr>\n<tr>\n<td>Ungroup rows or columns<\/td>\n<td><span class=\"key\">Option<\/span> + <span class=\"key\">Shift<\/span> + <span class=\"key\">left Arrow<\/span><\/td>\n<\/tr>\n<tr>\n<td>Expand grouped rows or columns<\/td>\n<td><span class=\"key\">Option<\/span> + <span class=\"key\">Shift<\/span> + <span class=\"key\">down Arrow<\/span><\/td>\n<\/tr>\n<tr>\n<td>Collapse grouped rows or columns<\/td>\n<td><span class=\"key\">Option<\/span> + <span class=\"key\">Shift<\/span> + <span class=\"key\">up Arrow<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3>Use Formulas<\/h3>\n<table id=\"use_formulas\">\n<thead>\n<tr>\n<td>Action<\/td>\n<td>Shortcut<\/td>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>Show all formulas<\/td>\n<td><span class=\"key\">Ctrl<\/span> + <span class=\"key\">~<\/span><\/td>\n<\/tr>\n<tr>\n<td>Insert array formula<\/td>\n<td><span class=\"key\">\u2318<\/span> + <span class=\"key\">Shift<\/span> + <span class=\"key\">Enter<\/span><\/td>\n<\/tr>\n<tr>\n<td>Collapse an expanded array formula<\/td>\n<td><span class=\"key\">\u2318<\/span> + <span class=\"key\">e<\/span><\/td>\n<\/tr>\n<tr>\n<td>Show\/hide formula help (when entering a formula)<\/td>\n<td><span class=\"key\">Shift<\/span> + <span class=\"key\">Fn<\/span> + <span class=\"key\">f1<\/span><\/td>\n<\/tr>\n<tr>\n<td>Full\/compact formula help (when entering a formula)<\/td>\n<td><span class=\"key\">Fn<\/span> + <span class=\"key\">f1<\/span><\/td>\n<\/tr>\n<tr>\n<td>Absolute\/relative references (when entering a formula)<\/td>\n<td><span class=\"key\">Fn<\/span> + <span class=\"key\">f4<\/span><\/td>\n<\/tr>\n<tr>\n<td>Toggle formula result previews (when entering a formula)<\/td>\n<td><span class=\"key\">Fn<\/span> + <span class=\"key\">f9<\/span><\/td>\n<\/tr>\n<tr>\n<td>Resize formula bar (move up or down)<\/td>\n<td><span class=\"key\">Ctrl<\/span> + <span class=\"key\">Option<\/span> + <span class=\"key\">up<\/span> and <span class=\"key\">Ctrl<\/span> + <span class=\"key\">Option<\/span> + <span class=\"key\">down<\/span><\/td>\n<\/tr>\n<tr>\n<td>Toggle formula range selection (when entering a formula)<\/td>\n<td><span class=\"key\">F2<\/span>, <span class=\"key\">Ctrl<\/span> + <span class=\"key\">e<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3>Help for Screen Readers<\/h3>\n<table id=\"help_screen_readers\">\n<thead>\n<tr>\n<td>Action<\/td>\n<td>Shortcut<\/td>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>Turn on screen reader support<\/td>\n<td><span class=\"key\">\u2318<\/span> + <span class=\"key\">Option<\/span> + <span class=\"key\">z<\/span><\/td>\n<\/tr>\n<tr>\n<td>Learn more about using Google Sheets with a screen reader<\/td>\n<td><span class=\"key\">\u2318<\/span> + <span class=\"key\">Option<\/span> + <span class=\"key\">z<\/span><\/td>\n<\/tr>\n<tr>\n<td>Enable braille support<\/td>\n<td><span class=\"key\">\u2318<\/span> + <span class=\"key\">Option<\/span> + <span class=\"key\">h<\/span><\/td>\n<\/tr>\n<tr>\n<td>Read column<\/td>\n<td><span class=\"key\">\u2318<\/span> + <span class=\"key\">Option<\/span> + <span class=\"key\">Shift<\/span> + <span class=\"key\">c<\/span><\/td>\n<\/tr>\n<tr>\n<td>Read row<\/td>\n<td><span class=\"key\">\u2318<\/span> + <span class=\"key\">Option<\/span> + <span class=\"key\">Shift<\/span> + <span class=\"key\">r<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>","protected":false},"excerpt":{"rendered":"<p>Learn the keyboard shortcuts that make Google Sheets on Mac a breeze.<\/p>\n","protected":false},"author":9,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[3398],"tags":[4554,2273],"topic":[],"class_list":["entry-content","is-maxi"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v22.8 (Yoast SEO v27.6) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Google Sheets Keyboard Shortcuts for Mac Users - Hongkiat<\/title>\n<meta name=\"description\" content=\"Learn the keyboard shortcuts that make Google Sheets on Mac a breeze.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.hongkiat.com\/blog\/google-sheets-mac-shortcuts\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Google Sheets Keyboard Shortcuts for Mac Users\" \/>\n<meta property=\"og:description\" content=\"Learn the keyboard shortcuts that make Google Sheets on Mac a breeze.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.hongkiat.com\/blog\/google-sheets-mac-shortcuts\/\" \/>\n<meta property=\"og:site_name\" content=\"Hongkiat\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/hongkiatcom\" \/>\n<meta property=\"article:published_time\" content=\"2023-08-17T10:01:47+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-08-24T09:06:26+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/assets.hongkiat.com\/uploads\/google-sheets-mac-shortcuts\/google-sheets-keyboard-shortcuts.jpg\" \/>\n<meta name=\"author\" content=\"Hongkiat.com\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@hongkiat\" \/>\n<meta name=\"twitter:site\" content=\"@hongkiat\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Hongkiat.com\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/google-sheets-mac-shortcuts\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/google-sheets-mac-shortcuts\\\/\"},\"author\":{\"name\":\"Hongkiat.com\",\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/#\\\/schema\\\/person\\\/7cc686597d92f9086729e4bcc1577ba3\"},\"headline\":\"Google Sheets Keyboard Shortcuts for Mac Users\",\"datePublished\":\"2023-08-17T10:01:47+00:00\",\"dateModified\":\"2023-08-24T09:06:26+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/google-sheets-mac-shortcuts\\\/\"},\"wordCount\":943,\"publisher\":{\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/google-sheets-mac-shortcuts\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/assets.hongkiat.com\\\/uploads\\\/google-sheets-mac-shortcuts\\\/google-sheets-keyboard-shortcuts.jpg\",\"keywords\":[\"Google Sheets\",\"Keyboard Shortcuts\"],\"articleSection\":[\"Internet\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/google-sheets-mac-shortcuts\\\/\",\"url\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/google-sheets-mac-shortcuts\\\/\",\"name\":\"Google Sheets Keyboard Shortcuts for Mac Users - Hongkiat\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/google-sheets-mac-shortcuts\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/google-sheets-mac-shortcuts\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/assets.hongkiat.com\\\/uploads\\\/google-sheets-mac-shortcuts\\\/google-sheets-keyboard-shortcuts.jpg\",\"datePublished\":\"2023-08-17T10:01:47+00:00\",\"dateModified\":\"2023-08-24T09:06:26+00:00\",\"description\":\"Learn the keyboard shortcuts that make Google Sheets on Mac a breeze.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/google-sheets-mac-shortcuts\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/google-sheets-mac-shortcuts\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/google-sheets-mac-shortcuts\\\/#primaryimage\",\"url\":\"https:\\\/\\\/assets.hongkiat.com\\\/uploads\\\/google-sheets-mac-shortcuts\\\/google-sheets-keyboard-shortcuts.jpg\",\"contentUrl\":\"https:\\\/\\\/assets.hongkiat.com\\\/uploads\\\/google-sheets-mac-shortcuts\\\/google-sheets-keyboard-shortcuts.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/google-sheets-mac-shortcuts\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Google Sheets Keyboard Shortcuts for Mac Users\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/\",\"name\":\"Hongkiat\",\"description\":\"Tech and Design Tips\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/#organization\",\"name\":\"Hongkiat.com\",\"url\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/wp-content\\\/uploads\\\/hkdc-logo-rect-yoast.jpg\",\"contentUrl\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/wp-content\\\/uploads\\\/hkdc-logo-rect-yoast.jpg\",\"width\":1200,\"height\":799,\"caption\":\"Hongkiat.com\"},\"image\":{\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/hongkiatcom\",\"https:\\\/\\\/x.com\\\/hongkiat\",\"https:\\\/\\\/www.pinterest.com\\\/hongkiat\\\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/#\\\/schema\\\/person\\\/7cc686597d92f9086729e4bcc1577ba3\",\"name\":\"Hongkiat.com\",\"description\":\"This post is published by an HKDC (hongkiat.com) staff. (I.e., intern, staff writer, or editor).\",\"sameAs\":[\"https:\\\/\\\/www.hongkiat.com\"],\"url\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/author\\\/com\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Google Sheets Keyboard Shortcuts for Mac Users - Hongkiat","description":"Learn the keyboard shortcuts that make Google Sheets on Mac a breeze.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.hongkiat.com\/blog\/google-sheets-mac-shortcuts\/","og_locale":"en_US","og_type":"article","og_title":"Google Sheets Keyboard Shortcuts for Mac Users","og_description":"Learn the keyboard shortcuts that make Google Sheets on Mac a breeze.","og_url":"https:\/\/www.hongkiat.com\/blog\/google-sheets-mac-shortcuts\/","og_site_name":"Hongkiat","article_publisher":"https:\/\/www.facebook.com\/hongkiatcom","article_published_time":"2023-08-17T10:01:47+00:00","article_modified_time":"2023-08-24T09:06:26+00:00","og_image":[{"url":"https:\/\/assets.hongkiat.com\/uploads\/google-sheets-mac-shortcuts\/google-sheets-keyboard-shortcuts.jpg","type":"","width":"","height":""}],"author":"Hongkiat.com","twitter_card":"summary_large_image","twitter_creator":"@hongkiat","twitter_site":"@hongkiat","twitter_misc":{"Written by":"Hongkiat.com","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.hongkiat.com\/blog\/google-sheets-mac-shortcuts\/#article","isPartOf":{"@id":"https:\/\/www.hongkiat.com\/blog\/google-sheets-mac-shortcuts\/"},"author":{"name":"Hongkiat.com","@id":"https:\/\/www.hongkiat.com\/blog\/#\/schema\/person\/7cc686597d92f9086729e4bcc1577ba3"},"headline":"Google Sheets Keyboard Shortcuts for Mac Users","datePublished":"2023-08-17T10:01:47+00:00","dateModified":"2023-08-24T09:06:26+00:00","mainEntityOfPage":{"@id":"https:\/\/www.hongkiat.com\/blog\/google-sheets-mac-shortcuts\/"},"wordCount":943,"publisher":{"@id":"https:\/\/www.hongkiat.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.hongkiat.com\/blog\/google-sheets-mac-shortcuts\/#primaryimage"},"thumbnailUrl":"https:\/\/assets.hongkiat.com\/uploads\/google-sheets-mac-shortcuts\/google-sheets-keyboard-shortcuts.jpg","keywords":["Google Sheets","Keyboard Shortcuts"],"articleSection":["Internet"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.hongkiat.com\/blog\/google-sheets-mac-shortcuts\/","url":"https:\/\/www.hongkiat.com\/blog\/google-sheets-mac-shortcuts\/","name":"Google Sheets Keyboard Shortcuts for Mac Users - Hongkiat","isPartOf":{"@id":"https:\/\/www.hongkiat.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.hongkiat.com\/blog\/google-sheets-mac-shortcuts\/#primaryimage"},"image":{"@id":"https:\/\/www.hongkiat.com\/blog\/google-sheets-mac-shortcuts\/#primaryimage"},"thumbnailUrl":"https:\/\/assets.hongkiat.com\/uploads\/google-sheets-mac-shortcuts\/google-sheets-keyboard-shortcuts.jpg","datePublished":"2023-08-17T10:01:47+00:00","dateModified":"2023-08-24T09:06:26+00:00","description":"Learn the keyboard shortcuts that make Google Sheets on Mac a breeze.","breadcrumb":{"@id":"https:\/\/www.hongkiat.com\/blog\/google-sheets-mac-shortcuts\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.hongkiat.com\/blog\/google-sheets-mac-shortcuts\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.hongkiat.com\/blog\/google-sheets-mac-shortcuts\/#primaryimage","url":"https:\/\/assets.hongkiat.com\/uploads\/google-sheets-mac-shortcuts\/google-sheets-keyboard-shortcuts.jpg","contentUrl":"https:\/\/assets.hongkiat.com\/uploads\/google-sheets-mac-shortcuts\/google-sheets-keyboard-shortcuts.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.hongkiat.com\/blog\/google-sheets-mac-shortcuts\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.hongkiat.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Google Sheets Keyboard Shortcuts for Mac Users"}]},{"@type":"WebSite","@id":"https:\/\/www.hongkiat.com\/blog\/#website","url":"https:\/\/www.hongkiat.com\/blog\/","name":"Hongkiat","description":"Tech and Design Tips","publisher":{"@id":"https:\/\/www.hongkiat.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.hongkiat.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.hongkiat.com\/blog\/#organization","name":"Hongkiat.com","url":"https:\/\/www.hongkiat.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.hongkiat.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.hongkiat.com\/blog\/wp-content\/uploads\/hkdc-logo-rect-yoast.jpg","contentUrl":"https:\/\/www.hongkiat.com\/blog\/wp-content\/uploads\/hkdc-logo-rect-yoast.jpg","width":1200,"height":799,"caption":"Hongkiat.com"},"image":{"@id":"https:\/\/www.hongkiat.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/hongkiatcom","https:\/\/x.com\/hongkiat","https:\/\/www.pinterest.com\/hongkiat\/"]},{"@type":"Person","@id":"https:\/\/www.hongkiat.com\/blog\/#\/schema\/person\/7cc686597d92f9086729e4bcc1577ba3","name":"Hongkiat.com","description":"This post is published by an HKDC (hongkiat.com) staff. (I.e., intern, staff writer, or editor).","sameAs":["https:\/\/www.hongkiat.com"],"url":"https:\/\/www.hongkiat.com\/blog\/author\/com\/"}]}},"jetpack_featured_media_url":"https:\/\/","jetpack_shortlink":"https:\/\/wp.me\/p4uxU-hQB","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/posts\/68609","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/comments?post=68609"}],"version-history":[{"count":3,"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/posts\/68609\/revisions"}],"predecessor-version":[{"id":68901,"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/posts\/68609\/revisions\/68901"}],"wp:attachment":[{"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/media?parent=68609"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/categories?post=68609"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/tags?post=68609"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/topic?post=68609"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}