Paste Special

Using Paste Special This quick video explains using Paste Special in Excel. The Paste Special button allows us to change the behavior of the standard Paste command – and includes special features allowing us to transpose cells, copy just the values (without the...

Format Painter

The Format Painter This quick video explains The Format Painter If you have created a format including the colour, font and background colour and border of a cell and wish to copy it to another cell or range of cells – you can do so using the Format Painter tool....