Lost functionality to copy a formula across rows

Discussion in 'Microsoft Excel Misc' started by SandieB, Mar 21, 2010.

  1. SandieB

    SandieB Guest

    Recently I lot the functionality to copy a formula across a group of cells.
    Normally clicking on the cell will give you a "handle" to allow you to drag
    across a range of cells. At work we are currently using the 2002 Excel and I
    had this functionality until just recently. I have been getting several
    worksheets from other sources--could there be a problem with compatibility?
    I note that even my older spreadsheets lost this functionality.

    Help!
     
    SandieB, Mar 21, 2010
    #1
    1. Advertisements

  2. Maybe:
    Tools > Options > Edit > allow cell drag and drop > OK
    Micky


    "SandieB" wrote:

    > Recently I lot the functionality to copy a formula across a group of cells.
    > Normally clicking on the cell will give you a "handle" to allow you to drag
    > across a range of cells. At work we are currently using the 2002 Excel and I
    > had this functionality until just recently. I have been getting several
    > worksheets from other sources--could there be a problem with compatibility?
    > I note that even my older spreadsheets lost this functionality.
    >
    > Help!
    >
     
    מיכ×ל (מיקי) ×בידן, Mar 21, 2010
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. mmwilcox

    Copy relative formula across sheets

    mmwilcox, May 6, 2004, in forum: Microsoft Excel Misc
    Replies:
    5
    Views:
    2,462
  2. JeffJ

    Adding on to a formula across rows and columns

    JeffJ, May 12, 2004, in forum: Microsoft Excel Misc
    Replies:
    14
    Views:
    281
    JeffJ
    May 13, 2004
  3. Guest

    Copy conditional formatting across multiple rows?

    Guest, Jan 11, 2005, in forum: Microsoft Excel Misc
    Replies:
    1
    Views:
    818
    Bob Phillips
    Jan 11, 2005
  4. Guest

    Copy a formula across for row references

    Guest, Sep 21, 2005, in forum: Microsoft Excel Misc
    Replies:
    2
    Views:
    208
    Guest
    Sep 21, 2005
  5. Guest
    Replies:
    1
    Views:
    312
    Dave Peterson
    Aug 14, 2006
Loading...

Share This Page