Excel Textbox question

How to change the default colour of a Textbox

Didn't find your answer?

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.

Danny Kent
By Viciuno
22nd Apr 2021 12:09

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".

Thanks (0)
Replying to Viciuno:
avatar
By newmoon
22nd Apr 2021 12:33

Viciuno wrote:

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".


Thank you and I think the right click, set as default has worked.
Thanks (0)
All Paul Accountants in Leeds
By paulinleeds
29th Apr 2021 11:25

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

Thanks (0)