CP031: Invisibility Tricks – How to make things disappear in Excel?

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

The post CP031: Invisibility Tricks – How to make things disappear in Excel? appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.