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
news:e1hhg11j8pk2jifkv17397sfepvhrm69jc@4ax.com...
> 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"
> <Helen@discussions.microsoft.com>
> 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?
>