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

Shortcuts for Google Sheets - Keyboard shortcuts at a glance

Published on February 6, 2024 by Stefan Petri

Published on: February 6, 2024 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.