Blog


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   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.   more »



Make a cell look like a button in Excel

Make a cell look like a button in ExcelThere a sometimes in excel where you want to create a button but you don't want to introduce VB into your workbook (there are many reasons not to) - heres how. I'm a great advocate of not using VBA / macros when you don't have to - they are not widely understood, easy to break when you alter the workbook and introduce a plethora of   more »



Excel - Unhide all sheets

Excel - Unhide all sheetsThis little sub quickly unhides all hidden sheets (including xlVeryHidden). I use it frequently as people tend to hide worksheets which are no longer needed rather than just delete them, also especially useful when trying to dissect other peoples creations. It also has some sneaky uses, I regularily come across people who like to protect the   more »



Share page

Subscribe to newsletter

Search Posts

Back to top