Removing Array Formulas Around Your Excel Charts and Dashboards

Yesterday I posted a quick tutorial on protecting your Excel Dashboard Charts by using Array Formulas.

You can check out that posting here:

Protecting Your Excel Charts and Dashboards with Array Formulas

Well I guess I forgot to tell you how to remove the Array Formulas from around your Excel Charts.  Sorry Sad smile

Here is a quick video showing you the trick.  (Hint, the trick is that you have to highlight and delete the entire array area in the spreadsheet.  The video shows you how to make sure you know what is the exact range).

Check it out:


Thanks for the feedback in my YouTube Comments!


C:\Users\SteveT\Documents\Niche Websites\ExecutiveDashboard\Blog Posts