Want to know some shortcut keys? Press “Ctrl + /” to open the help menu. This keyboard shortcut is especially useful for beginners who are still getting the hang of using Google Sheets.
One of the frequent tasks when working on Google Sheets is switching between the different sheets. You can use “Ctrl + PgUp” and “Ctrl + PgDn” to move between sheets in the same file.
For large sheets, scrolling becomes a tedious task. You can navigate large sheets by pressing “Ctrl + Alt + Arrow Key”. This keyboard shortcut enables you to move the active cell up, down, left, or right.
If you want to quickly add a new sheet in your Google Sheets file, use “Shift + F11” key combination. You can also right-click on the “+” icon at the bottom left of your screen and choose “Add Sheet” to create a new sheet.
Selecting rows or columns often takes time, especially when you have a lot of data. You can select the entire row by pressing “Shift + Space” while a particular cell in the row is selected. Similarly, to select the entire column, press “Ctrl + Space” while a particular cell in the column is selected.
To quickly fill down a formula or value, select the cell you want to fill down and press “Ctrl + D”. This keyboard shortcut copies the value or formula to the next selected cell. You can also drag the fill handle to copy down a formula or value.
To quickly sum up a range of values, select the range, and press “Alt + Shift + =”. This keyboard shortcut will add up the values in the selected range and display the result in the cell below the range.
If you want to hide rows or columns with data, select the rows or columns and press “Ctrl + 9” to hide them. To unhide the hidden rows or columns, select the adjacent rows or columns and press “Ctrl + Shift + 9”.
To quickly insert the current date in a cell, select the cell, and press “Ctrl + ;”. This keyboard shortcut will insert the current date into the cell in the format of your sheet.
To quickly insert the current time in a cell, select the cell, and press “Ctrl + Shift + ;”. This keyboard shortcut will insert the current time into the cell in the format of your sheet.
Using keyboard shortcuts can speed up your work and increase your productivity in Google Sheets. The above-listed shortcuts are just the tip of the iceberg. Explore more keyboard shortcuts and see which ones work best for you. Learning and mastering keyboard shortcuts can save you time, and make you look like a pro when working with Google Sheets.