{"id":7438,"date":"2017-11-27T15:23:15","date_gmt":"2017-11-27T14:23:15","guid":{"rendered":"https:\/\/blog.sheetgo.com\/?p=7438"},"modified":"2017-11-27T15:23:15","modified_gmt":"2017-11-27T14:23:15","slug":"google-sheets-keyboard-shortcuts-guide","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/fr\/blog\/google-sheets-features\/google-sheets-keyboard-shortcuts-guide\/","title":{"rendered":"Guide des raccourcis clavier de Google Sheets"},"content":{"rendered":"\n[et_pb_section fb_built=&#8221;1&#8243; admin_label=&#8221;section&#8221; module_class=&#8221;sheetgo-post&#8221; _builder_version=&#8221;4.16&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_row admin_label=&#8221;row&#8221; _builder_version=&#8221;4.16&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.16&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_text admin_label=&#8221;Text&#8221; _builder_version=&#8221;4.16&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<p>We all know the disruption the mouse enabled graphical user interface brought to the world. It was revolutionary. Without a doubt, navigation within the applications has become a lot more intuitive. However, for a regular user, using a mouse to work on Google Sheets can slow down productivity. Because, keyboard strokes take much less time to perform than using the mouse to navigate and click. In this article, we list down the most useful Google Sheets keyboard shortcuts. Since, working with the keyboard is much faster than with the mouse.<\/p>\n<h3>Google Sheets Keyboard Shortcuts<\/h3>\n<p>There are a lot of Google Sheets keyboard shortcuts available for us to be able to productively accomplish our day to day tasks. You may access the comprehensive list <a href=\"https:\/\/support.google.com\/docs\/answer\/181110?co=GENIE.Platform%3DDesktop&amp;hl=en&amp;oco=1\" target=\"_blank\" rel=\"noopener noreferrer\">here<\/a>. But, we list below the most useful ones below.<\/p>\n<h4>File actions<\/h4>\n<table width=\"605\">\n<tbody>\n<tr>\n<td width=\"285\"><strong>Action<\/strong><\/td>\n<td width=\"160\"><strong>Windows<\/strong><\/td>\n<td width=\"160\"><strong>Mac<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"285\">Save<br \/>(every change is saved automatically in Drive)<\/td>\n<td width=\"160\">Ctrl + s<\/td>\n<td width=\"160\">\u2318 + s<\/td>\n<\/tr>\n<tr>\n<td width=\"285\">Open<\/td>\n<td width=\"160\">Ctrl + o<\/td>\n<td width=\"160\">\u2318 + o<\/td>\n<\/tr>\n<tr>\n<td width=\"285\">Print<\/td>\n<td width=\"160\">Ctrl + p<\/td>\n<td width=\"160\">\u2318 + p<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h4>Data handling<\/h4>\n<table width=\"471\">\n<tbody>\n<tr>\n<td width=\"151\"><strong>Action<\/strong><\/td>\n<td width=\"160\"><strong>Windows<\/strong><\/td>\n<td width=\"160\"><strong>Mac<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"151\">Copy<\/td>\n<td width=\"160\">Ctrl + c<\/td>\n<td width=\"160\">\u2318 + c<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">Cut<\/td>\n<td width=\"160\">Ctrl + x<\/td>\n<td width=\"160\">\u2318 + x<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">Paste<\/td>\n<td width=\"160\">Ctrl + v<\/td>\n<td width=\"160\">\u2318 + v<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">Paste values only<\/td>\n<td width=\"160\">Ctrl + Shift + v<\/td>\n<td width=\"160\">\u2318 + Shift + v<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">Undo<\/td>\n<td width=\"160\">Ctrl + z<\/td>\n<td width=\"160\">\u2318 + z<\/td>\n<\/tr>\n<tr>\n<td rowspan=\"3\" width=\"151\">Redo<\/td>\n<td width=\"160\">Ctrl + y<\/td>\n<td width=\"160\">\u2318 + y<\/td>\n<\/tr>\n<tr>\n<td width=\"160\">Ctrl + Shift + z<\/td>\n<td width=\"160\">\u2318 + Shift + z<\/td>\n<\/tr>\n<tr>\n<td width=\"160\">F4<\/td>\n<td width=\"160\">Fn + F4<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">Find<\/td>\n<td width=\"160\">Ctrl + f<\/td>\n<td width=\"160\">\u2318 + f<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">Find and replace<\/td>\n<td width=\"160\">Ctrl + h<\/td>\n<td width=\"160\">\u2318 + Shift + h<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">Fill range<\/td>\n<td width=\"160\">Ctrl + Enter<\/td>\n<td width=\"160\">\u2318 + Enter<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">Fill down<\/td>\n<td width=\"160\">Ctrl + d<\/td>\n<td width=\"160\">\u2318 + d<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">Fill right<\/td>\n<td width=\"160\">Ctrl + r<\/td>\n<td width=\"160\">\u2318 + r<\/td>\n<\/tr>\n<tr>\n<td rowspan=\"2\" width=\"151\">Select all<\/td>\n<td width=\"160\">Ctrl + a<\/td>\n<td width=\"160\">\u2318 + a<\/td>\n<\/tr>\n<tr>\n<td width=\"160\">Ctrl + Shift + Space<\/td>\n<td width=\"160\">\u2318 + Shift + Space<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">Select column<\/td>\n<td width=\"160\">Ctrl + Space<\/td>\n<td width=\"160\">Ctrl + Space<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">Select row<\/td>\n<td width=\"160\">Shift + Space<\/td>\n<td width=\"160\">Shift + Space<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row admin_label=&#8221;row&#8221; _builder_version=&#8221;4.16&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.16&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_text admin_label=&#8221;Text&#8221; _builder_version=&#8221;4.16&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<h4>Navigation<\/h4>\n<table width=\"658\">\n<tbody>\n<tr>\n<td width=\"242\"><strong>Action<\/strong><\/td>\n<td width=\"201\"><strong>Windows<\/strong><\/td>\n<td width=\"215\"><strong>Mac<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"242\">Move to beginning of row<\/td>\n<td width=\"201\">Home<\/td>\n<td width=\"215\">Fn + Left arrow<\/td>\n<\/tr>\n<tr>\n<td width=\"242\">Move to beginning of sheet<\/td>\n<td width=\"201\">Ctrl + Home<\/td>\n<td width=\"215\">\u2318 + Fn + Left arrow<\/td>\n<\/tr>\n<tr>\n<td width=\"242\">Move to end of row<\/td>\n<td width=\"201\">End<\/td>\n<td width=\"215\">Fn + Right arrow<\/td>\n<\/tr>\n<tr>\n<td width=\"242\">Move to end of sheet<\/td>\n<td width=\"201\">Ctrl + End<\/td>\n<td width=\"215\">\u2318 + Fn + Right arrow<\/td>\n<\/tr>\n<tr>\n<td width=\"242\">Scroll to active cell<\/td>\n<td width=\"201\">Ctrl + Backspace<\/td>\n<td width=\"215\">\u2318 + Backspace<\/td>\n<\/tr>\n<tr>\n<td width=\"242\">Move to next sheet<\/td>\n<td width=\"201\">Ctrl + Shift + Page Down<\/td>\n<td width=\"215\">\u2318 + Shift + Fn + Down arrow<\/td>\n<\/tr>\n<tr>\n<td width=\"242\">Move to previous sheet<\/td>\n<td width=\"201\">Ctrl + Shift + Page Up<\/td>\n<td width=\"215\">\u2318 + Shift + Fn + Up arrow<\/td>\n<\/tr>\n<tr>\n<td width=\"242\">Display list of sheets<\/td>\n<td width=\"201\">Alt + Shift + k<\/td>\n<td width=\"215\">Option + Shift + k<\/td>\n<\/tr>\n<tr>\n<td width=\"242\">Open hyperlink<\/td>\n<td width=\"201\">Alt + Enter<\/td>\n<td width=\"215\">Option + Enter<\/td>\n<\/tr>\n<tr>\n<td width=\"242\">Open Explore<\/td>\n<td width=\"201\">Alt + Shift + x<\/td>\n<td width=\"215\">Option + Shift + x<\/td>\n<\/tr>\n<tr>\n<td width=\"242\">Move focus out of spreadsheet<\/td>\n<td width=\"201\">Ctrl + Alt + Shift + m<\/td>\n<td width=\"215\">Ctrl + \u2318 + Shift + m<\/td>\n<\/tr>\n<tr>\n<td width=\"242\">Open drop-down menu on filtered cell<\/td>\n<td width=\"201\">Ctrl + Alt + r<\/td>\n<td width=\"215\">Ctrl + \u2318 + r<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<h4>Formatting<\/h4>\n<table width=\"471\">\n<tbody>\n<tr>\n<td width=\"151\"><strong>Action<\/strong><\/td>\n<td width=\"160\"><strong>Windows<\/strong><\/td>\n<td width=\"160\"><strong>Mac<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"151\">Bold<\/td>\n<td width=\"160\">Ctrl + b<\/td>\n<td width=\"160\">\u2318 + b<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">Underline<\/td>\n<td width=\"160\">Ctrl + u<\/td>\n<td width=\"160\">\u2318 + u<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">Italic<\/td>\n<td width=\"160\">Ctrl + i<\/td>\n<td width=\"160\">\u2318 + i<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">Strikethrough<\/td>\n<td width=\"160\">Alt + Shift + 5<\/td>\n<td width=\"160\">Option + Shift + 5<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">Center align<\/td>\n<td width=\"160\">Ctrl + Shift + e<\/td>\n<td width=\"160\">\u2318 + Shift + e<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">Left align<\/td>\n<td width=\"160\">Ctrl + Shift + l<\/td>\n<td width=\"160\">\u2318 + Shift + l<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">Right align<\/td>\n<td width=\"160\">Ctrl + Shift + r<\/td>\n<td width=\"160\">\u2318 + Shift + r<\/td>\n<\/tr>\n<tr>\n<td rowspan=\"2\" width=\"151\">Apply outer border<\/td>\n<td width=\"160\">Alt + Shift + 7<\/td>\n<td width=\"160\">Option + Shift + 7<\/td>\n<\/tr>\n<tr>\n<td width=\"160\">Ctrl + Shift + 7<\/td>\n<td width=\"160\">\u2318 + Shift + 7<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">Apply top border<\/td>\n<td width=\"160\">Alt + Shift + 1<\/td>\n<td width=\"160\">Option + Shift + 1<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">Apply right border<\/td>\n<td width=\"160\">Alt + Shift + 2<\/td>\n<td width=\"160\">Option + Shift + 2<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">Apply bottom border<\/td>\n<td width=\"160\">Alt + Shift + 3<\/td>\n<td width=\"160\">Option + Shift + 3<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">Apply left border<\/td>\n<td width=\"160\">Alt + Shift + 4<\/td>\n<td width=\"160\">Option + Shift + 4<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">Remove borders<\/td>\n<td width=\"160\">Alt + Shift + 6<\/td>\n<td width=\"160\">Option + Shift + 6<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">Insert link<\/td>\n<td width=\"160\">Ctrl + k<\/td>\n<td width=\"160\">\u2318 + k<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">Insert time<\/td>\n<td width=\"160\">Ctrl + Shift + ;<\/td>\n<td width=\"160\">\u2318 + Shift + ;<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">Insert date<\/td>\n<td width=\"160\">Ctrl + ;<\/td>\n<td width=\"160\">\u2318 + ;<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">Insert date and time<\/td>\n<td width=\"160\">Ctrl + Alt + Shift + ;<\/td>\n<td width=\"160\">\u2318 + Option + Shift + ;<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">Format as decimal<\/td>\n<td width=\"160\">Ctrl + Shift + 1<\/td>\n<td width=\"160\">Ctrl + Shift + 1<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">Format as time<\/td>\n<td width=\"160\">Ctrl + Shift + 2<\/td>\n<td width=\"160\">Ctrl + Shift + 2<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">Format as date<\/td>\n<td width=\"160\">Ctrl + Shift + 3<\/td>\n<td width=\"160\">Ctrl + Shift + 3<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">Format as currency<\/td>\n<td width=\"160\">Ctrl + Shift + 4<\/td>\n<td width=\"160\">Ctrl + Shift + 4<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">Format as percentage<\/td>\n<td width=\"160\">Ctrl + Shift + 5<\/td>\n<td width=\"160\">Ctrl + Shift + 5<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">Format as exponent<\/td>\n<td width=\"160\">Ctrl + Shift + 6<\/td>\n<td width=\"160\">Ctrl + Shift + 6<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">Clear formatting<\/td>\n<td width=\"160\">Ctrl + \\<\/td>\n<td width=\"160\">\u2318 + \\<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<h4>Notes and comments<\/h4>\n<table width=\"471\">\n<tbody>\n<tr>\n<td width=\"151\"><strong>Action<\/strong><\/td>\n<td width=\"160\"><strong>Windows<\/strong><\/td>\n<td width=\"160\"><strong>Mac<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"151\">Insert\/edit note<\/td>\n<td width=\"160\">Shift + F2<\/td>\n<td width=\"160\">Shift + F2<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">Insert\/edit comment<\/td>\n<td width=\"160\">Ctrl + Alt + m<\/td>\n<td width=\"160\">\u2318 + Option + m<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">Open comment discussion thread<\/td>\n<td width=\"160\">Ctrl + Alt + Shift + a<\/td>\n<td width=\"160\">\u2318 + Option + Shift + a<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">Enter current comment<\/td>\n<td width=\"160\">holding\u00a0Ctrl + Alt, press\u00a0e\u00a0then\u00a0c<\/td>\n<td width=\"160\">holding\u00a0Ctrl + \u2318, press\u00a0e\u00a0then\u00a0c<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">Move to next comment<\/td>\n<td width=\"160\">holding\u00a0Ctrl + Alt, press\u00a0n\u00a0then\u00a0c<\/td>\n<td width=\"160\">holding\u00a0Ctrl + \u2318, press\u00a0n\u00a0then\u00a0c<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">Move to previous comment<\/td>\n<td width=\"160\">holding\u00a0Ctrl + Alt, press\u00a0p\u00a0then\u00a0c<\/td>\n<td width=\"160\">holding\u00a0Ctrl + \u2318, press\u00a0p\u00a0then\u00a0c<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p>That was the list of most commonly used Google Sheets keyboard shortcuts. Should you need more of these hacks to maximize your productivity in Google Sheets, check out our blog post with <a href=\"https:\/\/www.sheetgo.com\/blog\/spreadsheets-tips\/10-tips-tricks-maximize-google-sheets\/\" target=\"_blank\" rel=\"noopener noreferrer\">10 spreadsheet tips and tricks.\u00a0<\/a><\/p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]\n","protected":false},"excerpt":{"rendered":"<p>We all know the disruption the mouse enabled graphical user interface brought to the world. It was revolutionary. Without a doubt, navigation within the applications has become a lot more intuitive. However, for a regular user, using a mouse to work on Google Sheets can slow down productivity. Because, keyboard strokes take much less time [&hellip;]<\/p>\n","protected":false},"author":40,"featured_media":7445,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"We all know the disruption the mouse enabled graphical user interface brought to the world. It was revolutionary. Without a doubt, navigation within the applications has become a lot more intuitive. However, for a regular user, using a mouse to work on Google Sheets can slow down productivity. Because, keyboard strokes take much less time to perform than using the mouse to navigate and click. In this article, we list down the most useful Google Sheets keyboard shortcuts. Since, working with the keyboard is much faster than with the mouse.\n<h3>Google Sheets Keyboard Shortcuts<\/h3>\nThere are a lot of Google Sheets keyboard shortcuts available for us to be able to productively accomplish our day to day tasks. You may access the comprehensive list <a href=\"https:\/\/support.google.com\/docs\/answer\/181110?co=GENIE.Platform%3DDesktop&amp;hl=en&amp;oco=1\" target=\"_blank\" rel=\"noopener noreferrer\">here<\/a>. But, we list below the most useful ones below.\n<h4>File actions<\/h4>\n<table width=\"605\">\n<tbody>\n<tr>\n<td width=\"285\"><strong>Action<\/strong><\/td>\n<td width=\"160\"><strong>Windows<\/strong><\/td>\n<td width=\"160\"><strong>Mac<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"285\">Save\n(every change is saved automatically in Drive)<\/td>\n<td width=\"160\">Ctrl + s<\/td>\n<td width=\"160\">\u2318 + s<\/td>\n<\/tr>\n<tr>\n<td width=\"285\">Open<\/td>\n<td width=\"160\">Ctrl + o<\/td>\n<td width=\"160\">\u2318 + o<\/td>\n<\/tr>\n<tr>\n<td width=\"285\">Print<\/td>\n<td width=\"160\">Ctrl + p<\/td>\n<td width=\"160\">\u2318 + p<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h4>Data handling<\/h4>\n<table width=\"471\">\n<tbody>\n<tr>\n<td width=\"151\"><strong>Action<\/strong><\/td>\n<td width=\"160\"><strong>Windows<\/strong><\/td>\n<td width=\"160\"><strong>Mac<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"151\">Copy<\/td>\n<td width=\"160\">Ctrl + c<\/td>\n<td width=\"160\">\u2318 + c<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">Cut<\/td>\n<td width=\"160\">Ctrl + x<\/td>\n<td width=\"160\">\u2318 + x<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">Paste<\/td>\n<td width=\"160\">Ctrl + v<\/td>\n<td width=\"160\">\u2318 + v<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">Paste values only<\/td>\n<td width=\"160\">Ctrl + Shift + v<\/td>\n<td width=\"160\">\u2318 + Shift + v<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">Undo<\/td>\n<td width=\"160\">Ctrl + z<\/td>\n<td width=\"160\">\u2318 + z<\/td>\n<\/tr>\n<tr>\n<td rowspan=\"3\" width=\"151\">Redo<\/td>\n<td width=\"160\">Ctrl + y<\/td>\n<td width=\"160\">\u2318 + y<\/td>\n<\/tr>\n<tr>\n<td width=\"160\">Ctrl + Shift + z<\/td>\n<td width=\"160\">\u2318 + Shift + z<\/td>\n<\/tr>\n<tr>\n<td width=\"160\">F4<\/td>\n<td width=\"160\">Fn + F4<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">Find<\/td>\n<td width=\"160\">Ctrl + f<\/td>\n<td width=\"160\">\u2318 + f<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">Find and replace<\/td>\n<td width=\"160\">Ctrl + h<\/td>\n<td width=\"160\">\u2318 + Shift + h<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">Fill range<\/td>\n<td width=\"160\">Ctrl + Enter<\/td>\n<td width=\"160\">\u2318 + Enter<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">Fill down<\/td>\n<td width=\"160\">Ctrl + d<\/td>\n<td width=\"160\">\u2318 + d<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">Fill right<\/td>\n<td width=\"160\">Ctrl + r<\/td>\n<td width=\"160\">\u2318 + r<\/td>\n<\/tr>\n<tr>\n<td rowspan=\"2\" width=\"151\">Select all<\/td>\n<td width=\"160\">Ctrl + a<\/td>\n<td width=\"160\">\u2318 + a<\/td>\n<\/tr>\n<tr>\n<td width=\"160\">Ctrl + Shift + Space<\/td>\n<td width=\"160\">\u2318 + Shift + Space<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">Select column<\/td>\n<td width=\"160\">Ctrl + Space<\/td>\n<td width=\"160\">Ctrl + Space<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">Select row<\/td>\n<td width=\"160\">Shift + Space<\/td>\n<td width=\"160\">Shift + Space<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n&nbsp;\n<h4>Navigation<\/h4>\n<table width=\"658\">\n<tbody>\n<tr>\n<td width=\"242\"><strong>Action<\/strong><\/td>\n<td width=\"201\"><strong>Windows<\/strong><\/td>\n<td width=\"215\"><strong>Mac<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"242\">Move to beginning of row<\/td>\n<td width=\"201\">Home<\/td>\n<td width=\"215\">Fn + Left arrow<\/td>\n<\/tr>\n<tr>\n<td width=\"242\">Move to beginning of sheet<\/td>\n<td width=\"201\">Ctrl + Home<\/td>\n<td width=\"215\">\u2318 + Fn + Left arrow<\/td>\n<\/tr>\n<tr>\n<td width=\"242\">Move to end of row<\/td>\n<td width=\"201\">End<\/td>\n<td width=\"215\">Fn + Right arrow<\/td>\n<\/tr>\n<tr>\n<td width=\"242\">Move to end of sheet<\/td>\n<td width=\"201\">Ctrl + End<\/td>\n<td width=\"215\">\u2318 + Fn + Right arrow<\/td>\n<\/tr>\n<tr>\n<td width=\"242\">Scroll to active cell<\/td>\n<td width=\"201\">Ctrl + Backspace<\/td>\n<td width=\"215\">\u2318 + Backspace<\/td>\n<\/tr>\n<tr>\n<td width=\"242\">Move to next sheet<\/td>\n<td width=\"201\">Ctrl + Shift + Page Down<\/td>\n<td width=\"215\">\u2318 + Shift + Fn + Down arrow<\/td>\n<\/tr>\n<tr>\n<td width=\"242\">Move to previous sheet<\/td>\n<td width=\"201\">Ctrl + Shift + Page Up<\/td>\n<td width=\"215\">\u2318 + Shift + Fn + Up arrow<\/td>\n<\/tr>\n<tr>\n<td width=\"242\">Display list of sheets<\/td>\n<td width=\"201\">Alt + Shift + k<\/td>\n<td width=\"215\">Option + Shift + k<\/td>\n<\/tr>\n<tr>\n<td width=\"242\">Open hyperlink<\/td>\n<td width=\"201\">Alt + Enter<\/td>\n<td width=\"215\">Option + Enter<\/td>\n<\/tr>\n<tr>\n<td width=\"242\">Open Explore<\/td>\n<td width=\"201\">Alt + Shift + x<\/td>\n<td width=\"215\">Option + Shift + x<\/td>\n<\/tr>\n<tr>\n<td width=\"242\">Move focus out of spreadsheet<\/td>\n<td width=\"201\">Ctrl + Alt + Shift + m<\/td>\n<td width=\"215\">Ctrl + \u2318 + Shift + m<\/td>\n<\/tr>\n<tr>\n<td width=\"242\">Open drop-down menu on filtered cell<\/td>\n<td width=\"201\">Ctrl + Alt + r<\/td>\n<td width=\"215\">Ctrl + \u2318 + r<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n&nbsp;\n<h4>Formatting<\/h4>\n<table width=\"471\">\n<tbody>\n<tr>\n<td width=\"151\"><strong>Action<\/strong><\/td>\n<td width=\"160\"><strong>Windows<\/strong><\/td>\n<td width=\"160\"><strong>Mac<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"151\">Bold<\/td>\n<td width=\"160\">Ctrl + b<\/td>\n<td width=\"160\">\u2318 + b<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">Underline<\/td>\n<td width=\"160\">Ctrl + u<\/td>\n<td width=\"160\">\u2318 + u<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">Italic<\/td>\n<td width=\"160\">Ctrl + i<\/td>\n<td width=\"160\">\u2318 + i<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">Strikethrough<\/td>\n<td width=\"160\">Alt + Shift + 5<\/td>\n<td width=\"160\">Option + Shift + 5<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">Center align<\/td>\n<td width=\"160\">Ctrl + Shift + e<\/td>\n<td width=\"160\">\u2318 + Shift + e<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">Left align<\/td>\n<td width=\"160\">Ctrl + Shift + l<\/td>\n<td width=\"160\">\u2318 + Shift + l<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">Right align<\/td>\n<td width=\"160\">Ctrl + Shift + r<\/td>\n<td width=\"160\">\u2318 + Shift + r<\/td>\n<\/tr>\n<tr>\n<td rowspan=\"2\" width=\"151\">Apply outer border<\/td>\n<td width=\"160\">Alt + Shift + 7<\/td>\n<td width=\"160\">Option + Shift + 7<\/td>\n<\/tr>\n<tr>\n<td width=\"160\">Ctrl + Shift + 7<\/td>\n<td width=\"160\">\u2318 + Shift + 7<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">Apply top border<\/td>\n<td width=\"160\">Alt + Shift + 1<\/td>\n<td width=\"160\">Option + Shift + 1<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">Apply right border<\/td>\n<td width=\"160\">Alt + Shift + 2<\/td>\n<td width=\"160\">Option + Shift + 2<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">Apply bottom border<\/td>\n<td width=\"160\">Alt + Shift + 3<\/td>\n<td width=\"160\">Option + Shift + 3<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">Apply left border<\/td>\n<td width=\"160\">Alt + Shift + 4<\/td>\n<td width=\"160\">Option + Shift + 4<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">Remove borders<\/td>\n<td width=\"160\">Alt + Shift + 6<\/td>\n<td width=\"160\">Option + Shift + 6<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">Insert link<\/td>\n<td width=\"160\">Ctrl + k<\/td>\n<td width=\"160\">\u2318 + k<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">Insert time<\/td>\n<td width=\"160\">Ctrl + Shift + ;<\/td>\n<td width=\"160\">\u2318 + Shift + ;<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">Insert date<\/td>\n<td width=\"160\">Ctrl + ;<\/td>\n<td width=\"160\">\u2318 + ;<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">Insert date and time<\/td>\n<td width=\"160\">Ctrl + Alt + Shift + ;<\/td>\n<td width=\"160\">\u2318 + Option + Shift + ;<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">Format as decimal<\/td>\n<td width=\"160\">Ctrl + Shift + 1<\/td>\n<td width=\"160\">Ctrl + Shift + 1<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">Format as time<\/td>\n<td width=\"160\">Ctrl + Shift + 2<\/td>\n<td width=\"160\">Ctrl + Shift + 2<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">Format as date<\/td>\n<td width=\"160\">Ctrl + Shift + 3<\/td>\n<td width=\"160\">Ctrl + Shift + 3<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">Format as currency<\/td>\n<td width=\"160\">Ctrl + Shift + 4<\/td>\n<td width=\"160\">Ctrl + Shift + 4<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">Format as percentage<\/td>\n<td width=\"160\">Ctrl + Shift + 5<\/td>\n<td width=\"160\">Ctrl + Shift + 5<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">Format as exponent<\/td>\n<td width=\"160\">Ctrl + Shift + 6<\/td>\n<td width=\"160\">Ctrl + Shift + 6<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">Clear formatting<\/td>\n<td width=\"160\">Ctrl + <\/td>\n<td width=\"160\">\u2318 + <\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n&nbsp;\n<h4>Notes and comments<\/h4>\n<table width=\"471\">\n<tbody>\n<tr>\n<td width=\"151\"><strong>Action<\/strong><\/td>\n<td width=\"160\"><strong>Windows<\/strong><\/td>\n<td width=\"160\"><strong>Mac<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"151\">Insert\/edit note<\/td>\n<td width=\"160\">Shift + F2<\/td>\n<td width=\"160\">Shift + F2<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">Insert\/edit comment<\/td>\n<td width=\"160\">Ctrl + Alt + m<\/td>\n<td width=\"160\">\u2318 + Option + m<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">Open comment discussion thread<\/td>\n<td width=\"160\">Ctrl + Alt + Shift + a<\/td>\n<td width=\"160\">\u2318 + Option + Shift + a<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">Enter current comment<\/td>\n<td width=\"160\">holding&nbsp;Ctrl + Alt, press&nbsp;e&nbsp;then&nbsp;c<\/td>\n<td width=\"160\">holding&nbsp;Ctrl + \u2318, press&nbsp;e&nbsp;then&nbsp;c<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">Move to next comment<\/td>\n<td width=\"160\">holding&nbsp;Ctrl + Alt, press&nbsp;n&nbsp;then&nbsp;c<\/td>\n<td width=\"160\">holding&nbsp;Ctrl + \u2318, press&nbsp;n&nbsp;then&nbsp;c<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">Move to previous comment<\/td>\n<td width=\"160\">holding&nbsp;Ctrl + Alt, press&nbsp;p&nbsp;then&nbsp;c<\/td>\n<td width=\"160\">holding&nbsp;Ctrl + \u2318, press&nbsp;p&nbsp;then&nbsp;c<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n&nbsp;\n\nThat was the list of most commonly used Google Sheets keyboard shortcuts. Should you need it, here is the <a href=\"https:\/\/support.google.com\/docs\/answer\/181110\" target=\"_blank\" rel=\"noopener noreferrer\">comprehensive list<\/a>.","_et_gb_content_width":"","footnotes":""},"categories":[37],"tags":[39,28],"class_list":["post-7438","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-sheets-features","tag-connections-t","tag-spreadsheets"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/7438","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/users\/40"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/comments?post=7438"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/7438\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media\/7445"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media?parent=7438"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/categories?post=7438"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/tags?post=7438"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}