U.S. CitiesCity-Data Forum Index
Go Back   City-Data Forum > General Forums > Science and Technology > Computers
 [Register]
Please register to participate in our discussions with 1.5 million other members - it's free and quick! Some forums can only be seen by registered members. After you create your account, you'll be able to customize options and access all our 15,000 new posts/day with fewer ads.
Jump to a detailed profile or search
site with Google Custom Search

Search Forums  (Advanced)
Business Search - 14 Million verified businesses
Search for:  near: 
 
Old 08-24-2008, 04:01 AM
 
Location: THEN: Paso Robles, Ca * NOW: Albuquerque, NM
541 posts, read 1,186,449 times
Reputation: 253
Default Excel 2007 Experts: Can't copy formula down rows

So I'm really just a novice creating a gradebook from scratch. I'm editing my gradebook (create in Excel 03) in my new Excel 07. I used to be able to copy and paste one formula down the rows, and the numbers would adjust, but now I can't. And I know there is a simpler way than changing E21 to E22 to E23, etc. This is my formula:

=$B$51*B78+$C$51*C78+$D$51*D78+$E$51*E78 (it continues on until Q, but you get the idea).

In old Excel I was able to copy the formula straight down the column, and $B$51 would change to $C$52 to $D$51 ... even when I got rid of the $, the formula wouldn't change per row.

I don't even know if I am adequately explaining myself ... I really don't know how to do any of this stuff ..


What am I doing wrong?
Reply With Quote Quick reply to this message

 
Old 08-24-2008, 10:56 AM
 
19,059 posts, read 21,756,773 times
Reputation: 26593
Been a while, but I think that if you highlight it then place the cursor in the lower right corner of the originating cell until it turns into a black plus sign (note the lower right corner has a small black square in it) then drag down the column it will do what you want.

No guarantees, though!

OK, just did it in Excel 2003 and it worked.
Reply With Quote Quick reply to this message
 
Old 08-24-2008, 11:09 AM
Bo Bo won $500 in our forum's Most Engaging Poster Contest - Tenth Edition (Apr-May 2014). 

Over $84,000 in prizes has already been given out to active posters on our forum and additional contests are planned
 
Location: San Antonio
14,479 posts, read 20,806,948 times
Reputation: 9666
The $ signs in the formulas indicate Absolute Reference to specific cells. When you delete the $ and copy the formula, the copied formulas (formulae? ) will point to different cells than the original formula, which may be breaking the formula for you. I suspect that the problem you are having is related to reference. Take a look at the help files for "absolute reference" and adjust your formulas accordingly before copying.
Reply With Quote Quick reply to this message
 
Old 08-24-2008, 12:50 PM
 
Location: THEN: Paso Robles, Ca * NOW: Albuquerque, NM
541 posts, read 1,186,449 times
Reputation: 253
Quote:
Originally Posted by Tek_Freek View Post
Been a while, but I think that if you highlight it then place the cursor in the lower right corner of the originating cell until it turns into a black plus sign (note the lower right corner has a small black square in it) then drag down the column it will do what you want.

No guarantees, though!

OK, just did it in Excel 2003 and it worked.

Thanks! I just did it, and I had to choose "copy cells" and it worked! Thanks very much .. I was getting really stressed and losing sleep because I couldn't figure it out .. and I found nothing on Google.

Thanks again!
Reply With Quote Quick reply to this message
Please register to post and access all features of our very popular forum. It is free and quick. Over $68,000 in prizes has already been given out to active posters on our forum. Additional giveaways are planned.

Detailed information about all U.S. cities, counties, and zip codes on our site: City-data.com.


Reply
Please update this thread with any new information or opinions. This open thread is still read by thousands of people, so we encourage all additional points of view.

Quick Reply
Message:


Over $84,000 in prizes was already given out to active posters on our forum and additional giveaways are planned!

Go Back   City-Data Forum > General Forums > Science and Technology > Computers
Similar Threads

All times are GMT -6.

2005-2014, Advameg, Inc.

City-Data.com - Archive 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25 - Top