Blog


Excel - Calculating Pi

Excel - Calculating PiIf you are finding the inbuilt excel function for =Pi() is just a bit too dull, there a handy function to calculate Pi on the fly. You may want to use it sparingly though, too many times in one spreadsheet or to many decimal places and you'll grind to a halt as it is a bit processor hungry!: Function myPi(places) 'Places is the number of   more »

Tags : excel pi formula


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