Centre A Title Across A Worksheet

Its really easy to make your spreadsheets look more professional by centering your tittle across the top of your sheet. In the example our heading for our sales sheet is 'SalesWidgets Inc'.  This...

Conditional Formatting Basics

This is a really useful function in Excel where you can format cells dependent on their content.  if you are new to this feature then this is the best place to start, once you master the basic...

Protect A Workbook

Excel offers numerous levels of protection for your work.   You can protect a whole workbook, worksheet, columns, rows or even individual cells. If you want to prevent other user opening your whole...