Guia del cheat sheet
Excel atajos que conviene aprender primero
Esta pagina reune 29 atajos de teclado buscables para Excel en 5 categorias. Empieza por las categorias principales y despues imprime la ficha si quieres tenerla a mano.
- Cambia de pestana OS para ver atajos de Windows, macOS o Linux.
- Usa / para ir directamente a la busqueda.
- Usa el modo comparar cuando trabajes entre equipos.
- Imprime o guarda la pagina como PDF compacto.
Workbook & Files
5 shortcuts
Create new workbook
Ctrl+N
WinCtrl+N
Mac⌘N
Linux—
Open workbook
Ctrl+O
WinCtrl+O
Mac⌘O
Linux—
Save workbook
Ctrl+S
WinCtrl+S
Mac⌘S
Linux—
Imprimir workbook
Ctrl+P
WinCtrl+P
Mac⌘P
Linux—
Cerrar workbook
Ctrl+W
WinCtrl+W
Mac⌘W
Linux—
Navegacion
7 shortcuts
Move one cell up
↑
Win↑
Mac↑
Linux—
Move one cell down
↓
Win↓
Mac↓
Linux—
Move to edge of data region
Ctrl+Arrow
WinCtrl+Arrow
Mac⌘Arrow
Linux—
Go to cell A1
Ctrl+Home
WinCtrl+Home
MacFn+Ctrl+←
Linux—
Go to last used cell
Ctrl+End
WinCtrl+End
MacFn+Ctrl+→
Linux—
Next worksheet
Ctrl+PageDown
WinCtrl+PageDown
MacFn+Ctrl+↓
Linux—
Previous worksheet
Ctrl+PageUp
WinCtrl+PageUp
MacFn+Ctrl+↑
Linux—
Edicion
7 shortcuts
Edicion active cell
F2
WinF2
MacCtrl+U
Linux—
Fill down
Ctrl+D
WinCtrl+D
Mac⌘D
Linux—
Fill right
Ctrl+R
WinCtrl+R
Mac⌘R
Linux—
Insert current date
Ctrl+;
WinCtrl+;
MacCtrl+;
Linux—
Insert current time
Ctrl+Shift+;
WinCtrl+Shift+;
Mac⌘;
Linux—
Deshacer
Ctrl+Z
WinCtrl+Z
Mac⌘Z
Linux—
Rehacer
Ctrl+Y
WinCtrl+Y
Mac⌘Y
Linux—
Formulas
5 shortcuts
Start formula
=
Win=
Mac=
Linux—
AutoSum
Alt+=
WinAlt+=
Mac⌘⇧T
Linux—
Show formulas
Ctrl+`
WinCtrl+`
MacCtrl+`
Linux—
Calculate worksheets
F9
WinF9
MacF9
Linux—
Insert function
Shift+F3
WinShift+F3
MacShift+F3
Linux—
Formato
5 shortcuts
Negrita
Ctrl+B
WinCtrl+B
Mac⌘B
Linux—
Cursiva
Ctrl+I
WinCtrl+I
Mac⌘I
Linux—
Subrayado
Ctrl+U
WinCtrl+U
Mac⌘U
Linux—
Format cells dialog
Ctrl+1
WinCtrl+1
Mac⌘1
Linux—
Apply percent format
Ctrl+Shift+%
WinCtrl+Shift+%
Mac⌃⇧%
Linux—
Preguntas frecuentes
What is the fastest way to find Excel shortcuts on this page?
Use the search box or press /, then type an action such as create new workbook.
Can I print this Excel shortcut cheat sheet?
Yes. Use the Print / PDF button or your browser print command to save a compact cheat sheet.
Does this page include Windows and Mac shortcuts for Excel?
Yes. Use the OS tabs to switch between Windows and macOS shortcuts. For example, Create new workbook is Ctrl+N on Windows and ⌘N on macOS where available.
Advertisement