Prev: Excel VBA 'Help'
Next: line break does not appear in CSV
From: ozgrid.com on 29 Apr 2010 20:50
Select range to copy and then Edit>Replace = with ^^ cut/copy you range and
reverse the Edit Replace after pasting.



--
Regards
Dave Hawley
www.ozgrid.com
"Kyle P." <KyleP(a)discussions.microsoft.com> wrote in message
news:D33D5563-6CEB-48CA-9873-B7F3FB120A72(a)microsoft.com...
> Hey,
> When I have a group of cells, all with formulas that inter-relate to
> other cells, and I try to copy them to another section of a spreadsheet,
> the
> formulas all reset themselves to new cells, relative to their new
> location.
>
> How do I move cells and keep their formulas relating to the cells they
> were
> related to before the move?
>
> Thanks as always everyone,
>
> Kyle P.

First  |  Prev  | 
Pages: 1 2
Prev: Excel VBA 'Help'
Next: line break does not appear in CSV