P
Peter
Dear all,
A second question I had was about cell reference. I know
that you can fix this by using the dollar sign. But let's
say in cell A1 I type 'Name' and in cell B1 I
use '=$A$1'. Now if I cut and paste A1 to let's say C3
the formula in cell B1 will change to '=$C$3'. Moving it
by using the mouse will also result in the same.
Only copy paste A1 to C3 and then deleting A1 will not
effect B1. Is there another way to this?
Kind regards,
Peter
A second question I had was about cell reference. I know
that you can fix this by using the dollar sign. But let's
say in cell A1 I type 'Name' and in cell B1 I
use '=$A$1'. Now if I cut and paste A1 to let's say C3
the formula in cell B1 will change to '=$C$3'. Moving it
by using the mouse will also result in the same.
Only copy paste A1 to C3 and then deleting A1 will not
effect B1. Is there another way to this?
Kind regards,
Peter