CP031: Invisibility Tricks – How to make things disappear in Excel?
Chandoo.org Podcast - Become Awesome in Data Analytics - A podcast by Chandoo - Thursdays
Categories:
In the 31st session of Chandoo.org podcast, let's disappear. What is in this session? Spreadsheets are complex things. They have outputs, calculation tabs, inputs, VBA code, from controls, charts, pivot tables and occasional picture of hello kitty. But when it comes to making a workbook production ready, you may want to hide away few things so it looks tidy. That is our topic for this podcast session. In this podcast, you will learn Quick announcements first anniversary of our podcast etc. Hiding cells, rows, columns & sheets Hiding chart data points On/off effect with form controls, conditional formatting Making objects, charts, pictures disappear Disabling grid-lines, formula bar & headings Hiding things in print