Pasting to a merged range on a shared document.

I have created a shared form for my company. On the form are named merged ranges for data entry. There are times when the information would be the same on some of the entries. When I copy and paste data from a named merged range to another named merged range the cell formatting changes from merged to unmerged thus changing the way the data is displayed. How could I avoid this?

Hi and welcome to the board
Are you using merged cells? If so throw them away and replace with Format - Center across selection

That should work just fine..