| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can you merge data from one sheet to another sheet which has .
I have a document which has merged cells and I am trying to copy some
information into them but it keeps saying 'Cannot change part of a merged cell' Can anyone help me? If I cant do this then Im going to have to individually enter 2000 data entries....!!! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can you merge data from one sheet to another sheet which has .
Copy collumn by collumn or row by row or create a duplicate copy and unmerge
the merged cells first and then copy all "monkeywakeboarder" wrote: I have a document which has merged cells and I am trying to copy some information into them but it keeps saying 'Cannot change part of a merged cell' Can anyone help me? If I cant do this then Im going to have to individually enter 2000 data entries....!!! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can you merge data from one sheet to another sheet which has .
Welcome to the Wonderful World of Merged Cells which causes so many problems it
should have been removed from Excel with the SR-1 patch after being introduced in XL97 and never added to later versions. Unmerge the cells and do your copying/pasting. Gord Dibben MS Excel MVP On Tue, 6 Nov 2007 00:43:01 -0800, monkeywakeboarder wrote: I have a document which has merged cells and I am trying to copy some information into them but it keeps saying 'Cannot change part of a merged cell' Can anyone help me? If I cant do this then Im going to have to individually enter 2000 data entries....!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I mail merge 2nd sheet of an excel sheet? | Excel Discussion (Misc queries) | |||
| How to merge data in Excel - one sheet to template sheet? | Excel Worksheet Functions | |||
| create a formula in one sheet that would read data from separate sheet automatically | Excel Discussion (Misc queries) | |||
| I have 100 excel sheets how can I merge all data into one sheet | Excel Worksheet Functions | |||
| merge data in different excel sheets of same format in one sheet | Excel Worksheet Functions | |||
Linear Mode
