- **Excel Worksheet Functions**
(*https://www.excelbanter.com/excel-worksheet-functions/*)

- - **How can I change the formula for multiple cells at once?**
(*https://www.excelbanter.com/excel-worksheet-functions/240421-how-can-i-change-formula-multiple-cells-once.html*)

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? |

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 excelFollow 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 |

All times are GMT +1. The time now is 02:38 AM. |

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.

ExcelBanter.com