Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
How can I change the formula for multiple cells at once?
4,546 views
Skip to first unread message
marquisv2001
Aug 21, 2009, 7:19:01 PM8/21/09
to
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?
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?
Don Guillett
Aug 21, 2009, 7:37:30 PM8/21/09
to
edit>links>change source>>
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguil...@austin.rr.com
"marquisv2001" <marqui...@discussions.microsoft.com> wrote in message
news:7C2E3B33-6F3A-489E...@microsoft.com...
Squeaky
Aug 24, 2009, 2:30:01 PM8/24/09
to
Another way is to go to Home>Find and Select>Replace...
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
mopesa...@gmail.com
Apr 3, 2019, 2:34:45 PM4/3/19
to
There is no 'links' under edit
0 new messages