Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying formulas to other cells. Keeping references w/o $ sign.
How do I copy formulas from a large group of cells to another group of cells and have them all keep the references to the same cells? (It normally changes the referneces to a cell that has the same position in relation to the former cell) I don't want to go in and change all of the references, adding the $ sign. -- GregP1962 ------------------------------------------------------------------------ GregP1962's Profile: http://www.excelforum.com/member.php...o&userid=33063 View this thread: http://www.excelforum.com/showthread...hreadid=528771 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying formulas to other cells. Keeping references w/o $ sign.
Let's say you have formula in cells A1 thru A100 that you want to copy
elsewhere. First select the cells Then use find/replace to change all = into x= This will change all the formulae into text strings. Copy and paste them elsewhere. Then un-do the process change all x= into = to go back to formulae -- Gary's Student "GregP1962" wrote: How do I copy formulas from a large group of cells to another group of cells and have them all keep the references to the same cells? (It normally changes the referneces to a cell that has the same position in relation to the former cell) I don't want to go in and change all of the references, adding the $ sign. -- GregP1962 ------------------------------------------------------------------------ GregP1962's Profile: http://www.excelforum.com/member.php...o&userid=33063 View this thread: http://www.excelforum.com/showthread...hreadid=528771 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying formulas to other cells. Keeping references w/o $ sign.
You could name your references, which will automatically make the reference
absolute. If you name the cells in an existing spreadsheet the formulas that contain references to those cells will automatically reference the named range instead. When you copy the formulas they always refer back to the original cells. -- Kevin Backmann "GregP1962" wrote: How do I copy formulas from a large group of cells to another group of cells and have them all keep the references to the same cells? (It normally changes the referneces to a cell that has the same position in relation to the former cell) I don't want to go in and change all of the references, adding the $ sign. -- GregP1962 ------------------------------------------------------------------------ GregP1962's Profile: http://www.excelforum.com/member.php...o&userid=33063 View this thread: http://www.excelforum.com/showthread...hreadid=528771 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying formulas to other cells. Keeping references w/o $ sign.
-Gary's Student says; First select the cells Then use find/replace to change all = into x= This will change all the formulae into text strings.- Um, after selecting the cells, there is no clear way in find/replace to change all = into x=. What am I finding? The dialog box after edit/find is confusing. -- GregP1962 ------------------------------------------------------------------------ GregP1962's Profile: http://www.excelforum.com/member.php...o&userid=33063 View this thread: http://www.excelforum.com/showthread...hreadid=528771 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
copying formulas in vba | Excel Discussion (Misc queries) | |||
How do I copy only cells with formulas in another row? | Excel Worksheet Functions | |||
Stoping users pasting formulas into cells | Excel Worksheet Functions | |||
In Exel 2000, stop the blank cells (with formulas) from printing. | Excel Discussion (Misc queries) |