Cheatsheet Microsoft Excel
Folha de cálculo da Microsoft para dados, fórmulas e gráficos
Microsoft Excel
file
New Workbook
Ctrl + N
Creates a new blank workbook.
Close Workbook
Ctrl + W
Closes the active workbook.
Open
Ctrl + O
Opens an existing file.
Ctrl + P
Opens the print options.
Save
Ctrl + S
Saves the current workbook.
New Sheet Tab
Shift + F11
Inserts a new worksheet.
Save As
F12
Opens the "Save As" dialog.
Switch Between Sheets
Ctrl + Page Up (previous)
Ctrl + Page Down (next)
Navigates between sheet tabs.
Edition
Copy / Cut / Paste
Ctrl + C (copy)
Ctrl + X (cut)
Ctrl + V (paste)
Clipboard operations.
Edit Cell
F2
Activates the cell edit mode.
Undo / Redo
Ctrl + Z (undo)
Ctrl + Y (redo)
Revert or reapply actions.
Insert Line Break
Alt + Enter
New line inside the same cell.
Fill Down
Ctrl + D
Copies the content of the cell above.
Clear Content
Delete
Clears the content without removing formatting.
Fill Right
Ctrl + R
Copies the content of the cell to the left.
Paste Special
Ctrl + Alt + V
Pastes only values, formats, formulas, etc.
Formatting
Bold / Italic / Underline
Ctrl + B (bold)
Ctrl + I (italic)
Ctrl + U (underline)
Text formatting.
Increase / Decrease Decimal
Ctrl + Shift + . (increase)
Ctrl + Shift + , (decrease)
Adjusts decimal places.
Number Format
Ctrl + Shift + 1 (number)
Ctrl + Shift + 4 (currency €)
Ctrl + Shift + 5 (percentage)
Ctrl + Shift + 3 (date)
Quick number formats.
Alignment
Ctrl + L (left)
Ctrl + E (center)
Ctrl + G (right)
Align cell content.
Borders
Ctrl + Shift + &
Applies a border to all selected cells.
Format Cells (Dialog)
Ctrl + 1
Opens the "Format Cells" dialog.
Navigation
Go to Cell A1
Ctrl + Home
Jumps to the beginning of the sheet.
Move Between Sheet Tabs
Ctrl + Page Up / Page Down
Switches between the workbook sheets.
Go to Last Used Cell
Ctrl + End
Jumps to the last cell with data.
Formula Bar
Ctrl + Shift + U
Expands/collapses the formula bar.
Edge of Data Region
Ctrl + Arrow Keys
Moves to the edge of the data region.
Go to Specific Cell
Ctrl + G (or F5)
Opens "Go To" (type a reference).
Selection
Select All
Ctrl + A
Selects the whole sheet or the data region.
Add to Selection
Shift + F8
Activates "add to selection" mode.
Select Row / Column
Shift + Space (row)
Ctrl + Space (column)
Selects the entire row or column.
Select Visible Cells
Alt + ;
Selects only visible cells (ignores hidden ones).
Select to AS End
Ctrl + Shift + Arrow Keys
Extends the selection to the edge of the data.
Select up to A1
Ctrl + Shift + Home
Selects from the current cell to A1.
Formulas and Data
Insert Function
Shift + F3
Opens the function wizard.
Show Formulas
Ctrl + ` (backtick)
Toggles between values and formulas.
AutoSum
Alt + =
Inserts =SUM() with an automatic range.
AutoFill
Ctrl + Enter
Fills the selection with the current value.
Insert Array Formula
Ctrl + Shift + Enter
Confirms the an array formula (CSE).
Current Date and Time
Ctrl + ; (date)
Ctrl + Shift + ; (time)
Inserts the system date/time.
Toggle Absolute Reference
F4
Cycles between A1, $A$1, A$1, $A1.
Rows and Columns
Insert Row/Column
Ctrl + Shift + +
Inserts a row or column (depending on selection).
Group / Ungroup
Alt + Shift + → (group)
Alt + Shift + ← (ungroup)
Creates an outline structure.
Delete Row/Column
Ctrl + -
Deletes the selected row or column.
Adjust Column Width
Alt + H, O, I
AutoFits to the selection.
Hide / Unhide Rows
Ctrl + 9 (hide)
Ctrl + Shift + 9 (unhide)
Hides or reveals rows.
Hide / Unhide Columns
Ctrl + 0 (hide)
Ctrl + Shift + 0 (unhide)
Hides or reveals columns.
Advanced
Insert Chart
Alt + F1
Creates a chart with the selected data.
VBA Editor
Alt + F11
Opens the Visual Basic editor.
AutoFilter
Ctrl + Shift + L
Toggles filters on the table.
Freeze Panes
Alt + W, F, F
Freezes rows/columns at the cursor.
Table (Formatting)
Ctrl + T
Converts the selection into a formatted table.
Find and Replace
Ctrl + F (find)
Ctrl + H (replace)
Search and replace content.
Record Macro
Alt + F8
Opens the macro manager.
Hyperlink
Ctrl + K
Inserts a hyperlink in the cell.