How to Use Colour Scales in Excel

How to use Colour Scales in Excel This quick video explains how to use Colour Scales in Excel. Colour scales or heat maps are a useful way to highlight values in a range of cells. Built-in heat maps allow you to apply different schemes dependent on the rules you wish...

How to remove # symbols from Excel

How to Remove the #### Symbols in Excel This quick video explains how to Remove the #### Symbols from your Excel worksheet. Removing symbols from Excel. Seeing ##### (hash) symbols in your spreadsheet is very common. Learn what causes it to happen and how to remove...

How to insert page breaks in Excel

How to insert page breaks in Excel This quick video will teach you how to insert Page Breaks manually in your spreadsheet. If you find that you have straggling rows or columns in your spreadsheet – you may need to insert a page-break at an earlier point in your...

Margins, Orientation and Page size

Margins, Orientation and Page size This quick video explains how you alter the margins, orientation and page size in the Excel worksheet. Within the page layout tab – there is a section called Page Setup which allows us to alter the margins, orientation and page size....

How to repeat a row on a document as it is printing

How to Repeat a Row on a document as it is printing This quick video explains how to repeat a row on a document as it is printing Learn how to repeat a column or row headings or titles on each page of a document as it is printing. This is useful for multi-page...

Multiple headings in table

Multiple Headings in a Pivot Table This quick video explains how to have Multiple Headings in a Pivot Table. We can add additional fields to create additional columns and rows to our Pivot Table. This creates different levels of grouping within our pivot table....