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? |
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? |
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? |
All times are GMT +1. The time now is 03:57 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com