Results 1 to 8 of 8

Thread: Copying Tips

  1. #1
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Northern, California, USA
    Posts
    1,886
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Copying Tips

    Hey!

    I have a series of cells which contain array formulas. What do I need to do to copy the VALUES and not the formulas when I depress CTRL + C?

    Thanks !

    Drk.
    <IMG SRC=http://www.wopr.com/w3tuserpics/Kel_sig.gif>
    Moderator:<font color=448800> Pix Place, Internet Explorer</font color=448800>
    <small>www.kvisions.com

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Copying Tips

    When the range is copied goto Edit, Paste Special and select Values

    That should get tghe desired effect

    Andrew

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Adelaide, South Australia, Australia
    Posts
    387
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Copying Tips

    There is a Paste Special/Values button via the Tools Menu, Customise/Commands/Edit, worth dragging onto a toolbar if you do a lot of pasting Values Only.

  4. #4
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Northern, California, USA
    Posts
    1,886
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Copying Tips

    Leave it to Microsoft.. [img]/w3timages/icons/beep.gif[/img]

    Thanks Gentlemen!

    Drk.
    <IMG SRC=http://www.wopr.com/w3tuserpics/Kel_sig.gif>
    Moderator:<font color=448800> Pix Place, Internet Explorer</font color=448800>
    <small>www.kvisions.com

  5. #5
    2 Star Lounger
    Join Date
    Feb 2001
    Posts
    163
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: Copying Tips

    Can you suggest a way to just copy just links?

    I've created a customer spreadsheet that I've used to link to a recap spreadsheet. There are numerous links on a few dozen worksheets. The recap spreadsheet will be to compare each of 4 different customers. Once I have the links done, I want to copy them over to the next 3 columns then use find and replace to change the name of the customer spreadsheet. However when I copy it copies the formatting to. I have conditional formatting on most of the cells that read something like this Cell value is greater than or equalt to =+$K$11+$L$13 and cell value is less than or equal to =+$K$11-$L$13. It took me a long time going back and forth making the reference cells absolute or relative depending on whether I was copying the formatting down rows or across columns. If I copy the links then all my conditional formatting has to be redone as find and replace does not look in conditional formatting. It would make my life much easier if I could just paste the links. Values does not work as I want the link.

  6. #6
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Copying Tips

    If I understand your problem you should Paste Link again, there is no reason why a formula cannot be linked to cell that is already linked to another cell. The formatting should not be carried over.

    Hope I understood the problem

    regards,
    Andrew C

  7. #7
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Copying Tips

    From your description, I am not sure what you are trying to do. If you are trying to paste the formula in the cell with a link to another sheet without changing the cell's format, then what you want to do is Paste Formulas.
    Legare Coleman

  8. #8
    2 Star Lounger
    Join Date
    Feb 2001
    Posts
    163
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: Copying Tips

    Thanks,

    Don't know why when I tried to copy the formula before it didn't work, but it is now.

Posting Permissions

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