Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy/Paste formulas in merged cells
I have a spreadsheet that has merged cells in the following cells: A1&B1,
C1&D1, E1&F1,G1&H1,I1&J1 AND K1&L1. A1&B1 and C1&D1 have values, E1&F1 formula is =A1, G1&H1 formula is =C1. When I copy cells E1&F1 and G1&H1 into cells to the right I1&J1 and K1&L1 the forumla stays the same such as it treats it as an absolute but there are no $ in the formula. The formula should change to I1&J1 =E1 and K1&L1 = G1. When I copy this into another sheet within the workbook it works and when I copy it into another workbook it works but within the existing sheet it does not. Sorry if this is confusing - any suggestions? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy/Paste formulas in merged cells
Tools/ Options/ Calculation
Set to Automatic, not Manual. -- David Biddulph "Excel User 123456" wrote in message ... I have a spreadsheet that has merged cells in the following cells: A1&B1, C1&D1, E1&F1,G1&H1,I1&J1 AND K1&L1. A1&B1 and C1&D1 have values, E1&F1 formula is =A1, G1&H1 formula is =C1. When I copy cells E1&F1 and G1&H1 into cells to the right I1&J1 and K1&L1 the forumla stays the same such as it treats it as an absolute but there are no $ in the formula. The formula should change to I1&J1 =E1 and K1&L1 = G1. When I copy this into another sheet within the workbook it works and when I copy it into another workbook it works but within the existing sheet it does not. Sorry if this is confusing - any suggestions? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy/Paste formulas in merged cells
I forgot to mention that this workbook was originally created in an older
version of excel and this is happening in 2007 version. "Excel User 123456" wrote: I have a spreadsheet that has merged cells in the following cells: A1&B1, C1&D1, E1&F1,G1&H1,I1&J1 AND K1&L1. A1&B1 and C1&D1 have values, E1&F1 formula is =A1, G1&H1 formula is =C1. When I copy cells E1&F1 and G1&H1 into cells to the right I1&J1 and K1&L1 the forumla stays the same such as it treats it as an absolute but there are no $ in the formula. The formula should change to I1&J1 =E1 and K1&L1 = G1. When I copy this into another sheet within the workbook it works and when I copy it into another workbook it works but within the existing sheet it does not. Sorry if this is confusing - any suggestions? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't copy & paste - "merged cells must be identically sized" | Excel Discussion (Misc queries) | |||
copy & paste formulas while referring to same cells | Excel Discussion (Misc queries) | |||
Copy/Cut/Paste of Merged Cells in Shared Protected Workbooks | Excel Discussion (Misc queries) | |||
Copy & Paste Visible Cells with Formulas | Excel Worksheet Functions | |||
paste info into merged cells | Setting up and Configuration of Excel |