Hiding Multiple Sheets in Excel Using xlVeryHidden

Flexible solution

It is easy to hide multiple sheets in Excel. Unfortunately, it now just as easy to unhide those sheets. You can hide sheets and make it harder to unhide them. You can use a setting called xlVeryHidden (no kidding) that won’t display the sheet name if you right click a sheet tab and choose unhide sheets.

The myth is that there isn’t enough time. There is plenty of time. There isn’t enough focus with the time you have. You win by directing your attention toward better things.

James Clear

Excel Has Ordinals

Woohoo, I don’t know when this happened, but you can now get Excel to extend your ordinals when you drag with the Fill Handle and use things like 1st, 2nd, 3rd and 4th etc.

Type 1st January in a cell and drag the cell down.

It seems to work with ordinals at the start rather than at the end of a text string. So January 1st doesn’t work. 1st by itself does work.

Improvement to Excel’s HYPERLINK Function

Excel’s HYPERLINK function is not easy to use. You need to know a few of its secrets to get it to do what you want. Unfortunately, you can’t replicate the HYPERLINK function in a custom function, so we can’t improve it. But the next best thing is to simplify creating the reference you need as the first argument in the HYPERLINK function.

Benford’s Law in Excel – Part Two

Benford’s law is used in auditing to identify data sets that may have been manipulated or adjusted. In my previous post I created a report to analyse a data set based on Benford’s Law. In this post we will create a single formula to create the report and then convert that into a custom function.

Benford’s Law in Excel – Part One

Benford’s law is used in auditing to identify data sets that may have been manipulated or adjusted. In actual data sets when reviewing values the 1st digit of the values tends to follow a predetermined frequency. For example, roughly 30% of the values should start with a 1.

If you’re willing to consider failure as a blessing in disguise and bounce back, you’ve got the potential of harnessing one of the most powerful success forces.

Joseph Sugarman

Don’t rush, but don’t wait. Act with urgency, but release yourself from the need to achieve it on a particular timeline. When you think longer term than most, you can think bigger than most.  If it takes years, start now.
James Clear
Do not spoil what you have by desiring what you have not; remember that what you now have was once among the things you only hoped for.
Epicurus – Greek philosopher