Home |
Search |
Today's Posts |
#1
|
|||
|
|||
I would like to apply the same calculation to an entire row
I have a row and to the first cell I apply the formula "=#/1000". Now i want
to apply this same calculation to all the other cells in the row withoud entering it manually. Copying across does not work as it only takes the value of the first cell and I do not want to copy into an additional row. I simply want to calculate the values in the existing cells quickly. Any suggestions? |
#2
|
|||
|
|||
Enter 1000 in an unused cell.
Copy that cell then select the row to change and Paste Special(in place)DivideOKEsc. Clear out the 1000 cell when happy. Gord Dibben Excel MVP On Fri, 22 Apr 2005 14:01:02 -0700, "mnirula" wrote: I have a row and to the first cell I apply the formula "=#/1000". Now i want to apply this same calculation to all the other cells in the row withoud entering it manually. Copying across does not work as it only takes the value of the first cell and I do not want to copy into an additional row. I simply want to calculate the values in the existing cells quickly. Any suggestions? |
#3
|
|||
|
|||
That is very helpful and it works perfectly but is there perhaps a way to
show that I applied this calculation to each cell, for example the formula cell would read =####/1000. "Gord Dibben" wrote: Enter 1000 in an unused cell. Copy that cell then select the row to change and Paste Special(in place)DivideOKEsc. Clear out the 1000 cell when happy. Gord Dibben Excel MVP On Fri, 22 Apr 2005 14:01:02 -0700, "mnirula" wrote: I have a row and to the first cell I apply the formula "=#/1000". Now i want to apply this same calculation to all the other cells in the row withoud entering it manually. Copying across does not work as it only takes the value of the first cell and I do not want to copy into an additional row. I simply want to calculate the values in the existing cells quickly. Any suggestions? |
#4
|
|||
|
|||
What does your original data look like?
You state you apply a formula to first cell in the row =#/1000 What does # indicate? Where does it come from? Sounds like you should have your #'s in cells in a row(say row 1) then in an adjacent helper row enter =A1/1000 and drag/copy across. Gord Dibben Excel MVP On Mon, 25 Apr 2005 10:49:06 -0700, "mnirula" wrote: That is very helpful and it works perfectly but is there perhaps a way to show that I applied this calculation to each cell, for example the formula cell would read =####/1000. "Gord Dibben" wrote: Enter 1000 in an unused cell. Copy that cell then select the row to change and Paste Special(in place)DivideOKEsc. Clear out the 1000 cell when happy. Gord Dibben Excel MVP On Fri, 22 Apr 2005 14:01:02 -0700, "mnirula" wrote: I have a row and to the first cell I apply the formula "=#/1000". Now i want to apply this same calculation to all the other cells in the row withoud entering it manually. Copying across does not work as it only takes the value of the first cell and I do not want to copy into an additional row. I simply want to calculate the values in the existing cells quickly. Any suggestions? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I use a check box to accept a calculation | Excel Discussion (Misc queries) | |||
calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
time-clock calculation | Excel Worksheet Functions |