Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Selected cells references
Hi,
I have a large spreadsheet that I need to change a large amount of data from a relative cell reference to an absolute cell reference. Is there a way for me to select the cells at one time and change the reference? Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change relative to absolute references in a block of cells | Excel Discussion (Misc queries) | |||
How do i change the color of the selected cells? | Excel Discussion (Misc queries) | |||
Can a workbook be locked against change to cells containing references to other files? | Excel Worksheet Functions | |||
How do I lock selected cells, so only I can change them? | Excel Worksheet Functions | |||
covert only cell references in selected cells into value leaving the existingcell formula | Excel Programming |