Skip to content
CP031: Invisibility Tricks – How to make things disappear in Excel? episode artwork

Mar 5, 2015 24 min

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

from Chandoo.org Podcast - Become Awesome in Data Analytics Hosted by Chandoo

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.

Episode details come from the podcast's RSS feed.

Embed this episode

Ready to play

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

0:00 24:46

No transcript yet.

Requests help us decide what to transcribe next.

Frequently asked questions

How long is this episode of Chandoo.org Podcast - Become Awesome in Data Analytics?

This episode is 24 minutes long.

When was this Chandoo.org Podcast - Become Awesome in Data Analytics episode published?

This episode was published on March 5, 2015.

Can I download this Chandoo.org Podcast - Become Awesome in Data Analytics episode?

Yes. Use the download control on the episode player to save the publisher-provided media file.