6467100000
Board Regular
- Joined
- Oct 7, 2005
- Messages
- 154
Hi,
I have a quick question.
How do you copy Columns and Rows that contain formulas so that some of the formula is not transposed e.g.:
Copy Column:
=C34*5 does not become =D34*5 but remains as =C34*5
Copying Rows
=(A1*5)*B1 does not become =(A2*5)*B2 but is partially transposted to =(A2*5)*B1
Hope this makes sense,
Thanks
I have a quick question.
How do you copy Columns and Rows that contain formulas so that some of the formula is not transposed e.g.:
Copy Column:
=C34*5 does not become =D34*5 but remains as =C34*5
Copying Rows
=(A1*5)*B1 does not become =(A2*5)*B2 but is partially transposted to =(A2*5)*B1
Hope this makes sense,
Thanks