Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy/Paste into merged cells
I want to copy/paste from one merged cell to another.
I get an error msg "Data on the clipboard is not the same size and shape as the selected area. Do you want to paste the data anyway?" When I click "OK," I get the next message: "Cannot change part of a merged cell." They should be the same size, because I copied the worksheet from one tab to another in the same workbook. Is there any way to paste into merged cells? Thanks! Nicole |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy/Paste into merged cells
You can use the F(x) box at the top of the worksheet. Select the cell you
want to copy from and then highlight the values in the F(X) box with the mouse and type Cntl-C (or use copy from menu or right click mouse and choose copy). then select the destination cell and paste the data into the F(X) box using Cntl-V for paste. "NicoleS" wrote: I want to copy/paste from one merged cell to another. I get an error msg "Data on the clipboard is not the same size and shape as the selected area. Do you want to paste the data anyway?" When I click "OK," I get the next message: "Cannot change part of a merged cell." They should be the same size, because I copied the worksheet from one tab to another in the same workbook. Is there any way to paste into merged cells? Thanks! Nicole |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy/Paste into merged cells
Thanks! That works perfectly!
"Joel" wrote: You can use the F(x) box at the top of the worksheet. Select the cell you want to copy from and then highlight the values in the F(X) box with the mouse and type Cntl-C (or use copy from menu or right click mouse and choose copy). then select the destination cell and paste the data into the F(X) box using Cntl-V for paste. "NicoleS" wrote: I want to copy/paste from one merged cell to another. I get an error msg "Data on the clipboard is not the same size and shape as the selected area. Do you want to paste the data anyway?" When I click "OK," I get the next message: "Cannot change part of a merged cell." They should be the same size, because I copied the worksheet from one tab to another in the same workbook. Is there any way to paste into merged cells? Thanks! Nicole |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy/Paste formulas in merged cells | Excel Discussion (Misc queries) | |||
Can't copy & paste - "merged cells must be identically sized" | Excel Discussion (Misc queries) | |||
Copy/Cut/Paste of Merged Cells in Shared Protected Workbooks | Excel Discussion (Misc queries) | |||
con't paste merged cells | Excel Worksheet Functions | |||
paste info into merged cells | Setting up and Configuration of Excel |