Welcome to the Treehouse Community
Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.
Looking to learn something new?
Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.
Start your free trial
Thomas Dam
5,237 PointsHow to copy formula across the sheet, like in the video
At 3:10 of this video Michael copies the cells and moves it across so that it follows the last sheet's cell locations. I am trying to do this myself on Excel but it just duplicates the three Location total revenue cells all across the sheet. Any help with this?
1 Answer
Steven Parker
231,271 PointsWhen you say "it just duplicates the three Location total revenue cells", isn't that what happens in the video? Or do you mean when you do it, it duplicates the total revenue for the same month?
If you replicate references by hovering the lower-right corner until you get the "+" icon, and then dragging, the references dropped into each cell should be incremented appropriately. It not, perhaps you originally copied a value into each cell instead of a reference formula.
Does that help any?