The very best advice we could give you is to avoid merged cells like the
plague. Format / Cells / Horizontal / Centre across selection will give you
the same effect without the downsides.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Helen

Are you actually "merging" the cells or are you "linking" the cells from
sheet1 to sheet2 as in =sheet1!A1 written on sheet2?

If the latter, you can change the order on sheet1 only if you first change
the
formulas on sheet2 to values.

Am somewhat confused by your use of "one sheet" and "the other sheet".

Post back with more detail and the names of your sheets.


Gord Dibben Excel MVP

On Sat, 20 Aug 2005 23:33:07 -0700, "Helen"

wrote:

I have a query with merging cells. I know how to merge cells from one
sheet
to another (just learnt that). I have an inventory list and as I purchase
goods I want to put the information on one sheet and have it merge to
another
sheet for other purposes. On the other sheet can I change the order of
the
inventory without affecting the merged information?