Guida al cheat sheet
Google Sheets shortcuts worth learning first
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.
- Move to beginning of rowHome
- Modifica cella attivaF2
- GrassettoCtrlB
- Insert row aboveCtrlAltShift=
- Show all formulasCtrl`
- Move to beginning of sheetCtrlHome
Navigazione
8 scorciatoie
Move to beginning of row
Home
WinHomeMacHomeFnLeftLinuxHome
Move to beginning of sheet
CtrlHome
WinCtrlHomeMac⌘Home⌃⌘LeftLinuxCtrlHome
Move to end of sheet
CtrlEnd
WinCtrlEndMac⌘EndLinuxCtrlEnd
Move to next sheet
CtrlPaginaDown
WinCtrlPaginaDownMac⌘⇧PgDnLinuxCtrlPaginaDown
Move to previous sheet
CtrlPaginaUp
WinCtrlPaginaUpMac⌘⇧PgUpLinuxCtrlPaginaUp
Jump to range
CtrlG
WinCtrlGMac⌘GLinuxCtrlG
Go to cell A1
CtrlHome
WinCtrlHomeMac⌘FnLeftLinuxCtrlHome
Scroll to active cell
CtrlBackspace
WinCtrlBackspaceMac⌘BackspaceLinuxCtrlBackspace
Modifica
13 scorciatoie
Modifica cella attiva
F2
WinF2MacF2LinuxF2
Annulla
CtrlZ
WinCtrlZMac⌘ZLinuxCtrlZ
Ripeti
CtrlY
WinCtrlYMac⌘YLinuxCtrlY
Taglia
CtrlX
WinCtrlXMac⌘XLinuxCtrlX
Copia
CtrlC
WinCtrlCMac⌘CLinuxCtrlC
Incolla
CtrlV
WinCtrlVMac⌘VLinuxCtrlV
Paste values only
CtrlShiftV
WinCtrlShiftVMac⌘ShiftVLinuxCtrlShiftV
Riempi in basso
CtrlD
WinCtrlDMac⌘DLinuxCtrlD
Riempi a destra
CtrlR
WinCtrlRMac⌘RLinuxCtrlR
Insert new line in cell
AltEnter
WinAltEnterMac⌃⌥EnterLinuxAltEnter
Delete cell contents
Elimina
WinEliminaMacEliminaBackspaceLinuxElimina
Trova e sostituisci
CtrlH
WinCtrlHMac⌘HLinuxCtrlH
Trova
CtrlF
WinCtrlFMac⌘FLinuxCtrlF
Formattazione
11 scorciatoie
Grassetto
CtrlB
WinCtrlBMac⌘BLinuxCtrlB
Corsivo
CtrlI
WinCtrlIMac⌘ILinuxCtrlI
Sottolineato
CtrlU
WinCtrlUMac⌘ULinuxCtrlU
Barrato
AltShift5
WinAltShift5Mac⌥Shift5LinuxAltShift5
Format as currency
CtrlShift4
WinCtrlShift4Mac⌘Shift4LinuxCtrlShift4
Format as percentage
CtrlShift5
WinCtrlShift5Mac⌘Shift5LinuxCtrlShift5
Format as date
CtrlShift3
WinCtrlShift3Mac⌘Shift3LinuxCtrlShift3
Allinea a sinistra
CtrlShiftL
WinCtrlShiftLMac⌘ShiftLLinuxCtrlShiftL
Allinea al centro
CtrlShiftE
WinCtrlShiftEMac⌘ShiftELinuxCtrlShiftE
Allinea a destra
CtrlShiftR
WinCtrlShiftRMac⌘ShiftRLinuxCtrlShiftR
Cancella formattazione
Ctrl\
WinCtrl\Mac⌘\LinuxCtrl\
Righe e colonne
8 scorciatoie
Insert row above
CtrlAltShift=
WinCtrlAltShift=Mac⌘⌥Shift=LinuxCtrlAltShift=
Insert column left
CtrlAlt=
WinCtrlAlt=Mac⌘⌥=LinuxCtrlAlt=
Delete row
CtrlAlt-
WinCtrlAlt-Mac⌘⌥-LinuxCtrlAlt-
Select entire row
ShiftSpace
WinShiftSpaceMacShiftSpaceLinuxShiftSpace
Select entire column
CtrlSpace
WinCtrlSpaceMac⌃SpaceLinuxCtrlSpace
Hide row
CtrlAlt9
WinCtrlAlt9Mac⌘⌥9LinuxCtrlAlt9
Hide column
CtrlAlt0
WinCtrlAlt0Mac⌘⌥0LinuxCtrlAlt0
Group rows/columns
AltShiftRight
WinAltShiftRightMac⌥ShiftRightLinuxAltShiftRight
Formule
6 scorciatoie
Show all formulas
Ctrl`
WinCtrl`Mac⌃`LinuxCtrl`
Inserisci data corrente
Ctrl;
WinCtrl;Mac⌘;LinuxCtrl;
Inserisci ora corrente
CtrlShift;
WinCtrlShift;Mac⌘Shift;LinuxCtrlShift;
Toggle absolute/relative reference
F4
WinF4MacF4LinuxF4
Sum selected cells
Alt=
WinAlt=Mac⌘ShiftTLinuxAlt=
Insert comment
CtrlAltM
WinCtrlAltMMac⌘⌥MLinuxCtrlAltM
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.
