by Allen Wyatt
(last updated June 9, 2018)
When Gary adds a shape to a worksheet, Excel automatically fills it with a color that he can then change. The problem is that Gary doesn't want the shapes filled with any color; he wants them empty, by default. He wonders if there is a way to change the default for shapes so that they don't have a fill color.
There are a few ways you can approach a solution to this issue. First, if you want to affect just the current workbook, then you can set the default format for your shapes, which includes the fill they use. To set the default, simply format a shape the way you want and then right-click on the border of the shape. In the Context menu that appears, choose the Set As Default Shape option. Now, anytime you are working with this particular worksheet, Excel remembers the formatting you want used for any new shapes you add.
The second approach is to create a theme that reflects how you want shapes to appear. Excel uses themes to define the colors, fonts, and effects available within a workbook. By default, every workbook has a theme associated with it; the default theme is called Office Theme. You can choose a different theme by displaying the Page Layout tab of the ribbon and using the Themes tool to choose which one you want used.
With a theme applied (or the default theme, if you don't explicitly apply another theme), you can start to make changes to the theme. If all you want to do is affect the fill color used for shapes, follow these general steps:
Now, with your theme saved (which includes the default formatting for your shapes), you can apply the theme to other workbooks. Once applied, any shapes you add to those other workbooks will reflect the formatting you created and saved in the theme.
Note that this approach doesn't provide for the unfilled shapes to be the default for all new workbooks; you still need to apply the theme you created. If you want to remove even that one necessary step, you can follow these general steps:
If you are unsure of where the XLStart folder is located (step 6), use Windows to search for the folder. Its exact location can vary depending on how Excel was installed on your machine. The folder is normally in the same folder where Excel was installed on your system, but it may not be. (Thus the suggestion to search.)
Now, when you restart Excel, the template you just created and saved is used as the default template for your new workbooks. That means that it will already have your custom theme applied, which controls whether your shapes are filled or not.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (12641) applies to Microsoft Excel 2007, 2010, 2013, and 2016.
Solve Real Business Problems Master business modeling and analysis techniques with Excel and transform data into bottom-line results. This hands-on, scenario-focused guide shows you how to use the latest Excel tools to integrate data from multiple tables. Check out Microsoft Excel 2013 Data Analysis and Business Modeling today!
Excel makes it rather easy to add shapes to your worksheets. If you add a lot of shapes, you quickly discover that it can ...Discover More
Excel provides some great tools that allow you to create amazing charts based on data in your worksheets. Once your ...Discover More
Don't like the color of the lines that Excel chose for your drawing object? It's easy to choose your own colors, as ...Discover More
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.