Keep up to date with every new upload!

Join free & follow Chandoo.org Podcast - Become A
Share
  • 4 years ago
CP031: Invisibility Tricks – How to make things disappear in Excel?

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

Comments