{"id":68607,"date":"2023-08-10T18:01:43","date_gmt":"2023-08-10T10:01:43","guid":{"rendered":"https:\/\/www.hongkiat.com\/blog\/?p=68607"},"modified":"2023-08-24T17:16:56","modified_gmt":"2023-08-24T09:16:56","slug":"google-sheets-windows-shortcuts","status":"publish","type":"post","link":"https:\/\/www.hongkiat.com\/blog\/google-sheets-windows-shortcuts\/","title":{"rendered":"Google Sheets Keyboard Shortcuts for Windows Users"},"content":{"rendered":"<p>Working with Google Sheets can be a complex task, especially when you\u2019re dealing with extensive data. But what if you could simplify this process and enhance your efficiency? These shortcuts are not just about speeding up your work; they\u2019re about transforming the way you interact with Google Sheets.<\/p>\n<p>From basic navigation to advanced functions, these shortcuts are designed to make your spreadsheet experience smoother and more productive. Here\u2019s a full list of Google Sheets keyboard shortcuts for Windows users.<\/p>\n<figure><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/assets.hongkiat.com\/uploads\/google-sheets-windows-shortcuts\/google-sheets-keyboard-shortcuts.jpg\" alt=\"google sheets windows 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\">Ctrl<\/span> + <span class=\"key\">a<\/span>, <span class=\"key\">Ctrl<\/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\">Ctrl<\/span> + <span class=\"key\">z<\/span><\/td>\n<\/tr>\n<tr>\n<td>Redo<\/td>\n<td><span class=\"key\">Ctrl<\/span> + <span class=\"key\">y<\/span>, <span class=\"key\">Ctrl<\/span> + <span class=\"key\">Shift<\/span> + <span class=\"key\">z<\/span>, <span class=\"key\">F4<\/span><\/td>\n<\/tr>\n<tr>\n<td>Find<\/td>\n<td><span class=\"key\">Ctrl<\/span> + <span class=\"key\">f<\/span><\/td>\n<\/tr>\n<tr>\n<td>Find and replace<\/td>\n<td><span class=\"key\">Ctrl<\/span> + <span class=\"key\">h<\/span><\/td>\n<\/tr>\n<tr>\n<td>Fill range<\/td>\n<td><span class=\"key\">Ctrl<\/span> + <span class=\"key\">Enter<\/span><\/td>\n<\/tr>\n<tr>\n<td>Fill down<\/td>\n<td><span class=\"key\">Ctrl<\/span> + <span class=\"key\">d<\/span><\/td>\n<\/tr>\n<tr>\n<td>Fill right<\/td>\n<td><span class=\"key\">Ctrl<\/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\">Ctrl<\/span> + <span class=\"key\">s<\/span><\/td>\n<\/tr>\n<tr>\n<td>Open<\/td>\n<td><span class=\"key\">Ctrl<\/span> + <span class=\"key\">o<\/span><\/td>\n<\/tr>\n<tr>\n<td>Print<\/td>\n<td><span class=\"key\">Ctrl<\/span> + <span class=\"key\">p<\/span><\/td>\n<\/tr>\n<tr>\n<td>Copy<\/td>\n<td><span class=\"key\">Ctrl<\/span> + <span class=\"key\">c<\/span><\/td>\n<\/tr>\n<tr>\n<td>Cut<\/td>\n<td><span class=\"key\">Ctrl<\/span> + <span class=\"key\">x<\/span><\/td>\n<\/tr>\n<tr>\n<td>Paste<\/td>\n<td><span class=\"key\">Ctrl<\/span> + <span class=\"key\">v<\/span><\/td>\n<\/tr>\n<tr>\n<td>Paste values only<\/td>\n<td><span class=\"key\">Ctrl<\/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\">Ctrl<\/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\">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<\/td>\n<td><span class=\"key\">Ctrl<\/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\">Ctrl<\/span> + <span class=\"key\">alt<\/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\">alt<\/span> + <span class=\"key\">\/<\/span><\/td>\n<\/tr>\n<tr>\n<td>Rename sheet<\/td>\n<td><span class=\"key\">alt<\/span> + <span class=\"key\">1<\/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<\/td>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>Bold<\/td>\n<td><span class=\"key\">Ctrl<\/span> + <span class=\"key\">b<\/span><\/td>\n<\/tr>\n<tr>\n<td>Underline<\/td>\n<td><span class=\"key\">Ctrl<\/span> + <span class=\"key\">u<\/span><\/td>\n<\/tr>\n<tr>\n<td>Italic<\/td>\n<td><span class=\"key\">Ctrl<\/span> + <span class=\"key\">i<\/span><\/td>\n<\/tr>\n<tr>\n<td>Strikethrough<\/td>\n<td><span class=\"key\">alt<\/span> + <span class=\"key\">Shift<\/span> + <span class=\"key\">5<\/span><\/td>\n<\/tr>\n<tr>\n<td>Center align<\/td>\n<td><span class=\"key\">Ctrl<\/span> + <span class=\"key\">Shift<\/span> + <span class=\"key\">e<\/span><\/td>\n<\/tr>\n<tr>\n<td>Left align<\/td>\n<td><span class=\"key\">Ctrl<\/span> + <span class=\"key\">Shift<\/span> + <span class=\"key\">l<\/span><\/td>\n<\/tr>\n<tr>\n<td>Right align<\/td>\n<td><span class=\"key\">Ctrl<\/span> + <span class=\"key\">Shift<\/span> + <span class=\"key\">r<\/span><\/td>\n<\/tr>\n<tr>\n<td>Apply top border<\/td>\n<td><span class=\"key\">alt<\/span> + <span class=\"key\">Shift<\/span> + <span class=\"key\">1<\/span><\/td>\n<\/tr>\n<tr>\n<td>Apply right border<\/td>\n<td><span class=\"key\">alt<\/span> + <span class=\"key\">Shift<\/span> + <span class=\"key\">2<\/span><\/td>\n<\/tr>\n<tr>\n<td>Apply bottom border<\/td>\n<td><span class=\"key\">alt<\/span> + <span class=\"key\">Shift<\/span> + <span class=\"key\">3<\/span><\/td>\n<\/tr>\n<tr>\n<td>Apply left border<\/td>\n<td><span class=\"key\">alt<\/span> + <span class=\"key\">Shift<\/span> + <span class=\"key\">4<\/span><\/td>\n<\/tr>\n<tr>\n<td>Remove borders<\/td>\n<td><span class=\"key\">alt<\/span> + <span class=\"key\">Shift<\/span> + <span class=\"key\">6<\/span><\/td>\n<\/tr>\n<tr>\n<td>Apply outer border<\/td>\n<td><span class=\"key\">alt<\/span> + <span class=\"key\">Shift<\/span> + <span class=\"key\">7<\/span><\/td>\n<\/tr>\n<tr>\n<td>\u00a0<\/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\">Ctrl<\/span> + <span class=\"key\">k<\/span><\/td>\n<\/tr>\n<tr>\n<td>Insert time<\/td>\n<td><span class=\"key\">Ctrl<\/span> + <span class=\"key\">Shift<\/span> + <span class=\"key\">;<\/span><\/td>\n<\/tr>\n<tr>\n<td>Insert date<\/td>\n<td><span class=\"key\">Ctrl<\/span> + <span class=\"key\">;<\/span><\/td>\n<\/tr>\n<tr>\n<td>Insert date and time<\/td>\n<td><span class=\"key\">Ctrl<\/span> + <span class=\"key\">alt<\/span> + <span class=\"key\">Shift<\/span> + <span class=\"key\">;<\/span><\/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<\/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<\/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<\/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<\/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<\/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<\/tr>\n<tr>\n<td>Clear formatting<\/td>\n<td><span class=\"key\">Ctrl<\/span> + <span class=\"key\">\\<\/span><\/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<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>Move to beginning of row<\/td>\n<td><span class=\"key\">Home<\/span><\/td>\n<\/tr>\n<tr>\n<td>Move to beginning of sheet<\/td>\n<td><span class=\"key\">Ctrl<\/span> + <span class=\"key\">home<\/span><\/td>\n<\/tr>\n<tr>\n<td>Move to end of row<\/td>\n<td><span class=\"key\">End<\/span><\/td>\n<\/tr>\n<tr>\n<td>Move to end of sheet<\/td>\n<td><span class=\"key\">Ctrl<\/span> + <span class=\"key\">end<\/span><\/td>\n<\/tr>\n<tr>\n<td>Scroll to active cell<\/td>\n<td><span class=\"key\">Ctrl<\/span> + <span class=\"key\">Backspace<\/span><\/td>\n<\/tr>\n<tr>\n<td>Move to next sheet<\/td>\n<td><span class=\"key\">alt<\/span> + <span class=\"key\">down Arrow<\/span><\/td>\n<\/tr>\n<tr>\n<td>Move to previous sheet<\/td>\n<td><span class=\"key\">alt<\/span> + <span class=\"key\">up Arrow<\/span><\/td>\n<\/tr>\n<tr>\n<td>Display list of sheets<\/td>\n<td><span class=\"key\">alt<\/span> + <span class=\"key\">Shift<\/span> + <span class=\"key\">k<\/span><\/td>\n<\/tr>\n<tr>\n<td>Open hyperlink<\/td>\n<td><span class=\"key\">alt<\/span> + <span class=\"key\">Enter<\/span><\/td>\n<\/tr>\n<tr>\n<td>Open Explore<\/td>\n<td><span class=\"key\">Ctrl<\/span> + <span class=\"key\">alt<\/span> + <span class=\"key\">Shift<\/span> + <span class=\"key\">i<\/span><\/td>\n<\/tr>\n<tr>\n<td>Go to side panel<\/td>\n<td><span class=\"key\">Ctrl<\/span> + <span class=\"key\">alt<\/span> + <span class=\"key\">.<\/span><\/td>\n<\/tr>\n<tr>\n<td>\u00a0<\/td>\n<td><span class=\"key\">Ctrl<\/span> + <span class=\"key\">alt<\/span> + <span class=\"key\">,<\/span><\/td>\n<\/tr>\n<tr>\n<td>Move focus out of spreadsheet<\/td>\n<td><span class=\"key\">Ctrl<\/span> + <span class=\"key\">alt<\/span> + <span class=\"key\">Shift<\/span> + <span class=\"key\">m<\/span><\/td>\n<\/tr>\n<tr>\n<td>Move to quicksum (when a range of cells is selected)<\/td>\n<td><span class=\"key\">alt<\/span> + <span class=\"key\">Shift<\/span> + <span class=\"key\">q<\/span><\/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\">alt<\/span>, press <span class=\"key\">e<\/span> then <span class=\"key\">p<\/span><\/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\">alt<\/span> + <span class=\"key\">r<\/span><\/td>\n<\/tr>\n<tr>\n<td>Open revision history<\/td>\n<td><span class=\"key\">Ctrl<\/span> + <span class=\"key\">alt<\/span> + <span class=\"key\">Shift<\/span> + <span class=\"key\">h<\/span><\/td>\n<\/tr>\n<tr>\n<td>Close drawing editor<\/td>\n<td><span class=\"key\">Shift<\/span> + <span class=\"key\">esc<\/span><\/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>Shortcut<\/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\">Ctrl<\/span> + <span class=\"key\">alt<\/span> + <span class=\"key\">m<\/span><\/td>\n<\/tr>\n<tr>\n<td>Open comment discussion thread<\/td>\n<td><span class=\"key\">Ctrl<\/span> + <span class=\"key\">alt<\/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\">alt<\/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\">alt<\/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\">alt<\/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>Shortcut<\/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<thead>\n<tr>\n<td>Menu<\/td>\n<td>Google Chrome Shortcut<\/td>\n<td>Other Browsers Shortcut<\/td>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>File menu<\/td>\n<td><span class=\"key\">alt<\/span> + <span class=\"key\">f<\/span><\/td>\n<td><span class=\"key\">alt<\/span> + <span class=\"key\">Shift<\/span> + <span class=\"key\">f<\/span><\/td>\n<\/tr>\n<tr>\n<td>Edit menu<\/td>\n<td><span class=\"key\">alt<\/span> + <span class=\"key\">e<\/span><\/td>\n<td><span class=\"key\">alt<\/span> + <span class=\"key\">Shift<\/span> + <span class=\"key\">e<\/span><\/td>\n<\/tr>\n<tr>\n<td>View menu<\/td>\n<td><span class=\"key\">alt<\/span> + <span class=\"key\">v<\/span><\/td>\n<td><span class=\"key\">alt<\/span> + <span class=\"key\">Shift<\/span> + <span class=\"key\">v<\/span><\/td>\n<\/tr>\n<tr>\n<td>Insert menu<\/td>\n<td><span class=\"key\">alt<\/span> + <span class=\"key\">i<\/span><\/td>\n<td><span class=\"key\">alt<\/span> + <span class=\"key\">Shift<\/span> + <span class=\"key\">i<\/span><\/td>\n<\/tr>\n<tr>\n<td>Format menu<\/td>\n<td><span class=\"key\">alt<\/span> + <span class=\"key\">o<\/span><\/td>\n<td><span class=\"key\">alt<\/span> + <span class=\"key\">Shift<\/span> + <span class=\"key\">o<\/span><\/td>\n<\/tr>\n<tr>\n<td>Data menu<\/td>\n<td><span class=\"key\">alt<\/span> + <span class=\"key\">d<\/span><\/td>\n<td><span class=\"key\">alt<\/span> + <span class=\"key\">Shift<\/span> + <span class=\"key\">d<\/span><\/td>\n<\/tr>\n<tr>\n<td>Tools menu<\/td>\n<td><span class=\"key\">alt<\/span> + <span class=\"key\">t<\/span><\/td>\n<td><span class=\"key\">alt<\/span> + <span class=\"key\">Shift<\/span> + <span class=\"key\">t<\/span><\/td>\n<\/tr>\n<tr>\n<td>Open insert menu<\/td>\n<td><span class=\"key\">Ctrl<\/span> + <span class=\"key\">alt<\/span> + <span class=\"key\">Shift<\/span> + <span class=\"key\">=<\/span><\/td>\n<td><span class=\"key\">Ctrl<\/span> + <span class=\"key\">alt<\/span> + <span class=\"key\">=<\/span> (with cells selected)<\/td>\n<\/tr>\n<tr>\n<td>Open delete menu<\/td>\n<td><span class=\"key\">Ctrl<\/span> + <span class=\"key\">alt<\/span> + <span class=\"key\">\u2013<\/span><\/td>\n<td>(with cells selected)<\/td>\n<\/tr>\n<tr>\n<td>Form menu (connected to a form)<\/td>\n<td><span class=\"key\">alt<\/span> + <span class=\"key\">m<\/span><\/td>\n<td><span class=\"key\">alt<\/span> + <span class=\"key\">Shift<\/span> + <span class=\"key\">m<\/span><\/td>\n<\/tr>\n<tr>\n<td>Add-ons menu<\/td>\n<td><span class=\"key\">alt<\/span> + <span class=\"key\">n<\/span><\/td>\n<td><span class=\"key\">alt<\/span> + <span class=\"key\">Shift<\/span> + <span class=\"key\">n<\/span><\/td>\n<\/tr>\n<tr>\n<td>Help menu<\/td>\n<td><span class=\"key\">alt<\/span> + <span class=\"key\">h<\/span><\/td>\n<td><span class=\"key\">alt<\/span> + <span class=\"key\">Shift<\/span> + <span class=\"key\">h<\/span><\/td>\n<\/tr>\n<tr>\n<td>Accessibility menu (screen reader support)<\/td>\n<td><span class=\"key\">alt<\/span> + <span class=\"key\">a<\/span><\/td>\n<td><span class=\"key\">alt<\/span> + <span class=\"key\">Shift<\/span> + <span class=\"key\">a<\/span><\/td>\n<\/tr>\n<tr>\n<td>Sheet menu (copy, delete, other sheet actions)<\/td>\n<td>\u00a0<\/td>\n<td><span class=\"key\">alt<\/span> + <span class=\"key\">Shift<\/span> + <span class=\"key\">s<\/span><\/td>\n<\/tr>\n<tr>\n<td>Context menu<\/td>\n<td><span class=\"key\">Ctrl<\/span> + <span class=\"key\">Shift<\/span> + <span class=\"key\">\\<\/span><\/td>\n<td><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 (General)<\/td>\n<td>Shortcut (Google Chrome)<\/td>\n<td>Shortcut (Other Browsers)<\/td>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>Insert rows above<\/td>\n<td><span class=\"key\">Ctrl<\/span> + <span class=\"key\">alt<\/span> + <span class=\"key\">Shift<\/span> + <span class=\"key\">=<\/span><\/td>\n<td><span class=\"key\">alt<\/span> + <span class=\"key\">i<\/span>, then <span class=\"key\">r<\/span><\/td>\n<td><span class=\"key\">alt<\/span> + <span class=\"key\">Shift<\/span> + <span class=\"key\">i<\/span>, then <span class=\"key\">r<\/span><\/td>\n<\/tr>\n<tr>\n<td>\u00a0<\/td>\n<td><span class=\"key\">Ctrl<\/span> + <span class=\"key\">alt<\/span> + <span class=\"key\">=<\/span> (with rows selected)<\/td>\n<td>\u00a0<\/td>\n<td>\u00a0<\/td>\n<\/tr>\n<tr>\n<td>Insert rows below<\/td>\n<td>\u00a0<\/td>\n<td><span class=\"key\">alt<\/span> + <span class=\"key\">i<\/span>, then <span class=\"key\">w<\/span><\/td>\n<td><span class=\"key\">alt<\/span> + <span class=\"key\">Shift<\/span> + <span class=\"key\">i<\/span>, then w<\/td>\n<\/tr>\n<tr>\n<td>Insert columns to the left<\/td>\n<td><span class=\"key\">Ctrl<\/span> + <span class=\"key\">alt<\/span> + <span class=\"key\">Shift<\/span> + <span class=\"key\">=<\/span><\/td>\n<td><span class=\"key\">alt<\/span> + <span class=\"key\">i<\/span>, then <span class=\"key\">c<\/span><\/td>\n<td><span class=\"key\">alt<\/span> + <span class=\"key\">Shift<\/span> + <span class=\"key\">i<\/span>, then <span class=\"key\">c<\/span><\/td>\n<\/tr>\n<tr>\n<td>\u00a0<\/td>\n<td><span class=\"key\">Ctrl<\/span> + <span class=\"key\">alt<\/span> + <span class=\"key\">=<\/span> (with columns selected)<\/td>\n<td>\u00a0<\/td>\n<td>\u00a0<\/td>\n<\/tr>\n<tr>\n<td>Insert columns to the right<\/td>\n<td>\u00a0<\/td>\n<td><span class=\"key\">alt<\/span> + <span class=\"key\">i<\/span>, then <span class=\"key\">o<\/span><\/td>\n<td><span class=\"key\">alt<\/span> + <span class=\"key\">Shift<\/span> + <span class=\"key\">i<\/span>, then <span class=\"key\">o<\/span><\/td>\n<\/tr>\n<tr>\n<td>Delete rows<\/td>\n<td><span class=\"key\">Ctrl<\/span> + <span class=\"key\">alt<\/span> + <span class=\"key\">\u2013<\/span> (with rows selected)<\/td>\n<td><span class=\"key\">alt<\/span> + <span class=\"key\">e<\/span>, then <span class=\"key\">d<\/span><\/td>\n<td><span class=\"key\">alt<\/span> + <span class=\"key\">Shift<\/span> + <span class=\"key\">e<\/span>, then <span class=\"key\">d<\/span><\/td>\n<\/tr>\n<tr>\n<td>Delete columns<\/td>\n<td><span class=\"key\">Ctrl<\/span> + <span class=\"key\">alt<\/span> + <span class=\"key\">\u2013<\/span> (with columns selected)<\/td>\n<td><span class=\"key\">alt<\/span> + <span class=\"key\">e<\/span>, then <span class=\"key\">e<\/span><\/td>\n<td><span class=\"key\">alt<\/span> + <span class=\"key\">Shift<\/span> + <span class=\"key\">e<\/span>, then <span class=\"key\">e<\/span><\/td>\n<\/tr>\n<tr>\n<td>Hide row<\/td>\n<td><span class=\"key\">Ctrl<\/span> + <span class=\"key\">alt<\/span> + <span class=\"key\">9<\/span><\/td>\n<td>\u00a0<\/td>\n<td>\u00a0<\/td>\n<\/tr>\n<tr>\n<td>Unhide row<\/td>\n<td><span class=\"key\">Ctrl<\/span> + <span class=\"key\">Shift<\/span> + <span class=\"key\">9<\/span><\/td>\n<td>\u00a0<\/td>\n<td>\u00a0<\/td>\n<\/tr>\n<tr>\n<td>Hide column<\/td>\n<td><span class=\"key\">Ctrl<\/span> + <span class=\"key\">alt<\/span> + <span class=\"key\">0<\/span><\/td>\n<td>\u00a0<\/td>\n<td>\u00a0<\/td>\n<\/tr>\n<tr>\n<td>Unhide column<\/td>\n<td><span class=\"key\">Ctrl<\/span> + <span class=\"key\">Shift<\/span> + <span class=\"key\">0<\/span><\/td>\n<td>\u00a0<\/td>\n<td>\u00a0<\/td>\n<\/tr>\n<tr>\n<td>Group rows or columns<\/td>\n<td><span class=\"key\">alt<\/span> + <span class=\"key\">Shift<\/span> + <span class=\"key\">right Arrow<\/span><\/td>\n<td>\u00a0<\/td>\n<td>\u00a0<\/td>\n<\/tr>\n<tr>\n<td>Ungroup rows or columns<\/td>\n<td><span class=\"key\">alt<\/span> + <span class=\"key\">Shift<\/span> + <span class=\"key\">left Arrow<\/span><\/td>\n<td>\u00a0<\/td>\n<td>\u00a0<\/td>\n<\/tr>\n<tr>\n<td>Expand grouped rows or columns<\/td>\n<td><span class=\"key\">alt<\/span> + <span class=\"key\">Shift<\/span> + <span class=\"key\">down Arrow<\/span><\/td>\n<td>\u00a0<\/td>\n<td>\u00a0<\/td>\n<\/tr>\n<tr>\n<td>Collapse grouped rows or columns<\/td>\n<td><span class=\"key\">alt<\/span> + <span class=\"key\">Shift<\/span> + <span class=\"key\">up Arrow<\/span><\/td>\n<td>\u00a0<\/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\">Ctrl<\/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\">Ctrl<\/span> + <span class=\"key\">e<\/span><\/td>\n<\/tr>\n<tr>\n<td>Show\/hide formula help (when entering formula)<\/td>\n<td><span class=\"key\">Shift<\/span> + <span class=\"key\">f1<\/span><\/td>\n<\/tr>\n<tr>\n<td>Full\/compact formula help (when entering formula)<\/td>\n<td><span class=\"key\">F1<\/span><\/td>\n<\/tr>\n<tr>\n<td>Absolute\/relative references (when entering formula)<\/td>\n<td><span class=\"key\">F4<\/span><\/td>\n<\/tr>\n<tr>\n<td>Toggle formula result previews (when entering formula)<\/td>\n<td><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\">up<\/span> \/ <span class=\"key\">Ctrl<\/span> + <span class=\"key\">down<\/span><\/td>\n<\/tr>\n<tr>\n<td>Toggle formula range selection (when entering 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\">Ctrl<\/span> + <span class=\"key\">alt<\/span> + <span class=\"key\">z<\/span><\/td>\n<\/tr>\n<tr>\n<td>Enable braille support<\/td>\n<td><span class=\"key\">Ctrl<\/span> + <span class=\"key\">alt<\/span> + <span class=\"key\">h<\/span><\/td>\n<\/tr>\n<tr>\n<td>Read column<\/td>\n<td><span class=\"key\">Ctrl<\/span> + <span class=\"key\">alt<\/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\">Ctrl<\/span> + <span class=\"key\">alt<\/span> + <span class=\"key\">Shift<\/span> + <span class=\"key\">r<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>","protected":false},"excerpt":{"rendered":"<p>Turn yourself into a Google Sheets pro on Windows with shortcuts that simplify your workflow.<\/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.3) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Google Sheets Keyboard Shortcuts for Windows Users - Hongkiat<\/title>\n<meta name=\"description\" content=\"Turn yourself into a Google Sheets pro on Windows with shortcuts that simplify your workflow.\" \/>\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-windows-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 Windows Users\" \/>\n<meta property=\"og:description\" content=\"Turn yourself into a Google Sheets pro on Windows with shortcuts that simplify your workflow.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.hongkiat.com\/blog\/google-sheets-windows-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-10T10:01:43+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-08-24T09:16:56+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/assets.hongkiat.com\/uploads\/google-sheets-windows-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-windows-shortcuts\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/google-sheets-windows-shortcuts\\\/\"},\"author\":{\"name\":\"Hongkiat.com\",\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/#\\\/schema\\\/person\\\/7cc686597d92f9086729e4bcc1577ba3\"},\"headline\":\"Google Sheets Keyboard Shortcuts for Windows Users\",\"datePublished\":\"2023-08-10T10:01:43+00:00\",\"dateModified\":\"2023-08-24T09:16:56+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/google-sheets-windows-shortcuts\\\/\"},\"wordCount\":1005,\"publisher\":{\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/google-sheets-windows-shortcuts\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/assets.hongkiat.com\\\/uploads\\\/google-sheets-windows-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-windows-shortcuts\\\/\",\"url\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/google-sheets-windows-shortcuts\\\/\",\"name\":\"Google Sheets Keyboard Shortcuts for Windows Users - Hongkiat\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/google-sheets-windows-shortcuts\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/google-sheets-windows-shortcuts\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/assets.hongkiat.com\\\/uploads\\\/google-sheets-windows-shortcuts\\\/google-sheets-keyboard-shortcuts.jpg\",\"datePublished\":\"2023-08-10T10:01:43+00:00\",\"dateModified\":\"2023-08-24T09:16:56+00:00\",\"description\":\"Turn yourself into a Google Sheets pro on Windows with shortcuts that simplify your workflow.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/google-sheets-windows-shortcuts\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/google-sheets-windows-shortcuts\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/google-sheets-windows-shortcuts\\\/#primaryimage\",\"url\":\"https:\\\/\\\/assets.hongkiat.com\\\/uploads\\\/google-sheets-windows-shortcuts\\\/google-sheets-keyboard-shortcuts.jpg\",\"contentUrl\":\"https:\\\/\\\/assets.hongkiat.com\\\/uploads\\\/google-sheets-windows-shortcuts\\\/google-sheets-keyboard-shortcuts.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/google-sheets-windows-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 Windows 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 Windows Users - Hongkiat","description":"Turn yourself into a Google Sheets pro on Windows with shortcuts that simplify your workflow.","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-windows-shortcuts\/","og_locale":"en_US","og_type":"article","og_title":"Google Sheets Keyboard Shortcuts for Windows Users","og_description":"Turn yourself into a Google Sheets pro on Windows with shortcuts that simplify your workflow.","og_url":"https:\/\/www.hongkiat.com\/blog\/google-sheets-windows-shortcuts\/","og_site_name":"Hongkiat","article_publisher":"https:\/\/www.facebook.com\/hongkiatcom","article_published_time":"2023-08-10T10:01:43+00:00","article_modified_time":"2023-08-24T09:16:56+00:00","og_image":[{"url":"https:\/\/assets.hongkiat.com\/uploads\/google-sheets-windows-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-windows-shortcuts\/#article","isPartOf":{"@id":"https:\/\/www.hongkiat.com\/blog\/google-sheets-windows-shortcuts\/"},"author":{"name":"Hongkiat.com","@id":"https:\/\/www.hongkiat.com\/blog\/#\/schema\/person\/7cc686597d92f9086729e4bcc1577ba3"},"headline":"Google Sheets Keyboard Shortcuts for Windows Users","datePublished":"2023-08-10T10:01:43+00:00","dateModified":"2023-08-24T09:16:56+00:00","mainEntityOfPage":{"@id":"https:\/\/www.hongkiat.com\/blog\/google-sheets-windows-shortcuts\/"},"wordCount":1005,"publisher":{"@id":"https:\/\/www.hongkiat.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.hongkiat.com\/blog\/google-sheets-windows-shortcuts\/#primaryimage"},"thumbnailUrl":"https:\/\/assets.hongkiat.com\/uploads\/google-sheets-windows-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-windows-shortcuts\/","url":"https:\/\/www.hongkiat.com\/blog\/google-sheets-windows-shortcuts\/","name":"Google Sheets Keyboard Shortcuts for Windows Users - Hongkiat","isPartOf":{"@id":"https:\/\/www.hongkiat.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.hongkiat.com\/blog\/google-sheets-windows-shortcuts\/#primaryimage"},"image":{"@id":"https:\/\/www.hongkiat.com\/blog\/google-sheets-windows-shortcuts\/#primaryimage"},"thumbnailUrl":"https:\/\/assets.hongkiat.com\/uploads\/google-sheets-windows-shortcuts\/google-sheets-keyboard-shortcuts.jpg","datePublished":"2023-08-10T10:01:43+00:00","dateModified":"2023-08-24T09:16:56+00:00","description":"Turn yourself into a Google Sheets pro on Windows with shortcuts that simplify your workflow.","breadcrumb":{"@id":"https:\/\/www.hongkiat.com\/blog\/google-sheets-windows-shortcuts\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.hongkiat.com\/blog\/google-sheets-windows-shortcuts\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.hongkiat.com\/blog\/google-sheets-windows-shortcuts\/#primaryimage","url":"https:\/\/assets.hongkiat.com\/uploads\/google-sheets-windows-shortcuts\/google-sheets-keyboard-shortcuts.jpg","contentUrl":"https:\/\/assets.hongkiat.com\/uploads\/google-sheets-windows-shortcuts\/google-sheets-keyboard-shortcuts.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.hongkiat.com\/blog\/google-sheets-windows-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 Windows 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-hQz","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/posts\/68607","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=68607"}],"version-history":[{"count":2,"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/posts\/68607\/revisions"}],"predecessor-version":[{"id":68911,"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/posts\/68607\/revisions\/68911"}],"wp:attachment":[{"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/media?parent=68607"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/categories?post=68607"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/tags?post=68607"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/topic?post=68607"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}