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?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. Guest
    Replies:
    3
    Views:
    568
    Debra Dalgleish
    Dec 23, 2003
  2. mmwilcox

    Copy relative formula across sheets

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

    Adding on to a formula across rows and columns

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

    Copy conditional formatting across multiple rows?

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

    Copy a formula across for row references

    Guest, Sep 21, 2005, in forum: Microsoft Excel Misc
    Replies:
    2
    Views:
    276
    Guest
    Sep 21, 2005
  6. chrissywhittle

    formula wont copy across to other cells correctly

    chrissywhittle, Mar 8, 2006, in forum: Microsoft Excel Misc
    Replies:
    10
    Views:
    348
    Doug Kanter
    Mar 9, 2006
  7. Guest
    Replies:
    1
    Views:
    451
    Dave Peterson
    Aug 14, 2006
  8. Guest
    Replies:
    1
    Views:
    204
    Guest
    Jul 31, 2007
Loading...