Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I easily link a block of cells in one spreadsheet to anothe
excel 2003
How do I easily link a block of cells in one spreadsheet to another? I do not want to have to create the link in each individual cell, but woudl prefer to link a block all at once. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I easily link a block of cells in one spreadsheet to anothe
Link the upper left hand most cell in the new sheet by double left clicking
on a cell and then typing = then before hitting enter go to the upper left hand cell of your block and click on it and then hit enter. Once the 1st cell is linked you should be able to copy the new cell to the right and then down for the size of the block of data to link to all cells in the block. "eudorajane" wrote: excel 2003 How do I easily link a block of cells in one spreadsheet to another? I do not want to have to create the link in each individual cell, but woudl prefer to link a block all at once. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I easily link a block of cells in one spreadsheet to anothe
One more method.
Select the block of cells. Switch to new sheet and select a single cell. EditPaste SpecialPaste LinkOKEsc. Gord Dibben MS Excel MVP On Mon, 18 Sep 2006 12:30:02 -0700, tim m wrote: Link the upper left hand most cell in the new sheet by double left clicking on a cell and then typing = then before hitting enter go to the upper left hand cell of your block and click on it and then hit enter. Once the 1st cell is linked you should be able to copy the new cell to the right and then down for the size of the block of data to link to all cells in the block. "eudorajane" wrote: excel 2003 How do I easily link a block of cells in one spreadsheet to another? I do not want to have to create the link in each individual cell, but woudl prefer to link a block all at once. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I easily link a block of cells in one spreadsheet to an
Do you think it will serve the purpose? "tim m" wrote: Link the upper left hand most cell in the new sheet by double left clicking on a cell and then typing = then before hitting enter go to the upper left hand cell of your block and click on it and then hit enter. Once the 1st cell is linked you should be able to copy the new cell to the right and then down for the size of the block of data to link to all cells in the block. "eudorajane" wrote: excel 2003 How do I easily link a block of cells in one spreadsheet to another? I do not want to have to create the link in each individual cell, but woudl prefer to link a block all at once. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I link cells between two different two different workbooks. | Excel Worksheet Functions | |||
How to link cells only if... | Excel Discussion (Misc queries) | |||
Can I sort excel spreadsheet data by fill color of cells? | Excel Discussion (Misc queries) | |||
Scan and copy cells from one spreadsheet to another. | Excel Discussion (Misc queries) | |||
How do I link many cells to one particular cell? | Excel Discussion (Misc queries) |