+ Reply to Thread
Results 1 to 4 of 4

Pasting numbers and formulas without pasting format.

  1. #1
    Dan
    Guest

    Pasting numbers and formulas without pasting format.

    I'm having an issue with copying and pasting as well as draggin a formula
    down a column. I have the rows set up to alternate colors for visual effect.
    The issue I have is when copying and pasting it will undo a cells format
    (changing to whatever color [and border etc] was in the copied cell.) I know
    you can fix this by clicking the automatically inserted drop down box and
    selecting "match destination formatting." The ammount of copying/pasting I
    do with this spreadsheet would make that option take forever.

    Is there a way to make the "match destination formatting" default?

  2. #2
    Mark
    Guest

    re: Pasting numbers and formulas without pasting format.

    Hi,

    I am not sure you can do it manually. You may need a macro
    to do the job. If you do not get a reasonable response
    from this forum, you can send your worksheet to me and
    maybe I can write a macro to dothe task.

    See some of my excel stuff at:
    http://www.geocities.com/excelmarksway


    regards
    mark

    >-----Original Message-----
    >I'm having an issue with copying and pasting as well as

    draggin a formula
    >down a column. I have the rows set up to alternate

    colors for visual effect.
    > The issue I have is when copying and pasting it will

    undo a cells format
    >(changing to whatever color [and border etc] was in the

    copied cell.) I know
    >you can fix this by clicking the automatically inserted

    drop down box and
    >selecting "match destination formatting." The ammount of

    copying/pasting I
    >do with this spreadsheet would make that option take

    forever.
    >
    >Is there a way to make the "match destination formatting"

    default?
    >.
    >


  3. #3
    Debra Dalgleish
    Guest

    Re: Pasting numbers and formulas without pasting format.

    When filling a formula down a column, in Excel 2002 or later versions,
    point to the Fill Handle at the bottom right of the cell.

    Hold the Right mouse button, and drag down
    Release the mouse button, and choose Fill Without Formatting

    If you're copying and pasting values, you could add the Paste Values
    button to your toolbar:

    Choose Tools>Customize
    Click on the Commands tab
    Select the Edit category
    Scroll down the list of commands to find Paste Values
    Drag the Paste Values command to an existing toolbar
    Click Close


    Dan wrote:
    > I'm having an issue with copying and pasting as well as draggin a formula
    > down a column. I have the rows set up to alternate colors for visual effect.
    > The issue I have is when copying and pasting it will undo a cells format
    > (changing to whatever color [and border etc] was in the copied cell.) I know
    > you can fix this by clicking the automatically inserted drop down box and
    > selecting "match destination formatting." The ammount of copying/pasting I
    > do with this spreadsheet would make that option take forever.
    >
    > Is there a way to make the "match destination formatting" default?



    --
    Debra Dalgleish
    Excel FAQ, Tips & Book List
    http://www.contextures.com/tiptech.html


  4. #4
    Dan
    Guest

    RE: Pasting numbers and formulas without pasting format.

    Very good!! Thank you both

    "Dan" wrote:

    > I'm having an issue with copying and pasting as well as draggin a formula
    > down a column. I have the rows set up to alternate colors for visual effect.
    > The issue I have is when copying and pasting it will undo a cells format
    > (changing to whatever color [and border etc] was in the copied cell.) I know
    > you can fix this by clicking the automatically inserted drop down box and
    > selecting "match destination formatting." The ammount of copying/pasting I
    > do with this spreadsheet would make that option take forever.
    >
    > Is there a way to make the "match destination formatting" default?


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1