Ask a new question

Textbox Bug (All Excel versions). Setting New Default Font doesn't work when pasting txt. Help please

Is this a Bug? 
Scenario: When I create a Text Box on a worksheet and the set the default Font toARIAL 16PT.  I then set this as the Default for all Text boxes (by right clicking on the Border of the box).  All is well and any typing in the text box will beArial 16. Great.  

Problem: If I cut/paste any text within the Textbox it defaults back to Excels built in default  Calibra (body 11).

In short, regardless of setting the default to a new font/size, anything copied from within the Box and then pasted back in, will default back toCalibra.  
If however I copied something from eg an email or even a Cell in excel, into the text box, then everyting is fine and will paste in asArial 16.   Why can't I copy and paste data already held in the text box and for it to hold the Arial 16?   Hope that makes sense

Any suggestings would be appreciated as I use text boxes for descriptions in my Invoices and I often copy/paste around the box? 

No it's by design rather than a bug.   Unfortunately when you copy and paste within a text box, Excel by default formats the pasted text using 'body font' from the Fonts Theme set for the workbook, and the standard font size that is set in Excel options, rather than keeping the format of the source, which is annoying.  Calibri is body font in the default built-in Fonts theme called 'Office'. 

The easist way to change this behaviour, assuming you only want all text boxes to use Arial, is to create a special theme with the font you want.  Do this from the Page Layout ribbon, select Fonts under Themes, and 'Create New Theme Fonts'.  Edit the Body font, then name and save the Theme.

Now select any of text box and apply the customised Font theme. The font in all text boxes should adjust to the theme font.  Copying and pasting within the text boxes will also use this font. 

In regard to the font size, this is based on the default font size set in Excel Options.

If you want to use this customised theme for all new workbooks, then you can create a customised template with the your customised theme pre-selected:

Open a blank workbook, apply your custom Fonts theme and then save is as a template called Book.xltx, in your XLStart folder:

Save As, Select Save As Type - Excel Template (*.xltx) type, change the name to Book,  and locate it in the XLStart folder.  In my PC (Vista) this is:C:\Users\UserName\AppData\Roaming\Microsoft\Excel\XLSTART\

All new workbooks created will then be based on this template.

3 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Mmmm.........seems silly as Word doesn't have this issue only Excel so will still assume it is a bug.
Thanks for the response and work around though.  Wonder if there is a easier way just like it "works properly in word"  Can MS supply a fix?

Addition: I have since found when pasting into the text box there are 3 options (when right clicking):

  1. Use destination Theme (which would be the sheets default Calibra (body 11)
  2. Keep source formatting (which I believe picks my required Arial 16pt as source was is the text box itself)
  3. Keep text only (which I assume pastes in using current settings) Arial 16pt

It seems strange that the default is No 1. 

You suggested that  "Excel by default formats the pasted text using 'body font' from the Fonts Theme set for the workbook". I don't believe this is the case. Reason: if I copy the content from a Cell or even another document/email etc and paste it into the text box then No 3 seems to kicks in".The problem only occures when copying text within the Text box and pasting it back!

My question now is, how do I set the default to No 3 ?  I certainly don't want a standard CTRL-V (Paste) to use destination (Worksheet) Theme.  Obviously I would want it to beNo2 as that is the format I set the box to be!

Anybody any idea how to stop the text box from using No1 as the default setting?

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

I'm having this issue as well and is bugging the **** out of me that I can't find a solution. I have a couple of text boxes I use for text I have to edit a lot. I keep forgetting to right click and paste with source formatting, which seems so stupid.

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info

Last updated March 12, 2024 Views 8,435 Applies to: