Formatting in Excel seems to be a topic of interest for users at all levels of expertise. In this post I look at three different areas – formatting basics, formatting a report and formatting cells; so there should be something for everyone. Continue reading
Tag Archives: Formatting
Trim Your Selected Data
Do you find yourself having to apply Excel’s TRIM function to columns of data from another data source? The following macro will trim your selected data, i.e. remove blanks from the start or end of each cell. This method can also be adapted to other situations like formatting text or performing calculations. Continue reading
Power Comparison
Almost two years ago I signed up to a two year fixed pricing contract for my power prices. At that time I did a power comparison of various electricity providers using Excel. Now I have to repeat the process as the prices will be changing shortly. The Consumer Powerswitch website is very helpful. This is a good opportunity to apply the post on simple formulas. Continue reading