How do I change the default background colour of Textboxes in Excel? At the moment mine defaults to a yellow background and I want it to default to Automatic (white).
I can do it individually after creating the Texboxes with right clicking at a corner of each box, but not worked out how to do it by default.
I'm using Excel 2013 I think.
Thanks.
Replies (3)
Please login or register to join the discussion.
Never used this feature before - didn't even know it existed. Why not type into a cell?
Regardless, if you format the textbox the way you want it. Select it (click on one of the wee circles). Right click and there should be an option to "set as Default".
I use Excel 2010. This works
Click, Insert, Text Box, drag and drop. Change the colour etc
Click the newly created and formatted text box.
Right click it, to select pop-up box.
Select, 'Set as default text box' from the pop-up menu