How can I change the formula for multiple cells at once?
 

I am copying a sheet from one workbook to another
This sheet is filled with formulas
When i place it in the new location, the formulas are all in place, but they
make calculations based on the workbook they came from rather than the new one
I can make the needed adjustments and get the correct calculations in the
formulas, but i have to do this for each cell
There are 5040 cells
Is there a way to do multiple cells at one time?

Answer: How can I change the formula for multiple cells at once?
 

1. Select all the cells that contain the formulas you want to change.
2. Go to the formula bar and edit the formula to reflect the correct calculations based on the new workbook. For example, if the original formula was
   Formula:

   ---

   =SUM([Workbook1]Sheet1!A1:A10) 


   ---

   , and you want to change it to
   Formula:

   ---

   =SUM([Workbook2]Sheet1!A1:A10) 


   ---

   , you would simply replace "Workbook1" with "Workbook2".
3. Press the Ctrl + Enter keys on your keyboard.
4. Check that the new formula has been applied correctly to all the cells.

By following these steps, you can change the formula for multiple cells at once, saving you a lot of time and effort.

How can I change the formula for multiple cells at once?
 

editlinkschange source

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"marquisv2001" wrote in message
...
I am copying a sheet from one workbook to another
This sheet is filled with formulas
When i place it in the new location, the formulas are all in place, but
they
make calculations based on the workbook they came from rather than the new
one
I can make the needed adjustments and get the correct calculations in the
formulas, but i have to do this for each cell
There are 5040 cells
Is there a way to do multiple cells at one time?

How can I change the formula for multiple cells at once?
 

Another way is to go to HomeFind and SelectReplace...

Where you find the reference to the old spreadsheet between the [] brackets,
place all of that (including the [] brackets) into the FIND WHAT box, in the
REPLACE WITH box, place the new target. Select Replace All.

Squeaky

"marquisv2001" wrote:

I am copying a sheet from one workbook to another
This sheet is filled with formulas
When i place it in the new location, the formulas are all in place, but they
make calculations based on the workbook they came from rather than the new one
I can make the needed adjustments and get the correct calculations in the
formulas, but i have to do this for each cell
There are 5040 cells
Is there a way to do multiple cells at one time?

How can I change the formula for multiple cells at once?
 

There is no 'links' under edit

On Friday, August 21, 2009 at 8:37:30 PM UTC-3, Don Guillett wrote:
editlinkschange source

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"marquisv2001" wrote in message
...
I am copying a sheet from one workbook to another
This sheet is filled with formulas
When i place it in the new location, the formulas are all in place, but
they
make calculations based on the workbook they came from rather than the new
one
I can make the needed adjustments and get the correct calculations in the
formulas, but i have to do this for each cell
There are 5040 cells
Is there a way to do multiple cells at one time?

how can i change the formula for multiple cells at once in excel
 

Follow these steps below to change formula for multiple cells

Click the cell with the formula to select it.
Press Ctrl + C to copy the formula.
Select a cell or a range of cells where you want to paste the formula (to select non-adjacent ranges, press and hold the Ctrl key).
Press Ctrl + V to paste the formula.
Press Enter to complete the pasted formulas.

I hope this is helpful!
Admin
Apps4Rent