Excel Shortcuts and Formulas Reference Guide – EBM Diligent Help Center

This reference guide provides essential keyboard shortcuts and formulas to streamline your Excel workflow. Whether you're navigating large datasets, formatting cells, or building complex formulas, these tools will help you work more efficiently and reduce reliance on mouse-based navigation.

Excel Keyboard Shortcuts

Use this guide as a quick reference to accelerate repetitive tasks, improve accuracy, and unlock Excel's full capabilities. These shortcuts are organized by function for easy lookup.

Essential Operations

Action	Keystroke
Toggle between applications	`Alt` + `Tab`
Edit active cell	`F2`
Copy / Cut	`Ctrl` + `C` / `Ctrl` + `X`
Auto Sum	`Alt` + `=`
Fill Down	`Ctrl` + `D`
Fill Right	`Ctrl` + `R`
Save	`Ctrl` + `S`
Anchor Cells (toggle absolute reference)	`F4`
Undo / Redo	`Ctrl` + `Z` / `Ctrl` + `Y`
Open Paste Special	`Ctrl` + `Alt` + `V`

Cell Formatting

Action	Keystroke
Bold	`Ctrl` + `B`
Italics	`Ctrl` + `I`
Underline	`Ctrl` + `U`
Open Format Cells dialog	`Ctrl` + `1`
General formatting	`Ctrl` + `Shift` + `!`
Currency formatting	`Ctrl` + `Shift` + `$`
Percent formatting	`Ctrl` + `Shift` + `%`
Remove borders	`Ctrl` + `Shift` + `_`
Open border selection	`Alt` + `H`, `B`

Paste Special Options

Action	Keystroke
Paste formulas	`Alt` + `H`, `V`, `F`
Paste values	`Alt` + `H`, `V`, `V`
Paste transpose	`Alt` + `H`, `V`, `T`

Navigation

Action	Keystroke
Move between sheets	`Ctrl` + `PgUp` / `Ctrl` + `PgDn`
Go To dialog	`Ctrl` + `G`
Move to cell A1	`Ctrl` + `Home`
Move to end of current data region	`Ctrl` + `Arrow Key`
Move to end of worksheet data	`Ctrl` + `End`
Move to last sheet	Hold `Ctrl`, click right with mouse
Scroll multiple sheets	Hold `Shift`, click right with mouse

Selection and Highlighting

Action	Keystroke
Highlight row	`Shift` + `Spacebar`
Highlight column	`Ctrl` + `Spacebar`
Highlight to end of data	`Ctrl` + `Shift` + `Arrow`
Select all	`Ctrl` + `A`
Highlight discontinuous ranges	`Shift` + `F8`

Worksheet Formatting

Action	Keystroke
Group / Ungroup cells	`Shift` + `Alt` + `→` / `Shift` + `Alt` + `←`
Insert row	`Ctrl` + `Shift` + `+`
Delete row	`Ctrl` + `Shift` + `-`
Hide row	`Ctrl` + `9`
Hide column	`Ctrl` + `0`

Auditing

Action	Keystroke
Show formulas	`Ctrl` + `~`
Go to precedents	`Ctrl` + `[`
Go to dependents	`Ctrl` + `]`

Tables and Filters

Action	Keystroke
Create table	`Ctrl` + `T`
Add filters	`Alt` + `A`, `T`
Clear filters	`Alt` + `A`, `C`
Enter dropdown menu	`Alt` + `Down Arrow`
Select/Unselect in dropdown	`Spacebar`

Other Useful Shortcuts

Action	Keystroke
Find	`Ctrl` + `F`
Right-click menu	`Shift` + `F10`
Repeat last command	`Ctrl` + `Y`

Full shortcut reference: https://exceljet.net/keyboard-shortcuts

Excel Formulas

Mastering these formulas will significantly reduce time spent on routine operations and minimize errors in your spreadsheets. Content is grouped by category to help you quickly find the tools you need for any task.

Lookup Functions

Formula	Description
`=XLOOKUP()`	Returns first match in a range or array
`=VLOOKUP()`	Vertical lookup
`=HLOOKUP()`	Horizontal lookup
`=INDEX()`	Returns value/reference at intersection
`=MATCH()`	Returns relative position of item
`=INDEX(MATCH())`	Combination for advanced lookups

Conditional Functions

Formula	Description
`=IF()`	Logical if statement
`=SUMIF()` / `=SUMIFS()`	Sum if criteria met (single/multiple conditions)
`=COUNTIF()`	Counts cells that meet condition
`=IFERROR()`	Returns preset value if error
`=IFNA()`	Returns preset value if #N/A error

Text Functions

Formula	Description
`=CONCATENATE()`	Combine cells to create unique ID
`=(cell)&(cell)`	Combine cells (alternative method)
`=PROPER()`	First letter capitalized
`=LEFT()`	Returns characters from the left
`=RIGHT()`	Returns characters from the right
`=MID()`	Returns characters from the middle
`=LEN()`	Returns length of string
`=TRIM()`	Removes spaces in string
`=FIND()`	Returns starting position of substring

Array Functions

Formula	Description
`=TRANSPOSE()`	Convert horizontal to vertical (or vice versa)
Array formula entry	Any formula + `Ctrl` + `Shift` + `Enter`

Comparison Operators

Operator	Meaning
`>`	Greater than
`<`	Less than
`>=`	Greater than or equal to
`<=`	Less than or equal to
`<>`	Does not equal
`"text"`	Return text string

Full formula reference: https://exceljet.net/formulas

For advanced tutorials and additional resources, visit the links provided above.

Related to