Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,651
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can't copy & paste - "merged cells must be identically sized" Rayo K Excel Discussion (Misc queries) 2 March 14th 06 01:19 AM
copy & paste formulas while referring to same cells Schoolson Excel Discussion (Misc queries) 1 February 22nd 06 04:58 PM
Copy/Cut/Paste of Merged Cells in Shared Protected Workbooks DaveyC4S Excel Discussion (Misc queries) 0 September 20th 05 01:24 PM
Copy & Paste Visible Cells with Formulas Ricky Excel Worksheet Functions 5 January 27th 05 06:37 PM
paste info into merged cells Marc Setting up and Configuration of Excel 0 December 6th 04 10:09 PM


All times are GMT +1. The time now is 08:41 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"