General discussion

  • Creator
    Topic
  • #2297757

    Pasting into Excel

    Locked

    by bcasselman ·

    In my job, I research the web and “copy” values (numbers) from lists which I paste into an Excel spreadsheet.
    I have formulas in the sheet, ie; =A1+B1 (in C1).If I direct enter (keyboard) the values I find into the cells A1 and B1 then they calculate into C1 properly but if I “copy and paste” from the web page into the cells, C1 will not automaticly fill in. I can manually ‘Ctrl+D’ and it will fill in. As I paste into A1, that value shows up in C1 but when I paste into B1 then C1 goes blank. A small problem as one extra key stroke will cause it to fill in but as I do this all day long it would be nice if I can find the cure. Any thoughts

All Comments

  • Author
    Replies
    • #2670628

      Reply To: Pasting into Excel

      by dklippert ·

      In reply to Pasting into Excel

      Have you tried Edit Paste Special?
      You might have noticed that Ctrl+D only copies down the entry above the Active cell.

      • #2670554

        Reply To: Pasting into Excel

        by dklippert ·

        In reply to Reply To: Pasting into Excel

        The problem is the formula in C1 is not extended to the next rows.
        Go to Tools>Options Edit and make sure that there is a check in “Extend list formats and formulas”
        The trouble with this function is that the formats/formulas must exist in “at least 3 of the five last rows preceding the new row”. In other words, at about row 5 or 6 it will cut in.
        The other way would be to prefill with a formula such as:
        =IF(OR(A1=””,B1=””),””,A1+B1)
        And copy it down the column at least 5 rows.

Viewing 0 reply threads