moving formula accross cells

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Moving formula accross cells

Moving formula accross cells

resolvedResolved · Urgent Priority · Version 2007

Hosh has attended:
Excel Introduction course
Excel Intermediate course

Moving formula accross cells

im doing a spreadsheet trying to work out price per square foot values against different size appartments in different areas of london to compare and contrast prices.

i set up the formula for one value per square foot, in a cell, and then used this to multiply by various values of different sized appartments.
I am now having difficulty multiplying this accross different columns correctly..

below is the formula i am using which i hope is correct.

=SUM($H$2*$D$4)

i want to then use new values in subsequent columns ie ; j2 but still be able to multiply this back to d4.

and then spread this across the spreadsheet for other values to be multiplied by cells in column d - (4-12 say..)

RE: moving formula accross cells

You are using absolute referencing in both of your cells at the moment. This is the $ signs. They will look the cell columns and rows when using autofill.

If you want the cell reference J2 to move when you autofill to other cells remove the the $ from $J$2. However you will want to leave the $d$4 as this cell you dont want to move.

Feel free to email me the work book if you have any problems.

paul@microsofttrianing.net

Mon 2 Apr 2012: Automatically marked as resolved.


 

Excel tip:

Entering text in Multiple Worksheets

If you have a number of worksheets in a workbook that require the same information (data or tables) on each worksheet, this can be done as follows:

Hold down the Ctrl key and click one or more of the additional worksheet tabs (i.e. Sheet2, Sheet3, etc).

In your mainsheet (Sheet1) enter the required data or design a table.

When done 'Click' on the other sheet tabs and you will see that the information entered in Sheet1 is on all the other selected worksheets.

NB Do not forget to deselect the worksheets - otherwise you may add data to the main worksheet and all the selected worksheets will also have that data!

View all Excel hints and tips


Server loaded in 0.08 secs.