Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default copying text within a text box and losing formatting

In Excel 2007, I am trying to copy a line of text within a text box and then
paste it to a line lower in the text box. When I do this, it changes the
font to the default font and will not paste it with the same font of the line
of text I just copied. there is not an option for paste special. Does
anyone know how to fix this?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 37
Default copying text within a text box and losing formatting

I recreated the problem and see what you mean. My solution would be to use
the smart tag that shows up after you paste to Keep Source Formatting.

On the Excel options advanced tab, make sure that you have all three options
selected under "Cut, copy, and paste" to make this work.





"hokiefan1us" wrote:

In Excel 2007, I am trying to copy a line of text within a text box and then
paste it to a line lower in the text box. When I do this, it changes the
font to the default font and will not paste it with the same font of the line
of text I just copied. there is not an option for paste special. Does
anyone know how to fix this?

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default copying text within a text box and losing formatting

Thanks!

"Brad Vogt" wrote:

I recreated the problem and see what you mean. My solution would be to use
the smart tag that shows up after you paste to Keep Source Formatting.

On the Excel options advanced tab, make sure that you have all three options
selected under "Cut, copy, and paste" to make this work.





"hokiefan1us" wrote:

In Excel 2007, I am trying to copy a line of text within a text box and then
paste it to a line lower in the text box. When I do this, it changes the
font to the default font and will not paste it with the same font of the line
of text I just copied. there is not an option for paste special. Does
anyone know how to fix this?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I link text without losing (bold or color) formatting? Dusty Excel Discussion (Misc queries) 1 September 7th 07 10:40 PM
losing text from text box when pasting selection to word rallyworker Excel Discussion (Misc queries) 0 April 13th 07 08:44 AM
converting excel to text or prn, losing format Cheryl Excel Discussion (Misc queries) 0 August 25th 06 09:41 PM
Changing column size w/o losing text Carrie New Users to Excel 3 April 13th 05 08:53 PM
Text not copying as text from Word to Excel 2003 Christine Excel Discussion (Misc queries) 4 March 3rd 05 11:33 PM


All times are GMT +1. The time now is 05:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"