+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 27
Office Software Thread, Excel Formula Copy Problem in Technical; One of the teachers at my school is having a problem with Excel that has flumoxed me and everyone else ...
  1. #1

    Join Date
    Mar 2007
    Location
    Cambridge, UK & Reno, USA
    Posts
    339
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Excel Formula Copy Problem

    One of the teachers at my school is having a problem with Excel that has flumoxed me and everyone else who has attempted to help.

    She has put in a very simple formula (=A1+B1) which calculates fine. However when she then copies the formula down the column, the formula changes with it ok (e.g. =A2+B2, =A3+B3, =A4+B4 etc.) but it merely copies the answer from the first cell instead of running the formula.

    I'm sure this is really easy to solve, which is where you lot come in....!

  2. #2
    limbo's Avatar
    Join Date
    Aug 2005
    Location
    Birmingham
    Posts
    460
    Thank Post
    2
    Thanked 41 Times in 36 Posts
    Rep Power
    25

    Re: Excel Formula Copy Problem

    If she presses f9 does it then display correctly?

    If so then she has switched of automatic calculation - look in tools > options > calculation tab > tick the automatic option

  3. #3

    mac_shinobi's Avatar
    Join Date
    Aug 2005
    Posts
    9,708
    Thank Post
    3,244
    Thanked 1,048 Times in 970 Posts
    Rep Power
    364

    Re: Excel Formula Copy Problem

    At the bottom right of each cell you should be able to click on the tiny black square and drag and hold and drag down wards and that should copy the formula down but it will do it for the cells to the right of it ie when you drag it down the formula, if not then you need to find the fill down option which is underneath one of the menus ( Cant remember )

    what is it that she is trying to make it do exactly ?

  4. #4

    Join Date
    Mar 2007
    Location
    Cambridge, UK & Reno, USA
    Posts
    339
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Re: Excel Formula Copy Problem

    Quote Originally Posted by gecko
    At the bottom right of each cell you should be able to click on the tiny black square and drag and hold and drag down wards and that should copy the formula down but it will do it for the cells to the right of it ie when you drag it down the formula, if not then you need to find the fill down option which is underneath one of the menus ( Cant remember )

    what is it that she is trying to make it do exactly ?
    It's a very basic thing she's trying to do - something I do hundreds of times - just copy a formula down a column in the spreadsheet. However, I've never known Excel refuse to do it properly. And it's just one instance of Excel, it's every copy she's tried around the school.

    I have tried the black square doo-dah (sorry, that's the best word I could think of), and all options that go with it, but it still didn't work.

    I haven't tried the F9 recovery yet, but will report back on Monday...unless she fixes it over the weekend.

  5. #5

    Join Date
    Mar 2007
    Location
    Cambridge, UK & Reno, USA
    Posts
    339
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Re: Excel Formula Copy Problem

    Quote Originally Posted by limbo
    If she presses f9 does it then display correctly?

    If so then she has switched of automatic calculation - look in tools > options > calculation tab > tick the automatic option
    The teacher says she owes you a virtual pint.

  6. #6
    limbo's Avatar
    Join Date
    Aug 2005
    Location
    Birmingham
    Posts
    460
    Thank Post
    2
    Thanked 41 Times in 36 Posts
    Rep Power
    25

    Re: Excel Formula Copy Problem

    Does that mean I can get virtually legless?

  7. #7

    Join Date
    Mar 2007
    Location
    Cambridge, UK & Reno, USA
    Posts
    339
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Re: Excel Formula Copy Problem

    Quote Originally Posted by limbo
    Does that mean I can get virtually legless?
    It depends if you are virtually driving or not. After all, we wouldn't want to promoting virtual irresponsible behaviour would we?!

  8. #8
    bpd
    bpd is offline

    Join Date
    Sep 2010
    Location
    Washington, DC
    Posts
    6
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Copy Formula doesn't work, even though it used to

    I'm using Excel 2000. If I have a cell with contents "=C4+D4" (w/o quotes, of course) the spreadsheet shows a value (say 7). If I select the cell and copy it, I get a cell whose content is "7" (again, no quotes). That is to say, Cntrl-C and Cntrl-V is not copying and pasting the formula, it's copying pasting the value computed by the formula. It wasn't always like this - copying formulas used to work, and I have no idea what's changed. I even tried unintalling and reinstalling Office 2000 but the problem remains.

    Selecting the cell and then dragging the little box in the corner works for contigous blocks (thanks for the tip), but the general problem of copying formulae remains.

    Any thoughts on this?

  9. #9

    SYNACK's Avatar
    Join Date
    Oct 2007
    Posts
    11,060
    Thank Post
    853
    Thanked 2,674 Times in 2,269 Posts
    Blog Entries
    9
    Rep Power
    768
    You could use "paste special" instead, right click on the destination cell and click "paste special" then paste formula and it should work fine. Don't know how the default changed though.

  10. #10
    bpd
    bpd is offline

    Join Date
    Sep 2010
    Location
    Washington, DC
    Posts
    6
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    I tried Paste Special - it doesn't work either. It works the same as Ctrl-C, Cntrl-V; that is, it pastes in the value of the computation of the source cell, not the formula.

  11. #11
    clareq's Avatar
    Join Date
    Dec 2005
    Location
    Doncaster
    Posts
    693
    Thank Post
    52
    Thanked 188 Times in 124 Posts
    Rep Power
    101
    Try making the formula visible, by pressing Ctrl and that button above tab (what is that called, by the way) At least that will help in troubleshooting.

  12. #12

    Join Date
    Oct 2008
    Location
    Lincolnshire
    Posts
    2,160
    Thank Post
    12
    Thanked 224 Times in 214 Posts
    Rep Power
    66
    Copy it in and press ALT & Enter rather than just click into another box that might help, I had a similar problem before.

  13. #13
    bpd
    bpd is offline

    Join Date
    Sep 2010
    Location
    Washington, DC
    Posts
    6
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    I couldn't get that to work. I selected the source cell, hit Cntrl-C move to the target cell and hit ALT-ENTER but all I got was a beep 0 nothing was pasted. Did you mean for me to do something else?

  14. #14

    SYNACK's Avatar
    Join Date
    Oct 2007
    Posts
    11,060
    Thank Post
    853
    Thanked 2,674 Times in 2,269 Posts
    Blog Entries
    9
    Rep Power
    768
    Does it have all the service packs, their up to three now, perhaps it was a bug Download details: Office 2000 Update: Service Pack 3 (SP3)

  15. #15
    bpd
    bpd is offline

    Join Date
    Sep 2010
    Location
    Washington, DC
    Posts
    6
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    It did but after the reinstall I didn't get the latest. Thanks for pointing out that I need to update it again.

SHARE:
+ Post New Thread
Page 1 of 2 12 LastLast

Similar Threads

  1. Strange Excel Problem
    By Jon in forum Windows
    Replies: 14
    Last Post: 14th July 2011, 04:55 PM
  2. Excel sum problem
    By wesleyw in forum How do you do....it?
    Replies: 8
    Last Post: 29th August 2009, 11:23 AM
  3. Excel Formula Help
    By DSapseid in forum Windows
    Replies: 4
    Last Post: 7th November 2007, 04:56 PM
  4. Excel Problem
    By TechSupp in forum General Chat
    Replies: 0
    Last Post: 2nd November 2007, 10:08 PM
  5. Bizzare Excel Problem
    By Norphy in forum Windows
    Replies: 3
    Last Post: 17th January 2006, 10:19 AM

Thread Information

Users Browsing this Thread

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

Posting Permissions

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