Google Spreadsheets (Web Application)

Miscellaneous Shortcuts

View all formulas

Ctrl + '

All hotkeys for Google Spreadsheets (Web Application)

Movement within worksheets
Move one cell up, down, left, or right

Arrow Keys

Movement within worksheets
Move one cell to the right

Tab

Movement within worksheets
Move one cell to the left

Shift + Tab

Movement within worksheets
Move to the end of the row

End

Movement within worksheets
Go to last cell in data region

Ctrl + End

Movement within worksheets
Move to the beginning of the row

Home

Movement within worksheets
Move to the beginning of the worksheet

Ctrl + Home

Movement within worksheets
Go to left-most / right-most cell in current row

Ctrl + Arrow Left / Ctrl + Arrow Right

Movement within worksheets
Go to bottom-most / to-most cell in current column

Ctrl + Arrow Down / Ctrl + Arrow Up

Movement within worksheets
Move to next / move to previousworksheet

Ctrl + Page Down / Ctrl + Page Up

Movement within worksheets
Move one screen to the right / one screen to the left

Alt + Page Down / Alt + Page Up

Movement within worksheets
Scroll to the active cell when multiple cells are selected

Ctrl + Backspace

Movement within worksheets
Switch sheets

Ctrl + Shift + Page Up / Page Down

Movement within a selected range
Move from top to bottom within the selected range

Enter

Movement within a selected range
Move from bottom to top within the selected range

Shift + Enter

Movement within a selected range
Move from left to right within the selected range. If cells in a single column are selected, move down.

Tab

Movement within a selected range
Move from right to left within the selected range. If cells in a single column are selected, move up.

Shift + Tab

Entering/editing data
Select the all / entire worksheet

Ctrl + a

Entering/editing data
Bold the contents of the selected cell

Ctrl + b

Entering/editing data
Copy the contents of the selected cell

Ctrl + c

Entering/editing data
Find words or phrases within the spreadsheet

Ctrl + f

Entering/editing data
Italicize the contents of the selected cell

Ctrl + i

Entering/editing data
Print

Ctrl + p

Entering/editing data
Copy the content of the selected cell right (used in combo with Shift + arrow)

Ctrl + r

Entering/editing data
Save

Ctrl + s

Entering/editing data
Underline the contents of the selected cell

Ctrl + u

Entering/editing data
Paste the contents of the selected cell

Ctrl + v

Entering/editing data
Cut the contents of the selected cell

Ctrl + x

Entering/editing data
Redo the last action

Ctrl + y

Entering/editing data
Undo the last action.

Ctrl + z

Entering/editing data
Complete a cell entry and select the cell below

Enter

Entering/editing data
Complete a cell entry and select the previous cell above

Shift + Enter

Entering/editing data
Start a new line in the same cell

Alt + Enter

Entering/editing data
Insert line break in a cell

Ctrl + Enter

Entering/editing data
Complete a cell entry and select the next cell to the right

Tab

Entering/editing data
Complete a cell entry and select the previous cell to the left

Shift + Tab

Entering/editing data
Edit the active cell and position the insertion point at the end of the cell contents

F2

Entering/editing data
Edit comment

Shift + F2

Entering/editing data
Cancel cell entry

Esc

Entering/editing data
Edit the active cell and then clear it, or delete the preceding character in the active cell as you edit cell contents

Backspace

Entering/editing data
Delete the character to the right of the insertion point, or delete the selection

Delete

Entering/editing data
Select the entire column

Ctrl + Space

Entering/editing data
Select the entire row

Shift + Space

Entering/editing data
Manual select

Shift + Arrow Keys

Entering/editing data
Make a copy of the document

Ctrl + Shift + s

Entering/editing data
Strikethrough formatting for the contents of the cell

Alt + Shift + 5

Entering/editing data
Apply border outline to selected cells

Alt + Shift + &

Entering/editing data
Remove border outline from selected cells

Alt + Shift + _

Entering/editing data
Apply or remove top border from the selected cells

Alt + Shift + t

Entering/editing data
Apply or remove bottom border from the selected cells

Alt + Shift + b

Entering/editing data
Apply or remove right border from the selected cells

Alt + Shift + r

Entering/editing data
Apply or remove left border from the selected cells

Alt + Shift + l

Miscellaneous Shortcuts
Wrap current formula in an ArrayFormula

Ctrl + Shift + Enter

Miscellaneous Shortcuts
Insert current date into cell

Ctrl + ;

Miscellaneous Shortcuts
Insert current time into cell

Ctrl + :

Miscellaneous Shortcuts
Open keyboard shortcuts help

Ctrl + /

Miscellaneous Shortcuts
View all formulas

Ctrl + '

Similar combinations for other applications


