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