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.

Student IT Services

Boole Basement, University College Cork, College Rd.