I do consulting and training on MS Excel, Business Intelligence Dashboards,
Business Plans / Financial Models and PowerPoint Presentations
I am putting together everything about Excel and PowerPoint Presentations
that I have learnt (and still learning) on this blog
No it is not magic, but a simple macro!
The unhide box (appears when you select unhide from the right click menu on the sheet tab) does not allow you to select multiple sheet names
Sub Unhideallsheets() For Each Wrksheet In ActiveWorkbook.Worksheets Wrksheet.Visible = True Next Wrksheet End Sub
All you need to do is to paste this code in the code window and run it whenever you want to unhide multiple sheets
Recently I was getting a model vetted from my girl friend! She saw a set of pivot tables and asked: How do you turn off the irritating GETPIVOTDATA function?
I traded off the quick tip with some awesome stuff ! 😆 And for you my friend.. it is on the house 😎Read More
I recently worked on a consulting project where I had to deliver a corporate presentation. The client had to impress its peers in Singapore. I thought what better way than creating some interesting animations and one of them was to display the logos in a tray like look 😎Read More
I guess I don’t have to say much to get your interest!! Interested..? Ok lets begin! 🙂Read More
A while ago I wrote a post on how to use custom formatting in excel. Let’s take a look at some interesting custom formatting codes for datesRead More