Formatting & Tricks

Conditional Formatting

Highlight cells containing specific text

 

Sheet Formatting

Consolidate function
Go To Special
Gridlines
Grouping and outlining

 

Data manipulation

Manipulating text

 

Commands

Filter by current selection

 

Shortcuts

Keyboard shortcuts
Quick Access Toolbar

 

Pictures

Insert pictures into a cell
Insert data from picture

 

Troubleshooting

Excel found unreadable content in the file
Remove E+11 and E+12 values
Errors when modifying / deleting a custom slicer style