rows/columns/ranges
Ctrl + Space – Select the whole column
Shift + Space – Select the whole row
Ctrl + A / Ctrl + Shift + Space – Select all (Click once to select the current range, click twice to select the entire worksheet)
Ctrl + Shift + Arrow keys – Select a range – from the selected cell to the end of the range
Ctrl + Arrow keys – Go the end of the range
Alt + ; (Semicolon) – Select visible cell only
Ctrl + – (Minus) – Delete cells/ rows/ columns
Ctrl + Shift + = – Insert cells/rows/columns
Workbooks/Worksheets
CTRL + N – Open a new Workbook
Ctrl + O – Open an existing Workbook
Ctrl + S – Save Workbook (Or Save As, if it’s the first time you’re saving it)
F12 – Save As (Even if you already saved it!)
CTRL + P – Print
CTRL + F4 / CTRL + W – Close Workbook
ALT + F4 – Close Excel (All workbooks)
Shift + F11 – Add a new Worksheet
Data entry
Ctrl + : (Colon) – Today’s date
Ctrl + Shift + : (Colon) – Current time
Ctrl + D – Copy the cell above
Ctrl + R – Copy the cell to the left
F2 – Edit cell / view cell formula
F4 – (When editing a specific cell) Apply absolute/mixed/relative reference (For example, cell C4 will change to $C$4 – Absolute Reference)
F7 – Open the spelling tool
CTRL + E – Flash Fill – One of Excel’s greatest tools for auto-completing data based on examples from adjacent cells.
Ctrl + C – Copy
Ctrl + V – Paste
Ctrl + X – Cut
Ctrl + Shift + V – Paste Special
Formulas
Ctrl + ~ (Tilde) – Shows all the formulas in the sheet
F4 – (When a cell is not being edited) Repeats the last action
Ctrl + Shift + Enter -Apply an array formula
Ctrl + T – Define range as data table
Alt + = – Quick sum
/
Navigation
Ctrl + F – Find
Ctrl + H – Find and Replace
Ctrl + PgUp/PgDn – Navigate between sheets
Ctrl + Z – Undo last action
Ctrl + Y – Redo (Ctrl + Z)
Ctrl + [ – Takes you to the cell referenced by the formula
Ctrl + ] – Takes you to the cell which is affected by the current cell
F5 , then Enter (not together) – Takes you back to where you were before using ctrl + [
Ctrl + Home / Ctrl + End – Go to the first cell in worksheet (A1) / Go to the last cell in the used range
Ctrl + Arrow Keys – Go to the last non-empty cell (Stops when you reach an empty cell)
Shift + Arrow Keys – Select cells in the direction of the Arrow Keys (One at a time)
Ctrl + Shift + Arrow Keys – Select cells until the last non-empty cell (Stops when you reach an empty cell)
Scroll Lock – Disable Scrolling in your Excel Workbook. Usually helpful when the Workbook is not scrolling.
Cell editing
Please note – These shortcuts will work when editing a specific cell. If you try these shortcuts when you’re not editing a cell, they will work differently!
F2 – Edit the selected cell (instead of double-clicking it)
Shift + F2 – Add a comment
Alt + Enter – Line break – Start a new line in the current cell
HOME – Go to the beginning of the current row within the cell which is being edited
Ctrl + HOME – Go to the beginning of the edited cell
END – Go to the end of the current row within the cell which is being edited
Ctrl + END – Go to the end of the edited cell
F9 – Shows the result of the function/part of it (Based on what is selected)
Cell Formatting
Ctrl + 1 – Open Cell Formatting window
CTRL + B – Bold text
CTRL + U – Underlined Text
CTRL + I – Italic Text
Ctrl + 5 – Strikethrough
Other important shortcuts
Ctrl + Shift + L – Apply filtering on the current range
ALT + F11 – Open Visual Basic Editor
Posts
No comments:
Post a Comment