{"id":8906,"date":"2023-06-19T08:32:57","date_gmt":"2023-06-19T08:32:57","guid":{"rendered":"https:\/\/gibbon.edugorilla.com\/blog\/?p=8906"},"modified":"2023-08-08T10:17:52","modified_gmt":"2023-08-08T10:17:52","slug":"google-sheet-shortcuts","status":"publish","type":"post","link":"https:\/\/gibbon.edugorilla.com\/blog\/google-sheet-shortcuts\/","title":{"rendered":"Complete Google Sheet Shortcuts for Teachers"},"content":{"rendered":"\n<p>Google Sheets is as a powerful online spreadsheet application and has indeed revolutionized the way people use spreadsheets for their work. Google sheets has replace traditional offline software such as Excel in several niche domains. For teachers Google Sheets is a versatile tool that holds significant importance in various aspects of one\u2019s work \u2013 management, grading, visualization, charting, attendance tracking, and so on.<\/p>\n\n\n\n<p>Solution providers such as\u00a0<mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-cyan-blue-color\"><a rel=\"noreferrer noopener\" href=\"https:\/\/gibbon.edugorilla.com\/blog\/\" data-type=\"URL\" data-id=\"https:\/\/gibbon.edugorilla.com\/blog\/\" target=\"_blank\">Gibbon<\/a> <\/mark>do provide automations for the above listed tasks, but still educators must learn few important keyboard shortcuts for google sheets to speed up their work. To complement our important <a rel=\"noreferrer noopener\" href=\"https:\/\/gibbon.edugorilla.com\/blog\/?p=9124\" data-type=\"URL\" data-id=\"https:\/\/gibbon.edugorilla.com\/blog\/?p=9124\" target=\"_blank\"><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-cyan-blue-color\">Google Doc Important Shortcuts<\/mark><\/a>, and <a rel=\"noreferrer noopener\" href=\"https:\/\/gibbon.edugorilla.com\/blog\/?p=9174\" data-type=\"URL\" data-id=\"https:\/\/gibbon.edugorilla.com\/blog\/?p=9174\" target=\"_blank\"><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-cyan-blue-color\">Keyboard Shortcuts for Google Slides<\/mark><\/a>, important Google Sheet shortcuts are given below.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-red-color\">#1 Google Sheet Keyboard Shortcuts for Windows<\/mark><\/h2>\n\n\n\n<p>Teachers who are using Windows operating system must refer to these Google Sheet shortcuts:<\/p>\n\n\n\n<h4 class=\"has-text-align-center wp-block-heading\"><strong>Most Used Google Sheet Shortcuts<\/strong><\/h4>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td>Select column<\/td><td><strong>Ctrl + Space<\/strong><\/td><\/tr><tr><td>Select row<\/td><td><strong>Shift + Space<\/strong><\/td><\/tr><tr><td>Select all<\/td><td><strong>Ctrl + a<\/strong><br><strong>Ctrl + Shift + Space<\/strong><\/td><\/tr><tr><td>Undo<\/td><td><strong>Ctrl + z<\/strong><\/td><\/tr><tr><td>Redo<\/td><td><strong>Ctrl + y<\/strong><br><strong>Ctrl + Shift + z<\/strong><br><strong>F4<\/strong><\/td><\/tr><tr><td>Find<\/td><td><strong>Ctrl + f<\/strong><\/td><\/tr><tr><td>Find and replace<\/td><td><strong>Ctrl + h<\/strong><\/td><\/tr><tr><td>Fill range<\/td><td><strong>Ctrl + Enter<\/strong><\/td><\/tr><tr><td>Fill down<\/td><td><strong>Ctrl + d<\/strong><\/td><\/tr><tr><td>Fill right<\/td><td><strong>Ctrl + r<\/strong><\/td><\/tr><tr><td>Save<\/td><td><strong>Ctrl + s<\/strong><\/td><\/tr><tr><td>Open<\/td><td><strong>Ctrl + o<\/strong><\/td><\/tr><tr><td>Print<\/td><td><strong>Ctrl + p<\/strong><\/td><\/tr><tr><td>Copy<\/td><td><strong>Ctrl + c<\/strong><\/td><\/tr><tr><td>Cut<\/td><td><strong>Ctrl + x<\/strong><\/td><\/tr><tr><td>Paste<\/td><td><strong>Ctrl + v<\/strong><\/td><\/tr><tr><td>Paste values only<\/td><td><strong>Ctrl + Shift + v<\/strong><\/td><\/tr><tr><td>Show common keyboard shortcuts<\/td><td><strong>Ctrl + \/<\/strong><\/td><\/tr><tr><td>Insert new sheet<\/td><td><strong>Shift + F11<\/strong><\/td><\/tr><tr><td>Compact controls<\/td><td><strong>Ctrl + Shift + f<\/strong><\/td><\/tr><tr><td>Input tools on\/off<\/td><td><strong>Ctrl + Shift + k<\/strong><\/td><\/tr><tr><td>Select input tools<\/td><td><strong>Ctrl + Alt + Shift + k<\/strong><\/td><\/tr><tr><td>Tool finder&nbsp;<\/td><td><strong>Alt + \/<\/strong><\/td><\/tr><tr><td>Rename sheet<\/td><td><strong>Alt + 1<\/strong><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><a href=\"https:\/\/gibbon.edugorilla.com\/#get_started\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"231\" src=\"https:\/\/gibbon.edugorilla.com\/blog\/wp-content\/uploads\/2023\/03\/8-1024x231.jpg\" alt=\"\" class=\"wp-image-7300\" srcset=\"https:\/\/gibbon.edugorilla.com\/blog\/wp-content\/uploads\/2023\/03\/8-1024x231.jpg 1024w, https:\/\/gibbon.edugorilla.com\/blog\/wp-content\/uploads\/2023\/03\/8-300x68.jpg 300w, https:\/\/gibbon.edugorilla.com\/blog\/wp-content\/uploads\/2023\/03\/8.jpg 1170w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><figcaption>Hurry! Book a FREE Demo<\/figcaption><\/figure>\n\n\n\n<h4 class=\"has-text-align-center wp-block-heading\"><strong>Most Used Google Sheet Shortcuts<\/strong> for Formatting Cells<\/h4>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td>Bold<\/td><td><strong>Ctrl + b<\/strong><\/td><\/tr><tr><td>Underline<\/td><td><strong>Ctrl + u<\/strong><\/td><\/tr><tr><td>Italic<\/td><td><strong>Ctrl + i<\/strong><\/td><\/tr><tr><td>Strikethrough<\/td><td><strong>Alt + Shift + 5<\/strong><\/td><\/tr><tr><td>Center align<\/td><td><strong>Ctrl + Shift + e<\/strong><\/td><\/tr><tr><td>Left align<\/td><td><strong>Ctrl + Shift + l<\/strong><\/td><\/tr><tr><td>Right align<\/td><td><strong>Ctrl + Shift + r<\/strong><\/td><\/tr><tr><td>Apply top border<\/td><td><strong>Alt + Shift + 1<\/strong><\/td><\/tr><tr><td>Apply right border<\/td><td><strong>Alt + Shift + 2<\/strong><\/td><\/tr><tr><td>Apply bottom border<\/td><td><strong>Alt + Shift + 3<\/strong><\/td><\/tr><tr><td>Apply left border<\/td><td><strong>Alt + Shift + 4<\/strong><\/td><\/tr><tr><td>Remove borders<\/td><td><strong>Alt + Shift + 6<\/strong><\/td><\/tr><tr><td>Apply outer border<\/td><td><strong>Alt + Shift + 7<\/strong><strong>Ctrl + Shift + 7<\/strong><\/td><\/tr><tr><td>Insert link<\/td><td><strong>Ctrl + k<\/strong><\/td><\/tr><tr><td>Insert time<\/td><td><strong>Ctrl + Shift + ;<\/strong><\/td><\/tr><tr><td>Insert date<\/td><td><strong>Ctrl + ;<\/strong><\/td><\/tr><tr><td>Insert date and time<\/td><td><strong>Ctrl + Alt + Shift + ;<\/strong><\/td><\/tr><tr><td>Format as decimal<\/td><td><strong>Ctrl + Shift + 1<\/strong><\/td><\/tr><tr><td>Format as time<\/td><td><strong>Ctrl + Shift + 2<\/strong><\/td><\/tr><tr><td>Format as date<\/td><td><strong>Ctrl + Shift + 3<\/strong><\/td><\/tr><tr><td>Format as currency<\/td><td><strong>Ctrl + Shift + 4<\/strong><\/td><\/tr><tr><td>Format as percentage<\/td><td><strong>Ctrl + Shift + 5<\/strong><\/td><\/tr><tr><td>Format as exponent<\/td><td><strong>Ctrl + Shift + 6<\/strong><\/td><\/tr><tr><td>Clear formatting<\/td><td><strong>Ctrl + \\<\/strong><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h4 class=\"has-text-align-center wp-block-heading\"><strong>Google Sheet Shortcuts<\/strong> for Navigating Spreadsheets<\/h4>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td>Move to beginning of row<\/td><td><strong>Home<\/strong><\/td><\/tr><tr><td>Move to beginning of sheet<\/td><td><strong>Ctrl + Home<\/strong><\/td><\/tr><tr><td>Move to end of row<\/td><td><strong>End<\/strong><\/td><\/tr><tr><td>Move to end of sheet<\/td><td><strong>Ctrl + End<\/strong><\/td><\/tr><tr><td>Scroll to active cell<\/td><td><strong>Ctrl + Backspace<\/strong><\/td><\/tr><tr><td>Move to next sheet<\/td><td><strong>Alt + Down Arrow<\/strong><\/td><\/tr><tr><td>Move to previous sheet<\/td><td><strong>Alt + Up Arrow<\/strong><\/td><\/tr><tr><td>Display list of sheets<\/td><td><strong>Alt + Shift + k<\/strong><\/td><\/tr><tr><td>Open hyperlink<\/td><td><strong>Alt + Enter<\/strong><\/td><\/tr><tr><td>Open Explore<\/td><td><strong>Alt + Shift + x<\/strong><\/td><\/tr><tr><td>Go to side panel<\/td><td><strong>Ctrl + Alt + .<\/strong><br><strong>Ctrl + Alt + ,<\/strong><\/td><\/tr><tr><td>Move focus out of spreadsheet<\/td><td><strong>Ctrl + Alt + Shift + m<\/strong><\/td><\/tr><tr><td>Move to quicksum<br><em>(when a range of cells is selected)<\/em><\/td><td><strong>Alt + Shift + q<\/strong><\/td><\/tr><tr><td>Move focus to popup<br><em>(for links, bookmarks, and images)<\/em><\/td><td>holding&nbsp;<strong>Ctrl + Alt<\/strong>, press&nbsp;<strong>e<\/strong>&nbsp;then&nbsp;<strong>p<\/strong><\/td><\/tr><tr><td>Open drop-down menu on filtered cell<\/td><td><strong>Ctrl + Alt + r<\/strong><\/td><\/tr><tr><td>Open revision history<\/td><td><strong>Ctrl + Alt + Shift + h<\/strong><\/td><\/tr><tr><td>Close drawing editor<\/td><td><strong>Shift + Esc<\/strong><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><a href=\"https:\/\/gibbon.edugorilla.com\/#get_started\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"231\" src=\"https:\/\/gibbon.edugorilla.com\/blog\/wp-content\/uploads\/2023\/03\/8-1024x231.jpg\" alt=\"\" class=\"wp-image-7300\" srcset=\"https:\/\/gibbon.edugorilla.com\/blog\/wp-content\/uploads\/2023\/03\/8-1024x231.jpg 1024w, https:\/\/gibbon.edugorilla.com\/blog\/wp-content\/uploads\/2023\/03\/8-300x68.jpg 300w, https:\/\/gibbon.edugorilla.com\/blog\/wp-content\/uploads\/2023\/03\/8.jpg 1170w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><figcaption>Hurry! Book a FREE Demo<\/figcaption><\/figure>\n\n\n\n<h4 class=\"has-text-align-center wp-block-heading\"><strong>Google Sheet Shortcuts<\/strong> for Menu<\/h4>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td>File menu<\/td><td><em>in Google Chrome:&nbsp;<\/em><strong>Alt + f<\/strong><br><em>other browsers:&nbsp;<\/em><strong>Alt + Shift + f<\/strong><\/td><\/tr><tr><td>Edit menu<\/td><td><em>in Google Chrome:&nbsp;<\/em><strong>Alt + e<\/strong><br><em>other browsers:&nbsp;<\/em><strong>Alt + Shift + e<\/strong><\/td><\/tr><tr><td>View menu<\/td><td><em>in Google Chrome:&nbsp;<\/em><strong>Alt + v<\/strong><br><em>other browsers:&nbsp;<\/em><strong>Alt + Shift + v<\/strong><\/td><\/tr><tr><td>Insert menu<\/td><td><em>in Google Chrome:&nbsp;<\/em><strong>Alt + i<\/strong><br><em>other browsers:&nbsp;<\/em><strong>Alt + Shift + i<\/strong><\/td><\/tr><tr><td>Format menu<\/td><td><em>in Google Chrome:&nbsp;<\/em><strong>Alt + o<\/strong><br><em>other browsers:&nbsp;<\/em><strong>Alt + Shift + o<\/strong><\/td><\/tr><tr><td>Data menu<\/td><td><em>in Google Chrome:&nbsp;<\/em><strong>Alt + d<\/strong><br><em>other browsers:&nbsp;<\/em><strong>Alt + Shift + d<\/strong><\/td><\/tr><tr><td>Tools menu<\/td><td><em>in Google Chrome:&nbsp;<\/em><strong>Alt + t<\/strong><br><em>other browsers:&nbsp;<\/em><strong>Alt + Shift + t<\/strong><\/td><\/tr><tr><td>Open insert menu<\/td><td><strong>Ctrl + Alt + Shift + =&nbsp;<br>Ctrl + Alt + =&nbsp;<\/strong><br>(with cells selected)<\/td><\/tr><tr><td>Open delete menu<\/td><td><strong>Ctrl + Alt + &#8211;<\/strong>&nbsp;(with cells selected)<\/td><\/tr><tr><td>Form menu<br><em>(present when the spreadsheet is connected to a form)<\/em><\/td><td><em>in Google Chrome:&nbsp;<\/em><strong>Alt + m<\/strong><br><em>other browsers:&nbsp;<\/em><strong>Alt + Shift + m<\/strong><\/td><\/tr><tr><td>Add-ons menu<\/td><td><em>in Google Chrome:&nbsp;<\/em><strong>Alt + n<\/strong><br><em>other browsers:&nbsp;<\/em><strong>Alt + Shift + n<\/strong><\/td><\/tr><tr><td>Help menu<\/td><td><em>in Google Chrome:&nbsp;<\/em><strong>Alt + h<\/strong><br><em>other browsers:&nbsp;<\/em><strong>Alt + Shift + h<\/strong><\/td><\/tr><tr><td>Accessibility menu<br><em>(present when screen reader support is enabled)<\/em><\/td><td><em>in Google Chrome:&nbsp;<\/em><strong>Alt + a<\/strong><br><em>other browsers:&nbsp;<\/em><strong>Alt + Shift + a<\/strong><\/td><\/tr><tr><td>Sheet menu<br><em>(copy, delete, and other sheet actions)<\/em><\/td><td><strong>Alt + Shift + s<\/strong><\/td><\/tr><tr><td>Context menu<\/td><td><strong>Ctrl + Shift + \\<br>Shift + F10<\/strong><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h4 class=\"has-text-align-center wp-block-heading\"><strong>Google Sheet Shortcuts<\/strong> for Rows and Columns<\/h4>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td>nsert rows above<\/td><td><strong>Ctrl + Alt + Shift + =<br>Ctrl + Alt + =<\/strong><br>(with rows selected)<em>in Google Chrome:&nbsp;<\/em><strong>Alt + i<\/strong>, then&nbsp;<strong>r<\/strong><br><em>other browsers:&nbsp;<\/em><strong>Alt + Shift + i<\/strong>, then&nbsp;<strong>r<\/strong><\/td><\/tr><tr><td>Insert rows below<\/td><td><em>in Google Chrome:&nbsp;<\/em><strong>Alt + i<\/strong>, then&nbsp;<strong>w<\/strong><br><em>other browsers:&nbsp;<\/em><strong>Alt + Shift + i<\/strong>, then&nbsp;<strong>w<\/strong><\/td><\/tr><tr><td>Insert columns to the left<\/td><td><strong>Ctrl + Alt + Shift + =&nbsp;<br>Ctrl + Alt + =&nbsp;<\/strong><br>(with columns selected)<em>in Google Chrome:&nbsp;<\/em><strong>Alt + i<\/strong>, then&nbsp;<strong>c<\/strong><br><em>other browsers:&nbsp;<\/em><strong>Alt + Shift + i<\/strong>, then&nbsp;<strong>c<\/strong><\/td><\/tr><tr><td>Insert columns to the right<\/td><td><em>in Google Chrome:&nbsp;<\/em><strong>Alt + i<\/strong>, then&nbsp;<strong>o<\/strong><br><em>other browsers:&nbsp;<\/em><strong>Alt + Shift + i<\/strong>, then&nbsp;<strong>o<\/strong><\/td><\/tr><tr><td>Delete rows<\/td><td><strong>Ctrl + Alt + &#8211;<\/strong>&nbsp;(with rows selected)<em>in Google Chrome:&nbsp;<\/em><strong>Alt + e<\/strong>, then&nbsp;<strong>d<\/strong><br><em>other browsers:&nbsp;<\/em><strong>Alt + Shift + e<\/strong>, then&nbsp;<strong>d<\/strong><\/td><\/tr><tr><td>Delete columns<\/td><td><strong>Ctrl + Alt + &#8211;<\/strong>&nbsp;(with columns selected)<em>in Google Chrome:&nbsp;<\/em><strong>Alt + e<\/strong>, then&nbsp;<strong>e<\/strong><br><em>other browsers:&nbsp;<\/em><strong>Alt + Shift + e<\/strong>, then&nbsp;<strong>e<\/strong><\/td><\/tr><tr><td>Hide row<\/td><td><strong>Ctrl + Alt + 9<\/strong><\/td><\/tr><tr><td>Unhide row<\/td><td><strong>Ctrl + Shift + 9<\/strong><\/td><\/tr><tr><td>Hide column<\/td><td><strong>Ctrl + Alt + 0<\/strong><\/td><\/tr><tr><td>Unhide column<\/td><td><strong>Ctrl + Shift + 0<\/strong><\/td><\/tr><tr><td>Group rows or columns<\/td><td><strong>Alt + Shift + Right Arrow<\/strong><\/td><\/tr><tr><td>Ungroup rows or columns<\/td><td><strong>Alt + Shift + Left Arrow<\/strong><\/td><\/tr><tr><td>Expand&nbsp;grouped rows or columns<\/td><td><strong>Alt + Shift + Down Arrow<\/strong><\/td><\/tr><tr><td>Collapse grouped rows or columns<\/td><td><strong>Alt + Shift + Up Arrow<\/strong><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><a href=\"https:\/\/gibbon.edugorilla.com\/#get_started\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"231\" src=\"https:\/\/gibbon.edugorilla.com\/blog\/wp-content\/uploads\/2023\/03\/8-1024x231.jpg\" alt=\"\" class=\"wp-image-7300\" srcset=\"https:\/\/gibbon.edugorilla.com\/blog\/wp-content\/uploads\/2023\/03\/8-1024x231.jpg 1024w, https:\/\/gibbon.edugorilla.com\/blog\/wp-content\/uploads\/2023\/03\/8-300x68.jpg 300w, https:\/\/gibbon.edugorilla.com\/blog\/wp-content\/uploads\/2023\/03\/8.jpg 1170w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><figcaption>Hurry! Book a FREE Demo<\/figcaption><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-red-color\">#2 Google Sheet Keyboard Shortcuts for Android<\/mark><\/h2>\n\n\n\n<p>For teachers who are using Android phones or tablets, the Google Sheet keyboard shortcuts are as follows:<\/p>\n\n\n\n<h4 class=\"has-text-align-center wp-block-heading\"><strong>Most Used Google Sheet Shortcuts<\/strong><\/h4>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th><strong>Action<\/strong><\/th><th><strong>Shortcut<\/strong><\/th><\/tr><\/thead><tbody><tr><td>Select column<\/td><td><strong>Ctrl + Space<\/strong><\/td><\/tr><tr><td>Select row<\/td><td><strong>Shift + Space<\/strong><\/td><\/tr><tr><td>Select all<\/td><td><strong>Ctrl + a<\/strong><br><strong>Ctrl + Shift + Space<\/strong><\/td><\/tr><tr><td>Undo<\/td><td><strong>Ctrl + z<\/strong><\/td><\/tr><tr><td>Redo<\/td><td><strong>Ctrl + y<\/strong><br><strong>Ctrl + Shift + z<\/strong><br><strong>F4<\/strong><\/td><\/tr><tr><td>Find<\/td><td><strong>Ctrl + f<\/strong><\/td><\/tr><tr><td>Find and replace<\/td><td><strong>Ctrl + h<\/strong><\/td><\/tr><tr><td>Fill range<\/td><td><strong>Ctrl + Enter<\/strong><\/td><\/tr><tr><td>Fill down<\/td><td><strong>Ctrl + d<\/strong><\/td><\/tr><tr><td>Fill right<\/td><td><strong>Ctrl + r<\/strong><\/td><\/tr><tr><td>Print<\/td><td><strong>Ctrl + p<\/strong><\/td><\/tr><tr><td>Copy<\/td><td><strong>Ctrl + c<\/strong><\/td><\/tr><tr><td>Cut<\/td><td><strong>Ctrl + x<\/strong><\/td><\/tr><tr><td>Paste<\/td><td><strong>Ctrl + v<\/strong><\/td><\/tr><tr><td>Paste values only<\/td><td><strong>Ctrl + Shift + v<\/strong><\/td><\/tr><tr><td>Paste format only<\/td><td><strong>Ctrl + Alt + v<\/strong><\/td><\/tr><tr><td>Show common keyboard shortcuts<\/td><td><strong>Ctrl + \/<\/strong><\/td><\/tr><tr><td>Insert new sheet<\/td><td><strong>Ctrl + t<\/strong><br><strong>Shift + F11<\/strong><\/td><\/tr><tr><td>Move to sheet at index #<\/td><td><strong>Ctrl + [1-9]<\/strong><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h4 class=\"has-text-align-center wp-block-heading\"><strong>Most Used Google Sheet Shortcuts<\/strong> for Formatting Cells<\/h4>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th><strong>Action<\/strong><\/th><th><strong>Shortcut<\/strong><\/th><\/tr><\/thead><tbody><tr><td>Bold<\/td><td><strong>Ctrl + b<\/strong><\/td><\/tr><tr><td>Underline<\/td><td><strong>Ctrl + u<\/strong><\/td><\/tr><tr><td>Italic<\/td><td><strong>Ctrl + i<\/strong><\/td><\/tr><tr><td>Strikethrough<\/td><td><strong>Alt + Shift + 5<\/strong><\/td><\/tr><tr><td>Center align<\/td><td><strong>Ctrl + Shift + e<\/strong><\/td><\/tr><tr><td>Left align<\/td><td><strong>Ctrl + Shift + l<\/strong><\/td><\/tr><tr><td>Right align<\/td><td><strong>Ctrl + Shift + r<\/strong><\/td><\/tr><tr><td>Apply top border<\/td><td><strong>Alt + Shift + 1<\/strong><\/td><\/tr><tr><td>Apply right border<\/td><td><strong>Alt + Shift + 2<\/strong><\/td><\/tr><tr><td>Apply bottom border<\/td><td><strong>Alt + Shift + 3<\/strong><\/td><\/tr><tr><td>Apply left border<\/td><td><strong>Alt + Shift + 4<\/strong><\/td><\/tr><tr><td>Remove borders<\/td><td><strong>Alt + Shift + 6<\/strong><\/td><\/tr><tr><td>Apply outer border<\/td><td><strong>Alt + Shift + 7<\/strong><br><strong>Ctrl + Shift + 7<\/strong><\/td><\/tr><tr><td>Insert link<\/td><td><strong>Ctrl + k<\/strong><\/td><\/tr><tr><td>Insert time<\/td><td><strong>Ctrl + Shift + ;<\/strong><\/td><\/tr><tr><td>Insert date<\/td><td><strong>Ctrl + ;<\/strong><\/td><\/tr><tr><td>Insert date and time<\/td><td><strong>Ctrl + Alt + Shift + ;<\/strong><\/td><\/tr><tr><td>Format as automatic<\/td><td><strong>Ctrl + Shift + &#8216;<\/strong><\/td><\/tr><tr><td>Format as decimal<\/td><td><strong>Ctrl + Shift + 1<\/strong><\/td><\/tr><tr><td>Format as time<\/td><td><strong>Ctrl + Shift + 2<\/strong><\/td><\/tr><tr><td>Format as date<\/td><td><strong>Ctrl + Shift + 3<\/strong><\/td><\/tr><tr><td>Format as currency<\/td><td><strong>Ctrl + Shift + 4<\/strong><\/td><\/tr><tr><td>Format as percentage<\/td><td><strong>Ctrl + Shift + 5<\/strong><\/td><\/tr><tr><td>Format as exponent<\/td><td><strong>Ctrl + Shift + 6<\/strong><\/td><\/tr><tr><td>Clear formatting<\/td><td><strong>Ctrl + \\<\/strong><\/td><\/tr><tr><td>Insert rows<\/td><td><strong>Ctrl + Alt + =<br>Ctrl + Alt + Shift + =&nbsp;<\/strong><br>(with rows selected)<\/td><\/tr><tr><td>Insert columns<\/td><td><strong>Ctrl + Alt + =<br>Ctrl + Alt + Shift + =&nbsp;<\/strong><br>(with columns selected)<\/td><\/tr><tr><td>Delete rows<\/td><td><strong>Ctrl + Alt + &#8211;<\/strong>&nbsp;(with rows selected)<\/td><\/tr><tr><td>Delete columns<\/td><td><strong>Ctrl + Alt + &#8211;<\/strong>&nbsp;(with columns selected)<\/td><\/tr><tr><td>Hide row<\/td><td><strong>Ctrl + Alt + 9<\/strong><\/td><\/tr><tr><td>Unhide row<\/td><td><strong>Ctrl + Shift + 9<\/strong><\/td><\/tr><tr><td>Hide column<\/td><td><strong>Ctrl + Alt + 0<\/strong><\/td><\/tr><tr><td>Unhide column<\/td><td><strong>Ctrl + Shift + 0<\/strong><\/td><\/tr><tr><td>Group rows or columns<\/td><td><strong>Alt + Shift + Right arrow<\/strong><\/td><\/tr><tr><td>Ungroup rows or columns<\/td><td><strong>Alt + Shift + Left arrow<\/strong><\/td><\/tr><tr><td>Expand grouped rows or columns<\/td><td><strong>Alt + Shift + Down arrow<\/strong><\/td><\/tr><tr><td>Collapse grouped rows or columns<\/td><td><strong>Alt + Shift + Up arrow<\/strong><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><a href=\"https:\/\/gibbon.edugorilla.com\/#get_started\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"231\" src=\"https:\/\/gibbon.edugorilla.com\/blog\/wp-content\/uploads\/2023\/03\/8-1024x231.jpg\" alt=\"\" class=\"wp-image-7300\" srcset=\"https:\/\/gibbon.edugorilla.com\/blog\/wp-content\/uploads\/2023\/03\/8-1024x231.jpg 1024w, https:\/\/gibbon.edugorilla.com\/blog\/wp-content\/uploads\/2023\/03\/8-300x68.jpg 300w, https:\/\/gibbon.edugorilla.com\/blog\/wp-content\/uploads\/2023\/03\/8.jpg 1170w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><figcaption>Hurry! Book a FREE Demo<\/figcaption><\/figure>\n\n\n\n<h4 class=\"has-text-align-center wp-block-heading\"><strong>Google Sheet Shortcuts<\/strong> for Navigating Spreadsheets<\/h4>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td>Move to section boundary<\/td><td><strong>Ctrl + Arrow keys<\/strong><\/td><\/tr><tr><td>Select from current position to section boundary<\/td><td><strong>Ctrl + Shift + Arrow keys<\/strong><\/td><\/tr><tr><td>Scroll to active cell<\/td><td><strong>Ctrl + Backspace<\/strong><\/td><\/tr><tr><td>Move to next sheet<\/td><td><strong>Ctrl + Tab<\/strong><br><strong>Alt + Down arrow<\/strong><br><strong>Ctrl + Shift + Page Down<\/strong><\/td><\/tr><tr><td>Move to previous sheet<\/td><td><strong>Ctrl + Shift + Tab<\/strong><br><strong>Alt + Up arrow<\/strong><br><strong>Ctrl + Shift + Page Up<\/strong><\/td><\/tr><tr><td>Display list of sheets<\/td><td><strong>Alt + Shift + k<\/strong><\/td><\/tr><tr><td>Open hyperlink<\/td><td><strong>Alt + Enter<\/strong><\/td><\/tr><tr><td>Open Explore<\/td><td><strong>Alt + Shift + x<\/strong><\/td><\/tr><tr><td>Open menu on filtered cell<\/td><td><strong>Ctrl + Alt + Shift + r<\/strong><br><strong>Ctrl + Alt + r<\/strong><\/td><\/tr><tr><td>Move to beginning of row<\/td><td><strong>Home<\/strong><\/td><\/tr><tr><td>Move to beginning of sheet<\/td><td><strong>Ctrl + Home<\/strong><\/td><\/tr><tr><td>Move to end of row<\/td><td><strong>End<\/strong><\/td><\/tr><tr><td>Move to end of sheet<\/td><td><strong>Ctrl + End<\/strong><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h4 class=\"has-text-align-center wp-block-heading\"><strong>Google Sheet Shortcuts<\/strong> for Using Formula<\/h4>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><th><strong>Action<\/strong><\/th><th><strong>Shortcut<\/strong><\/th><\/tr><tr><td>Insert array formula<\/td><td><strong>Ctrl + Shift + Enter<\/strong><\/td><\/tr><tr><td>Show expanded function help&nbsp;<em>(when entering a formula)<\/em><\/td><td><strong>F1<\/strong><\/td><\/tr><tr><td>Toggle formula range selection&nbsp;<em>(when entering a formula)<\/em><\/td><td><strong>F2<br>Ctrl + e<\/strong><\/td><\/tr><tr><td>Absolute\/relative range references&nbsp;<em>(when entering a formula)<\/em><\/td><td><strong>F4<\/strong><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-red-color\">More Google Sheet Keyboard Shortcuts<\/mark><\/h2>\n\n\n\n<p>Despite the long list given above, there are many more keyboard shortcuts available for Google Sheets. The link for them is given below.<\/p>\n\n\n\n<p class=\"has-text-align-center has-background\" style=\"background-color:#cae4f7\"><a rel=\"noreferrer noopener\" href=\"https:\/\/support.google.com\/docs\/answer\/181110?hl=en&amp;co=GENIE.Platform%3DDesktop\" data-type=\"URL\" data-id=\"https:\/\/support.google.com\/docs\/answer\/181110?hl=en&amp;co=GENIE.Platform%3DDesktop\" target=\"_blank\">Google Sheet Keyboard Shortcuts<\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-red-color\">Google Editor Suit Shortcuts<\/mark><\/h2>\n\n\n\n<p>Google has its own software suit for workspace productivity &#8211; Google Editor Suit. It comprises of Google Sheet, Google Docs, Google Slides, Google Drawings, Google Form, etc. The shortcuts for Google productivity software are given below.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><a rel=\"noreferrer noopener\" href=\"https:\/\/gibbon.edugorilla.com\/blog\/?p=9124\" data-type=\"URL\" data-id=\"https:\/\/gibbon.edugorilla.com\/blog\/?p=9124\" target=\"_blank\"><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-cyan-blue-color\">Google Docs Shortcuts<\/mark><\/a><\/li><li><a href=\"https:\/\/gibbon.edugorilla.com\/blog\/?p=9174\" data-type=\"URL\" data-id=\"https:\/\/gibbon.edugorilla.com\/blog\/?p=9174\" target=\"_blank\" rel=\"noreferrer noopener\"><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-cyan-blue-color\">Google Slides Shortcut<\/mark><\/a><\/li><\/ul>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-red-color\">About Gibbon<\/mark><\/h2>\n\n\n\n<p><a rel=\"noreferrer noopener\" href=\"https:\/\/gibbon.edugorilla.com\/?utm_source=Gibbon+Blog&amp;utm_medium=Gibbon&amp;utm_campaign=Gibbon+Blog+Articles&amp;utm_term=essentials+online+tools+for+teachers\" target=\"_blank\">Gibbon<\/a>&nbsp;is a Plug and Play solution offered by&nbsp;<a rel=\"noreferrer noopener\" href=\"https:\/\/testseries.edugorilla.com\/?utm_source=Gibbon+Blog&amp;utm_medium=EduGorilla&amp;utm_campaign=Gibbon+Blog+Articles&amp;utm_term=essentials+online+tools+for+teachers\" target=\"_blank\">EduGorilla<\/a>, for anyone with a skill to teach. Gibbon helps you to take your classes online and earn independently. Gibbon is Trusted by 3000+ Brands, 10000+ Institutes, 15000+ Creators and 20000+ Educators for Increasing their Revenue by 25X. It\u2019s about time you increase yours.<\/p>\n\n\n\n<p>All the features of&nbsp;<strong>Gibbon Plug &amp; Play solution<\/strong>, are given below.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td class=\"has-text-align-center\" data-align=\"center\"><a href=\"https:\/\/gibbon.edugorilla.com\/blog\/scale-your-online-teaching-business-with-whitelabel-app-website\/\" target=\"_blank\" rel=\"noreferrer noopener\">White Label Website &amp; App<\/a><\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\"><a href=\"https:\/\/gibbon.edugorilla.com\/blog\/create-video-course-by-conducting-recording-live-class-with-gibbon\/\" target=\"_blank\" rel=\"noreferrer noopener\">Conduct &amp; Record Live Classes<\/a><\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\"><a href=\"https:\/\/gibbon.edugorilla.com\/blog\/create-sell-video-course-with-your-own-video-course-platform\/\" target=\"_blank\" rel=\"noreferrer noopener\">Create &amp; Sell Video Course<\/a><\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\"><a href=\"https:\/\/gibbon.edugorilla.com\/blog\/gibbon-live-proctored-exam-feature\/\" target=\"_blank\" rel=\"noreferrer noopener\">LIVE Proctoring Examination<\/a><\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\"><a href=\"https:\/\/gibbon.edugorilla.com\/blog\/gibbons-white-labeled-books-notes\/\" target=\"_blank\" rel=\"noreferrer noopener\">Branded Study Notes\/Book<\/a><\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\"><a href=\"https:\/\/gibbon.edugorilla.com\/blog\/?p=7301\" target=\"_blank\" rel=\"noreferrer noopener\">Analytics &amp; Reporting (Online Assessment)<\/a><\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\"><a href=\"https:\/\/gibbon.edugorilla.com\/blog\/create-upload-content-with-gibbon\/\" target=\"_blank\" rel=\"noreferrer noopener\">Create\/ Upload Content<\/a><\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\"><a href=\"https:\/\/gibbon.edugorilla.com\/blog\/?p=7327\" target=\"_blank\" rel=\"noreferrer noopener\">Ready Made Content for Exams<\/a><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><a href=\"https:\/\/gibbon.edugorilla.com\/#get_started\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"231\" src=\"https:\/\/gibbon.edugorilla.com\/blog\/wp-content\/uploads\/2023\/03\/8-1024x231.jpg\" alt=\"\" class=\"wp-image-7300\" srcset=\"https:\/\/gibbon.edugorilla.com\/blog\/wp-content\/uploads\/2023\/03\/8-1024x231.jpg 1024w, https:\/\/gibbon.edugorilla.com\/blog\/wp-content\/uploads\/2023\/03\/8-300x68.jpg 300w, https:\/\/gibbon.edugorilla.com\/blog\/wp-content\/uploads\/2023\/03\/8.jpg 1170w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><figcaption>Hurry! Book a FREE Demo<\/figcaption><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Google Sheets is as a powerful online spreadsheet application and has indeed revolutionized the way people use spreadsheets for their work. Google sheets has replace traditional offline software such as Excel in several niche domains. For teachers Google Sheets is a versatile tool that holds significant importance in various aspects of one\u2019s work \u2013 management,<\/p>\n","protected":false},"author":12,"featured_media":8913,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[171],"tags":[158],"class_list":{"0":"post-8906","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-tips-tricks","8":"tag-gibbon"},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v23.2 (Yoast SEO v23.2) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Complete Google Sheet Shortcuts for Teachers - Blogs on Starting your Business with Gibbon by EduGorilla<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/gibbon.edugorilla.com\/blog\/google-sheet-shortcuts\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Complete Google Sheet Shortcuts for Teachers\" \/>\n<meta property=\"og:description\" content=\"Google Sheets is as a powerful online spreadsheet application and has indeed revolutionized the way people use spreadsheets for their work. Google sheets has replace traditional offline software such as Excel in several niche domains. For teachers Google Sheets is a versatile tool that holds significant importance in various aspects of one\u2019s work \u2013 management,\" \/>\n<meta property=\"og:url\" content=\"https:\/\/gibbon.edugorilla.com\/blog\/google-sheet-shortcuts\/\" \/>\n<meta property=\"og:site_name\" content=\"Blogs on Starting your Business with Gibbon by EduGorilla\" \/>\n<meta property=\"article:published_time\" content=\"2023-06-19T08:32:57+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-08-08T10:17:52+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/gibbon.edugorilla.com\/blog\/wp-content\/uploads\/2023\/06\/a-teacher-using-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1004\" \/>\n\t<meta property=\"og:image:height\" content=\"860\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Digvijay Singh\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Digvijay Singh\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/gibbon.edugorilla.com\/blog\/google-sheet-shortcuts\/\",\"url\":\"https:\/\/gibbon.edugorilla.com\/blog\/google-sheet-shortcuts\/\",\"name\":\"Complete Google Sheet Shortcuts for Teachers - Blogs on Starting your Business with Gibbon by EduGorilla\",\"isPartOf\":{\"@id\":\"https:\/\/gibbon.edugorilla.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/gibbon.edugorilla.com\/blog\/google-sheet-shortcuts\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/gibbon.edugorilla.com\/blog\/google-sheet-shortcuts\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/gibbon.edugorilla.com\/blog\/wp-content\/uploads\/2023\/06\/a-teacher-using-1.png\",\"datePublished\":\"2023-06-19T08:32:57+00:00\",\"dateModified\":\"2023-08-08T10:17:52+00:00\",\"author\":{\"@id\":\"https:\/\/gibbon.edugorilla.com\/blog\/#\/schema\/person\/c7ef64d9244d321efdb7d3a58b40ef75\"},\"breadcrumb\":{\"@id\":\"https:\/\/gibbon.edugorilla.com\/blog\/google-sheet-shortcuts\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/gibbon.edugorilla.com\/blog\/google-sheet-shortcuts\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/gibbon.edugorilla.com\/blog\/google-sheet-shortcuts\/#primaryimage\",\"url\":\"https:\/\/gibbon.edugorilla.com\/blog\/wp-content\/uploads\/2023\/06\/a-teacher-using-1.png\",\"contentUrl\":\"https:\/\/gibbon.edugorilla.com\/blog\/wp-content\/uploads\/2023\/06\/a-teacher-using-1.png\",\"width\":1004,\"height\":860,\"caption\":\"Google sheets keyboard shortcuts\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/gibbon.edugorilla.com\/blog\/google-sheet-shortcuts\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/gibbon.edugorilla.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Complete Google Sheet Shortcuts for Teachers\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/gibbon.edugorilla.com\/blog\/#website\",\"url\":\"https:\/\/gibbon.edugorilla.com\/blog\/\",\"name\":\"Blogs on Starting your Business with Gibbon by EduGorilla\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/gibbon.edugorilla.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/gibbon.edugorilla.com\/blog\/#\/schema\/person\/c7ef64d9244d321efdb7d3a58b40ef75\",\"name\":\"Digvijay Singh\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/gibbon.edugorilla.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/eb3c6cf7475de92804e0d795337ab2b3?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/eb3c6cf7475de92804e0d795337ab2b3?s=96&d=mm&r=g\",\"caption\":\"Digvijay Singh\"},\"url\":\"https:\/\/gibbon.edugorilla.com\/blog\/author\/digvijaysingh\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Complete Google Sheet Shortcuts for Teachers - Blogs on Starting your Business with Gibbon by EduGorilla","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:\/\/gibbon.edugorilla.com\/blog\/google-sheet-shortcuts\/","og_locale":"en_US","og_type":"article","og_title":"Complete Google Sheet Shortcuts for Teachers","og_description":"Google Sheets is as a powerful online spreadsheet application and has indeed revolutionized the way people use spreadsheets for their work. Google sheets has replace traditional offline software such as Excel in several niche domains. For teachers Google Sheets is a versatile tool that holds significant importance in various aspects of one\u2019s work \u2013 management,","og_url":"https:\/\/gibbon.edugorilla.com\/blog\/google-sheet-shortcuts\/","og_site_name":"Blogs on Starting your Business with Gibbon by EduGorilla","article_published_time":"2023-06-19T08:32:57+00:00","article_modified_time":"2023-08-08T10:17:52+00:00","og_image":[{"width":1004,"height":860,"url":"https:\/\/gibbon.edugorilla.com\/blog\/wp-content\/uploads\/2023\/06\/a-teacher-using-1.png","type":"image\/png"}],"author":"Digvijay Singh","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Digvijay Singh","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/gibbon.edugorilla.com\/blog\/google-sheet-shortcuts\/","url":"https:\/\/gibbon.edugorilla.com\/blog\/google-sheet-shortcuts\/","name":"Complete Google Sheet Shortcuts for Teachers - Blogs on Starting your Business with Gibbon by EduGorilla","isPartOf":{"@id":"https:\/\/gibbon.edugorilla.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/gibbon.edugorilla.com\/blog\/google-sheet-shortcuts\/#primaryimage"},"image":{"@id":"https:\/\/gibbon.edugorilla.com\/blog\/google-sheet-shortcuts\/#primaryimage"},"thumbnailUrl":"https:\/\/gibbon.edugorilla.com\/blog\/wp-content\/uploads\/2023\/06\/a-teacher-using-1.png","datePublished":"2023-06-19T08:32:57+00:00","dateModified":"2023-08-08T10:17:52+00:00","author":{"@id":"https:\/\/gibbon.edugorilla.com\/blog\/#\/schema\/person\/c7ef64d9244d321efdb7d3a58b40ef75"},"breadcrumb":{"@id":"https:\/\/gibbon.edugorilla.com\/blog\/google-sheet-shortcuts\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/gibbon.edugorilla.com\/blog\/google-sheet-shortcuts\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/gibbon.edugorilla.com\/blog\/google-sheet-shortcuts\/#primaryimage","url":"https:\/\/gibbon.edugorilla.com\/blog\/wp-content\/uploads\/2023\/06\/a-teacher-using-1.png","contentUrl":"https:\/\/gibbon.edugorilla.com\/blog\/wp-content\/uploads\/2023\/06\/a-teacher-using-1.png","width":1004,"height":860,"caption":"Google sheets keyboard shortcuts"},{"@type":"BreadcrumbList","@id":"https:\/\/gibbon.edugorilla.com\/blog\/google-sheet-shortcuts\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/gibbon.edugorilla.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Complete Google Sheet Shortcuts for Teachers"}]},{"@type":"WebSite","@id":"https:\/\/gibbon.edugorilla.com\/blog\/#website","url":"https:\/\/gibbon.edugorilla.com\/blog\/","name":"Blogs on Starting your Business with Gibbon by EduGorilla","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/gibbon.edugorilla.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/gibbon.edugorilla.com\/blog\/#\/schema\/person\/c7ef64d9244d321efdb7d3a58b40ef75","name":"Digvijay Singh","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/gibbon.edugorilla.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/eb3c6cf7475de92804e0d795337ab2b3?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/eb3c6cf7475de92804e0d795337ab2b3?s=96&d=mm&r=g","caption":"Digvijay Singh"},"url":"https:\/\/gibbon.edugorilla.com\/blog\/author\/digvijaysingh\/"}]}},"_links":{"self":[{"href":"https:\/\/gibbon.edugorilla.com\/blog\/wp-json\/wp\/v2\/posts\/8906"}],"collection":[{"href":"https:\/\/gibbon.edugorilla.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/gibbon.edugorilla.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/gibbon.edugorilla.com\/blog\/wp-json\/wp\/v2\/users\/12"}],"replies":[{"embeddable":true,"href":"https:\/\/gibbon.edugorilla.com\/blog\/wp-json\/wp\/v2\/comments?post=8906"}],"version-history":[{"count":14,"href":"https:\/\/gibbon.edugorilla.com\/blog\/wp-json\/wp\/v2\/posts\/8906\/revisions"}],"predecessor-version":[{"id":9197,"href":"https:\/\/gibbon.edugorilla.com\/blog\/wp-json\/wp\/v2\/posts\/8906\/revisions\/9197"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/gibbon.edugorilla.com\/blog\/wp-json\/wp\/v2\/media\/8913"}],"wp:attachment":[{"href":"https:\/\/gibbon.edugorilla.com\/blog\/wp-json\/wp\/v2\/media?parent=8906"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/gibbon.edugorilla.com\/blog\/wp-json\/wp\/v2\/categories?post=8906"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/gibbon.edugorilla.com\/blog\/wp-json\/wp\/v2\/tags?post=8906"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}