Access 2010 (Windows)
Insert the value from the same field in the previous record
Manage Access Features - Insert Data

Ctrl + '


Oracle SQL Developer 4 (Windows)
Navigate down/ up
Navigate

Ctrl + ' / Ctrl + Shift + '


Access 2010 (Windows)
Insert the value from the same field in the previous record
Working with Text and Data - Insert Data

Ctrl + '


Oracle SQL Developer 4 (Windows)
Toggle Case
Worksheet

Ctrl + '


Avid Media Composer 7 (Windows)
Send selected window back to its default location.
Editing

Ctrl + '


Access 2010 (Windows)
Insert the value from the same field in the previous record
Working with Access Views - Insert Data

Ctrl + '


Microsoft Excel 2013 (Windows)
Duplicate value from Cell above into current Cell
Edit Content of Cells

Ctrl + '


Access 2010 (Windows)
Insert the value from the same field in the previous record
The Rest - Insert Data

Ctrl + '


Adobe After Effects CC (Windows)
Show or hide Grid
Views

Ctrl + '


FileMaker Pro (Windows)
Insert information from the last visited record
Paste, Select, and Replace Values

Ctrl + '


ArchiCAD 20 (Windows)
Place Module
File Modules and XREF

Ctrl + '


3D Coat (Windows)
Show 2D Grid
View Menu

Ctrl + '


Finale (Windows)
Center Justify
Lyrics Tool

Ctrl + '


ArchiCAD 20 (Windows)
Fit to Window
Display Menu

Ctrl + '


Adobe Photoshop CC (Windows)
Show/Hide Grid
Manage Views

Ctrl + '


CyberLink PhotoDirector 8 (Windows)
Create virtual photo
Operational

Ctrl + '


Microsoft Excel 2016 (Windows)
Duplicate value from Cell above into current cell at cursor position
Edit Cell Content

Ctrl + '


Sublime Text (MacOS)
Python Console
General Editing Shortcuts

Ctrl + '


Microsoft Excel 2016 (Windows)
Duplicate formula from cell above
Duplicate Cells, Rows, and Columns

Ctrl + '


Adobe Dreamweaver (Windows)
Balance Braces
Coding Shortcuts

Ctrl + '


Adobe XD (Experience Design) (Windows)
Show Artboard Grid
View Menu

Ctrl + '


Adobe Bridge CC (Windows)
Switch between 0 and 1 Star Rating
35 Shortcuts for Adobe Bridge CC (Windows)

Ctrl + '


jEdit (Windows)
Scroll Up/down Line
Scrolling

Ctrl + ' / Ctrl + /


Adobe ColdFusion Builder 2.0 (Windows)
Wrap in Single Quotes
Inserting Text

Ctrl + '


Kingsoft Spreadsheets 2016 (Windows)
Enters the current time
Other Shortcuts

Ctrl + '


Poser Pro (Windows)
Display>Camera View >From right
Display

Ctrl + '


Krita Painting 3 (Windows)
Reset canvas view
Rotate

Ctrl + '


KMPlayer (Windows)
Advanced Filter Info
General

Ctrl + '


PSPad (Windows)
SelString2
Edit

Ctrl + '


Affinity Photo
Show Grid
View

Ctrl + '


Adobe Illustrator
Show grid
View artwork

Ctrl + '


jEdit
Scroll up one line.
Scrolling

Ctrl + '


KMPlayer
Advanced filter info
General

Ctrl + '


Microsoft FrontPage
Select block.
Work with coding tools

Ctrl + '


PDF-XChange Editor
Show grid
General

Ctrl + '


Adobe XD (Windows)
Show Square Grid
-View menu

Ctrl + '


PSPad
SelString2
Edit

Ctrl + '


Microsoft Visual Studio 2017 (All shortcuts)
Team.TeamExplorerSearch
Team

Ctrl + '


WPS Office
Enters the current time.
General

Ctrl + '


Krita 3.0
Reset canvas view
Rotate

Ctrl + '


Microsoft Excel 2016
Copies a formula from the cell above the active cell into the cell or the Formula Bar
CTRL combination shortcut keys

Ctrl + '


Chrome DevTools
Step over next function or call
Sources panel

Ctrl + '


Microsoft Access 2016
Insert the value from the same field in the previous record
Edit text or data: Enter data in a Datasheet or Form view

Ctrl + '


Microsoft Excel 2007 (Windows)
Copies a formula from the cell above the active cell into the cell or the Formula Bar.
CTRL Combinations in Excel 2007

Ctrl + '


Adobe After Effects CS5 (Windows)
Show or hide grid
Views

Ctrl + '


Figma
Pixel grid
View

Ctrl + '


Scrivener 1.9.9
No editor split
View

Ctrl + '