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!
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
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
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)
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)
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)
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)
