Learn how to add colour, borders and alignment settings to your Excel data to give your worksheet a more professional look and to make it easier for others to read. Read more
Category: Formatting
Add dollar signs, percentage signs and decimal places to Excel data

Formatting lets you change the appearance of data to control exactly how Excel will display the data on a worksheet.
An example of formatting is to add dollar signs, percentage signs and decimal places to Excel data. Continue Reading
Excel – Working with merged cells (merging and fixing problems)
Ever tried to centre a heading over the top of a number of columns? It can be a little frustrating, especially when you can’t quite get it to sit as you would like. Last month saw me running multiple Stage 1 Excel courses and it reminded me that this problem frustrates so many. I love hearing the “oh wows” when I show the class how the Merge and Center command allows you to easily centre headings over tables of data. Read more
