Guest Posts Archives - Excel TV
Excel TV
Share The LOVE

Category Archives for Guest Posts

Are Your Formulas All "Wrapped" Up?

The other day, there was a discussion on one of the LinkedIn Excel Groups regarding wrapping formulas in the formula bar. Today. I’ll take a look at wrapping and indenting formulas complete with screen shots and a workbook you may download at the end. The Data First, I’ll need some data. I use Dick Kusleika’s […]

Continue reading

Are Your Formulas All "Wrapped" Up?

The other day, there was a discussion on one of the LinkedIn Excel Groups regarding wrapping formulas in the formula bar. Today. I’ll take a look at wrapping and indenting formulas complete with screen shots and a workbook you may download at the end. The Data First, I’ll need some data. I use Dick Kusleika’s […]

Continue reading

Gangnam Cell Styles…Delete

A reader on one of the LinkedIn Excel Groups recently asked how to delete cell styles from a workbook. Today, I’ll show a possible solution. The Cell Styles Group: List Cell Styles: I opened a workbook, Alt+F11 for the Visual Basic Editor and cooked up the code below. I then opened another workbook and made […]

Continue reading

Are You Series(ous)?

Do you work with different series in your Excel charts? Here is what I would like the final chart to loo like. Note the white dashed lines in front of the columns: Setup: I started with the chart I ended with in my last post, Points Of Interest. I then added some data to a separate […]

Continue reading

Points Of Interest

Hello World! (Sorry, I could not resist J) I was recently asked by our host, Jordan, if I would be interested in being a guest author here at Option Explicit VBA. I quickly and humbly accepted. I will strive to do my best to add something of value. Let’s dive right in.I was inspired the […]

Continue reading

Guest Post #1 – Dynamic Funnel Chart

Reader, Bert van Zandbergen, from Beekbergen, The Netherlands (Holland) sent me his own cool creation based on the Rollover technique I created. I asked if I could post his work to this blog to which he graciously agreed. Below is his write up. Some of the Excel functions below are in Dutch (which I think is […]

Continue reading
>