microsoft office - How can I copy and paste formatted text in Excel?

23
2013-11
  • Landy

    Before I ask question, I've searched but only found ways of copy and paste "formatted cell". That's not what I need.

    I want to use an example to explain my requirement:

    1. There are 2 cells in a sheet.
    2. Cell_A's text is "aaaaabbbbb", and "aaaaa" is green, and "bbbbb" is red.
    3. Cell_B's text is "ccccc" and "ccccc" is black.
    4. I want to copy and paste "bbbbb" from Cell_A to Cell_B and keep "bbbbb" in red. But in my environment(Office 2007), "bbbbb" is changed to black as "ccccc", the default format of Cell_B.

    Is there an easy way to implement my requirement?

    • Answers
  • Sathya

    Normal way to copy formatted text in Microsoft Office Applications:

    • Select the example text/cell with the wanted format.
    • Click on the Format Painter.
    • Finally select the text/cell which you want to paste format.

    Confirmed Here: More information about this topic provide by Microsoft Office Support.

    Closest to what you asked:

    • Select the source the cell (not the text)
    • Copy it
    • Select the destination the cell
    • Click the down arrow under Paste from the Home tab of the ribbon bar
    • Select Keep Source Formatting right under the Paste heading

    What you are trying to do may not be completely possible. That is probably the closest you will get to what you are asking.


    • Related Question

    microsoft office - Open blank Excel spreadsheet with all cells in text format by default
  • Eugene

    When I paste data with leading zeroes to a newly-opened blank Excel document, it strips out all leading zeroes.

    Is there a way for me to open up a new instance of Excel (not from a template, I usually open up Excel by pressing Win+R keys and then typing Excel) with all cells formatted as text rather than general?

    I tried having a template, but it's way too many mouse clicks.

    Using Office 2007.


    • Related Answers
  • Kije

    Presumably you want to do this some of the time and not all of the time.

    If that is so,

    • create a new spreadsheet
    • format all its cells to text
    • save it (as read only) with a name such as "Excel-Text"
    • Put it, or a shortcut to it, to wherever you like to launch things from

    and just launch it when you need it

  • Christopher Karel

    To build on what Kije suggested, save your template file as "book.xlt". This is the default template for new Excel files. (Like Word's normal.dot file) Book.xlt needs to go in the XLSTART directory of either your user profile, or of the excel install itself. Exact locations vary based on OS and Office version. I have one in C:\users\MyName\AppData\Roaming\Microsoft\Excel and C:\Program Files\Microsoft Office\Office12\ for Windows7 and Office2007.