Can I move colums in a spreadsheet without messing up referenced in a formula ?

I have data I would like to put a new order in the colums.

Probem is I have formulas  =d2 & char(10) zz2 &  .............

TIMFOX123Asked:
Who is Participating?
 
royhsiaoCommented:
Yes, you could use insert, delete and cut the columns.
The insert, delete and cut columns should not messing up reference in a formula.
0
 
jppintoCommented:
If you just drag and drop your data, the formulas won't change.
0
 
TIMFOX123Author Commented:
thx
0
 
jppintoCommented:
Could you please explain me why you only accepted royhsiao answer that was posted secondly and basically says the same as mine?
0
 
jppintoCommented:
"...like to put a new order in the colums..."

With all due respect teylyn, the author said he wants to move data...not insert or delete rows or columns. That's why I said he could drag and drop cells into a new position.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.