How would I paste a series of cells?
Example: a1:a9
"tjtjjtjt" wrote:
Another way:
Double-Click on the cell and Copy the data from the Formula Bar.
Press Escape.
Double-Click on the destination cell and Paste.
Press Enter.
tj
"Jim" wrote:
HI,
I currently use this formula:
=SUMPRODUCT(--(AM3:AM10000=TIME(0,0,0)),--(AM3:AM10000<=TIME(0,29,59)),--(AO3:AO10000=1))
How do I paste this into another cell without changing the formula? The
paste special function formulas is changing the destination.
|