Guida al cheat sheet
Google Sheets scorciatoie da imparare per prime
Questa pagina raccoglie 46 scorciatoie da tastiera cercabili per Google Sheets in 5 categorie. Parti dalle categorie principali, poi stampa il cheat sheet quando vuoi tenerlo a portata di mano.
- Cambia scheda OS per vedere scorciatoie Windows, macOS o Linux.
- Usa / per passare subito alla ricerca.
- Usa la modalita confronto quando lavori su macchine diverse.
- Stampa o salva la pagina come cheat sheet PDF compatto.
Navigazione
8 shortcuts
Move to beginning of row
Home
WinHomeMacHome/Fn+LeftLinuxHome
Move to beginning of sheet
Ctrl+Home
WinCtrl+HomeMac⌘+Home/⌃⌘+LeftLinuxCtrl+Home
Move to end of sheet
Ctrl+End
WinCtrl+EndMac⌘+EndLinuxCtrl+End
Move to next sheet
Ctrl+PageDown
WinCtrl+PageDownMac⌘+⇧+PgDnLinuxCtrl+PageDown
Move to previous sheet
Ctrl+PageUp
WinCtrl+PageUpMac⌘+⇧+PgUpLinuxCtrl+PageUp
Jump to range
Ctrl+G
WinCtrl+GMac⌘GLinuxCtrl+G
Go to cell A1
Ctrl+Home
WinCtrl+HomeMac⌘+Fn+LeftLinuxCtrl+Home
Scroll to active cell
Ctrl+Backspace
WinCtrl+BackspaceMac⌘+BackspaceLinuxCtrl+Backspace
Modifica
13 shortcuts
Modifica active cell
F2
WinF2MacF2LinuxF2
Annulla
Ctrl+Z
WinCtrl+ZMac⌘ZLinuxCtrl+Z
Ripeti
Ctrl+Y
WinCtrl+YMac⌘YLinuxCtrl+Y
Taglia
Ctrl+X
WinCtrl+XMac⌘XLinuxCtrl+X
Copia
Ctrl+C
WinCtrl+CMac⌘CLinuxCtrl+C
Incolla
Ctrl+V
WinCtrl+VMac⌘VLinuxCtrl+V
Incolla values only
Ctrl+Shift+V
WinCtrl+Shift+VMac⌘Shift+VLinuxCtrl+Shift+V
Fill down
Ctrl+D
WinCtrl+DMac⌘DLinuxCtrl+D
Fill right
Ctrl+R
WinCtrl+RMac⌘RLinuxCtrl+R
Insert new line in cell
Alt+Enter
WinAlt+EnterMac⌃⌥EnterLinuxAlt+Enter
Elimina cell contents
Elimina
WinEliminaMacElimina/BackspaceLinuxElimina
Trova and replace
Ctrl+H
WinCtrl+HMac⌘HLinuxCtrl+H
Trova
Ctrl+F
WinCtrl+FMac⌘FLinuxCtrl+F
Formattazione
11 shortcuts
Grassetto
Ctrl+B
WinCtrl+BMac⌘BLinuxCtrl+B
Corsivo
Ctrl+I
WinCtrl+IMac⌘ILinuxCtrl+I
Sottolineato
Ctrl+U
WinCtrl+UMac⌘ULinuxCtrl+U
Strikethrough
Alt+Shift+5
WinAlt+Shift+5Mac⌥Shift+5LinuxAlt+Shift+5
Format as currency
Ctrl+Shift+4
WinCtrl+Shift+4Mac⌘Shift+4LinuxCtrl+Shift+4
Format as percentage
Ctrl+Shift+5
WinCtrl+Shift+5Mac⌘Shift+5LinuxCtrl+Shift+5
Format as date
Ctrl+Shift+3
WinCtrl+Shift+3Mac⌘Shift+3LinuxCtrl+Shift+3
Align left
Ctrl+Shift+L
WinCtrl+Shift+LMac⌘Shift+LLinuxCtrl+Shift+L
Align center
Ctrl+Shift+E
WinCtrl+Shift+EMac⌘Shift+ELinuxCtrl+Shift+E
Align right
Ctrl+Shift+R
WinCtrl+Shift+RMac⌘Shift+RLinuxCtrl+Shift+R
Clear formatting
Ctrl+\
WinCtrl+\Mac⌘\LinuxCtrl+\
Rows & Columns
8 shortcuts
Insert row above
Ctrl+Alt+Shift+=
WinCtrl+Alt+Shift+=Mac⌘⌥Shift+=LinuxCtrl+Alt+Shift+=
Insert column left
Ctrl+Alt+=
WinCtrl+Alt+=Mac⌘⌥=LinuxCtrl+Alt+=
Elimina row
Ctrl+Alt+-
WinCtrl+Alt+-Mac⌘⌥-LinuxCtrl+Alt+-
Select entire row
Shift+Space
WinShift+SpaceMacShift+SpaceLinuxShift+Space
Select entire column
Ctrl+Space
WinCtrl+SpaceMac⌃SpaceLinuxCtrl+Space
Hide row
Ctrl+Alt+9
WinCtrl+Alt+9Mac⌘⌥9LinuxCtrl+Alt+9
Hide column
Ctrl+Alt+0
WinCtrl+Alt+0Mac⌘⌥0LinuxCtrl+Alt+0
Group rows/columns
Alt+Shift+Right
WinAlt+Shift+RightMac⌥Shift+RightLinuxAlt+Shift+Right
Formule
6 shortcuts
Show all formulas
Ctrl+`
WinCtrl+`Mac⌃`LinuxCtrl+`
Insert current date
Ctrl+;
WinCtrl+;Mac⌘;LinuxCtrl+;
Insert current time
Ctrl+Shift+;
WinCtrl+Shift+;Mac⌘Shift+;LinuxCtrl+Shift+;
Toggle absolute/relative reference
F4
WinF4MacF4LinuxF4
Sum selected cells
Alt+=
WinAlt+=Mac⌘Shift+TLinuxAlt+=
Insert comment
Ctrl+Alt+M
WinCtrl+Alt+MMac⌘⌥MLinuxCtrl+Alt+M
Domande frequenti
Qual è il modo più veloce per trovare le scorciatoie di Google Sheets su questa pagina?
Usa la barra di ricerca o premi /, poi digita un'azione come move to beginning of row.
Posso stampare questo cheat sheet di scorciatoie di Google Sheets?
Sì. Usa il pulsante Stampa / PDF o il comando stampa del browser per salvare un cheat sheet compatto.
Questa pagina include le scorciatoie Windows e Mac per Google Sheets?
Sì. Usa le schede OS per passare tra scorciatoie Windows e macOS. Ad esempio, move to beginning of row è Home su Windows e Home / Fn+Left su macOS dove disponibile.
Advertisement