Shortcuts for Google Sheets - Keyboard shortcuts at a glance
Welcome to our guide that will introduce you to the world of keyboard shortcuts for Google Sheets. In this article, you'll discover how the right combination of keys can significantly speed up and simplify your work in Google Sheets. From basic functions such as copying and pasting to advanced data manipulation and analysis techniques, these shortcuts are essential tools for anyone who wants to work efficiently and effectively with spreadsheets. We provide you with a comprehensive overview that is valuable for both beginners and experienced Sheets users. Get ready to take your Google Sheets skills to the next level!
Table of Contents
Frequently used actions
| Description of actions | Keyboard shortcut (Mac) | Keyboard shortcut (Windows) |
| Select a column | Control + Space | Ctrl + Space |
| Selection of a row | Shift + Space | Shift + Space |
| Complete selection | Command + A | Ctrl + A |
| Create line break within a cell | Option + Enter | Alt + Enter |
| Undo action | Command + Z | Ctrl + Z |
| Repeat action | Command + Y | Ctrl + Y |
| Save table | Command + S | Ctrl + S |
| Print table | Command + P | Ctrl + P |
| Open table | Command + O | Ctrl + O |
| Start search | Command + F | Ctrl + F |
| Search & replace | Command + Shift + H | Ctrl + H |
| Find next | Command + G | Ctrl + G |
| Copy content | Command + C | Ctrl + C |
| Cut content | Command + X | Ctrl + X |
| Paste content | Command + V | Ctrl + V |
| Insert values | Command + Shift + V | Ctrl + Shift + V |
| Add new worksheet | Shift + Fn + F11 | Shift + F11 |
| Reduce/expand view of controls | Control + Shift + F | Ctrl + Shift + F |
| Open window for links | Command + K | Ctrl + K |
Format text
| Keyboard shortcut | Keyboard shortcut (Mac) | Keyboard shortcut (Windows) |
| Bolded content | Command + B | Ctrl + B |
| Italicized content | Command + I | Ctrl + I |
| Underlined content | Command + U | Ctrl + U |
| Strikethrough content | Command + Shift + X | Alt + Shift + 5 |
Content alignment
| Shortcut | Keyboard shortcut (Mac) | Keyboard shortcut (Windows) |
| Center content | Command + Shift + E | Ctrl + Shift + E |
| Left-align content | Command + Shift + L | Ctrl + Shift + L |
| Right-aligned content | Command + Shift + R | Ctrl + Shift + R |
Create frame
| Keyboard shortcut | Keyboard shortcut (Mac) | Key combination (Windows) |
| Upper frame line | Option + Shift + 1 | Alt + Shift + 1 |
| Right frame line | Option + Shift + 2 | Alt + Shift + 2 |
| Bottom frame line | Option + Shift + 3 | Alt + Shift + 3 |
| Left frame line | Option + Shift + 4 | Alt + Shift + 4 |
| Outer frame lines | Option + Shift + 7 | Alt + Shift + 7 |
| Remove the frame | Option + Shift + 6 | Alt + Shift + 6 |
Number formats
| Keyboard shortcut | Key combination (Mac) | Keyboard shortcut (Windows) |
| Insert current time | Command + Shift + ; | Ctrl + Shift + ; |
| Insert current date and time | Command + Option + Shift + ; | Ctrl + Alt + Shift + ; |
| Insert time | Control + Shift + 2 | Ctrl + Shift + 2 |
| Insert date | Control + Shift + 3 | Ctrl + Shift + 3 |
| "Create number with thousands separator, two decimal places and sign" | Control + Shift + 1 | Ctrl + Shift + 1 |
| Display as currency | Control + Shift + 4 | Ctrl + Shift + 4 |
| Display as percentage value | Control + Shift + 5 | Ctrl + Shift + 5 |
| Display as a scientific value with two decimal places | Control + Shift + 6 | Ctrl + Shift + 6 |
| Remove the formatting | Command + \\ | Ctrl + \\ |
Navigation
| Navigation Description | Keyboard shortcut (Mac) | Keyboard shortcut (Windows) |
| Move to the beginning of the line | Fn + left arrow key | Pos1 |
| Move to the end of the line | Fn + right arrow key | End |
| Jump to the next filled line | Command + down or up arrow key | Ctrl + down or up arrow key |
| Move to the beginning of the worksheet | Command + Fn + left arrow key | Ctrl + Pos1 |
| Move to the end of the worksheet | Command + Fn + right arrow key | Ctrl + End |
| Call up next worksheet | Option + down arrow key | Alt + down arrow key |
| Call up previous worksheet | Option + Up arrow key | Alt + Up arrow key |
| Show all worksheets as a list | Option + Shift + K | Alt + Shift + K |
Rows and columns
| Keyboard shortcut | Keyboard shortcut (Mac) | Keyboard shortcut (Windows) |
| Extend selection in one direction | Shift + corresponding arrow key | Shift + corresponding arrow key |
| Extend selection to the next filled cell | Command + Shift + corresponding arrow key | Ctrl + Shift + corresponding arrow key |
| Select rows of the current cells | Shift + Space | Shift + Space |
| Select columns of the current cells | Command + Space | Ctrl + Space |
| Select partial range (1 x) or all (2 x) | Command + A | Ctrl + A |
| Select from current position to cell A1 | ? | Ctrl + Shift + Pos1 |
| Select from current position to last entry | ? | Ctrl + Shift + End |
| Insert line above | Control + Option + I + R (press twice) | Ctrl + Alt + Shift + = / Ctrl + Alt + = (if line is selected) |
| Insert line below | Control + Option + I + B | |
| Insert a column on the left | Control + Option + I + C (hold down) | Ctrl + Alt + Shift + = / Ctrl + Alt + = (if column is selected) |
| Insert a column on the right | Control + Option + I + C + O | |
| Delete selected rows or columns | Command + Option + - | Ctrl + Alt + - |
| Hide a row | Command + Option + 9 | Ctrl + Alt + 9 |
| Show a line | Command + Shift + 9 | Ctrl + Shift + 9 |
| Hide a column | Command + Option + 0 | Ctrl + Alt + 0 |
| Show a column | Command + Shift + 0 | Ctrl + Shift + 0 |
Formulas - Position functions
| Function name | Function description | Formula |
| REFERENCE | Finds unknown information based on known information and outputs the result | REFERENCE(search key; search range|search result array; [result range]) |
| REFERENCE | Finds unknown information based on known information and outputs the result (searches vertically in the first column) | SVERWEIS(search_key; range; index; is_sorted) |
| WVERWEIS | Finds unknown information based on known information and outputs the result (searches horizontally in the first row) | WVERWEIS(search_key; range; index; is_sorted) |
| INDEX | Goes to a position in a range based on a given row and column and returns the value | INDEX(reference; row; column) |
| COMPARE | Searches for a criterion and returns the relative position of the value | COMPARE(search key; range; search type) |
Basic functions - formulas
| Function name | Function description | Formula |
| AND | Outputs TRUE if all truth values are TRUE | AND(truth value1; truth value2) |
| OR | Outputs TRUE if at least one truth value is TRUE | OR(truth value1; truth value2) |
| IF | Performs a truth check | IF(truth_value; value_if_true; value_if_false) |
| MAX | Finds the largest value of a value set | MAX(value1; value2) |
| MIN | Finds the smallest value of a value set | MIN(value1; value2) |
| MAXA | Finds the largest value of a value set (including text and logical values) | MAXA(value1; value2) |
| MINA | Finds the smallest value of a value set (including text and logical values) | MINA(value1; value2) |
| KGLARGEST | Searches for the k largest number in a range (e.g. the third largest number) and returns it | KKLARGEST(data; n) |
| KKLEINST | Searches for the k smallest number in a range (e.g. the third smallest number) and returns it | SMALLEST(data; n) |
| RANGE.MOVE | Displays a reference that is offset from the specified reference | RANGE.SHIFT(cell reference; row offset; column offset; height; width) |
Date functions - Formulas
| Function name | Function description | Formula |
| DATE | Defines a date | DATUM(year; month; day) |
| DAY | Converts a number into the day of a month (1 to 31) | DAY(date) |
| DAYS | Calculates the number of days between two dates | DAYS(end date; start date) |
| MONTH | Converts a number into the month of a year (1 to 12) | MONTH(date) |
| YEAR | Converts a number into a year (1900 to 9999) | YEAR(date) |
| NOW | Displays the current date and time. | NOW() |
| TODAY | Displays the current date. | TODAY() |
| CALENDAR WEEK | Specifies the calendar week of a date (number_type for specifying the calendar week according to ISO 8601: 21). | CALENDAR WEEK(date; [type]) |
| ISOCALENDARWEEK | Specifies the calendar week of a date according to ISO 8601. | ISO CALENDAR WEEK(date) |
| EDATUM | Indicates a date that is a number of months before or after the start date. | EDATUM(start date) |
Rounding and counting functions - formulas
| Function name | Function description | Formula |
| ROUND UP | Rounds a value up | ROUND UP(value; digits) |
| ROUND | Rounds a value up or down | ROUND(value; digits) |
| ROUND DOWN | Rounds a value down | ROUND DOWN(value; digits) |
| COUNT | Counts all cells in a range that contain a number | COUNT(value1; [value2; ...]) |
| COUNT2 | Counts all cells in a range that contain information | COUNT2(value1; [value2; ...]) |
| COUNT EMPTY CELLS | Counts all empty cells in a range | COUNT EMPTY CELLS(range) |
| COUNT IF | Counts the cells that fulfill a search criterion | NUMBERSWENN(range; criterion) |
| NUMBERS | Counts the cells that fulfill several search criteria | NUMBERS(criteria range1; criterion1; [criteria range2; criterion2; ...]) |
| ROW | Returns the row number of a reference cell | LINE(cell reference) |
| COLUMN | Outputs the column number of a reference cell | COLUMN(cell reference) |
926, 927, 331
Published on
by Stefan Petri
Published on:
From Stefan Petri
From Stefan Petri
Together with his brother Matthias, Stefan Petri runs the popular specialist forum PSD-Tutorials.de and the e-learning platform TutKit.com, which focuses on the training and further education of digital professional skills.