View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Jaleel Jaleel is offline
external usenet poster
 
Posts: 187
Default 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.