Articles


Create your own custom formatting shortcut in excel

Create your own custom formatting shortcut in excelLike with most things in life, the longer you do something for the more you get set in your ways. Excel is no exception and if I'm a sucker for anything it's number formatting. Maybe it's the accountant in me, but I think negative numbers are easier to read and look far more stylish wiht a bracket around them. Then if you are going to use a   more »



How to reset the default cell formatting in an Excel spreadsheet

How to reset the default cell formatting in an Excel spreadsheetOne of the more irritating things you can come across in someones elses spreadsheet (on the basis that I've never managed to reproduce it myself) is when somehow the default style has been changed to spit out a daft format of 00:00:00 for seemingly any number. This is especially apparant of you are a regular user of the clear formats function. It   more »



Search Posts

Back to top