MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Copying Cells


Posted by Scott on December 09, 2001 10:09 PM

I'm trying to copy the same formula results from one worksheet to multiple cells on another worksheet without advancing rows.

Example
Sheet1 - The value of A5 which is A1+A2
Sheet 2 - Paste A5 to Cells C3 throught C7 without it changing to A6, A7, etc.

Thanks.


Posted by anno on December 09, 2001 10:28 PM

select C3:C7, then enter =A5 on the formula bar and array enter (ctrl+shift+enter). does that do what you want?

Posted by Scott on December 10, 2001 6:35 AM

That worked. I had to select all of the cells at once, that it was being pasted to.

Thanks