Excel Tips & Tricks
- Line breaks
Start a new line of text within a cell in excel using these instructions.
- Freeze panes
Freeze panes to lock rows and columns. To keep an area of a worksheet visible while you scroll to another area of the worksheet, see Excel's freeze panes option.
- Conditional formatting
Add visual cues to make your data easier to understand using Excel's conditional formatting.
- Paste Special
When you use Copy and then Paste in Excel, by default it will paste everything (formatting, formulas etc.). If this is not what you want (e.g. the result of a formula but not the formula), then use Paste Special.