Home

Excel for Mac 2011 copy, paste

%3CLINGO-SUB%20id%3D%22lingo-sub-365110%22%20slang%3D%22en-US%22%3EExcel%20for%20Mac%202011%20copy%2C%20paste%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-365110%22%20slang%3D%22en-US%22%3E%3CP%3EE.g.%20Cell%20A3%20formula%20(%3DA1%2BA2).%20If%20I%20select%20cell%20A3%2C%20copy%20it%20and%20paste%20it%20into%20another%20cell%20the%20data%20in%20the%20destination%20cell%20is%200.%20I%20would%20like%20to%20be%20able%20to%20select%20cell%20A3%2C%20copy%20it%2C%20paste%20it%20into%20another%20cell%20and%20have%20the%20data%20in%20the%20destination%20cell%20show%20the%20data%20in%20A3.%20I.e%2C%20I%20would%20like%20the%20formula%20in%20the%20destination%20cell%20to%20stay%20(%3DA1%2BA2).%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-365110%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-366555%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20for%20Mac%202011%20copy%2C%20paste%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-366555%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20for%20the%20article.%20I%20read%20it.%20It%20explains%20how%20to%20copy%20one%20cell%20with%20relative%2C%20absolute%20and%20mixed%20references.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20made%20an%20error%20in%20my%20explanation%20of%20my%20problem.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20goal%20is%20to%20copy%20all%20the%20formulas%20in%20the%20copied%20range%20of%20cells%20and%20paste%20them%20into%20a%20new%20location.%20I.e%2C%20I%20will%20have%20two%20identical%20data%20in%20two%20sets%20of%20cells%20on%20sheet%201%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20error%20was%20failing%20to%20explain%20that%20one%20or%20more%20of%20the%20cells%20in%20the%20copied%20range%20on%20sheet%201%20will%20have%20its%20data%20taken%20from%20sheet%202%2C%20with%20a%20formula%20similar%20to%2C%20%22%3D'sheet%202'!K75%22.%20I%20wish%20for%20that%20formula%20to%20be%20pasted%20into%20the%20destination%20cells.%20of%20sheet%202%20with%20the%20other%20formulas%20from%20sheet%201.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-365167%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20for%20Mac%202011%20copy%2C%20paste%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-365167%22%20slang%3D%22en-US%22%3E%3CP%3EIt%20depends%20on%20what%20you'd%20like%20to%20calculate%20on%20that%20range%20and%20what%20do%20you%20expect%20from%20copy%2Fpaste%20of%20the%20result.%20In%20general%20%24%20sign%20%22fix%22%20the%20reference%2C%20you%20may%20check%20here%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fswitch-between-relative-absolute-and-mixed-references-dfec08cd-ae65-4f56-839e-5f0d8d0baca9%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fswitch-between-relative-absolute-and-mixed-references-dfec08cd-ae65-4f56-839e-5f0d8d0baca9%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-365138%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20for%20Mac%202011%20copy%2C%20paste%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-365138%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20made%20my%20example%20as%20simple%20as%20possible%20to%20avoid%20confusion.%20Can%20you%20give%20me%20an%20example%20of%20what%20formula%20or%20sequence%20to%20use%20for%20a%20range%20of%20cells%2C%20e.g.%20A1%20through%20B6%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-365124%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20for%20Mac%202011%20copy%2C%20paste%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-365124%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%3C%2FP%3E%0A%3CPRE%3E%3D%24A%241%2B%24A%242%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
Tim_Parisi
Occasional Contributor

E.g. Cell A3 formula (=A1+A2). If I select cell A3, copy it and paste it into another cell the data in the destination cell is 0. I would like to be able to select cell A3, copy it, paste it into another cell and have the data in the destination cell show the data in A3. I.e, I would like the formula in the destination cell to stay (=A1+A2).

4 Replies
Highlighted

When

=$A$1+$A$2

Thank you.

 

I made my example as simple as possible to avoid confusion. Can you give me an example of what formula or sequence to use for a range of cells, e.g. A1 through B6?

It depends on what you'd like to calculate on that range and what do you expect from copy/paste of the result. In general $ sign "fix" the reference, you may check here https://support.office.com/en-us/article/switch-between-relative-absolute-and-mixed-references-dfec0...

Thank you for the article. I read it. It explains how to copy one cell with relative, absolute and mixed references.

 

I made an error in my explanation of my problem.

 

My goal is to copy all the formulas in the copied range of cells and paste them into a new location. I.e, I will have two identical data in two sets of cells on sheet 1

 

My error was failing to explain that one or more of the cells in the copied range on sheet 1 will have its data taken from sheet 2, with a formula similar to, "='sheet 2'!K75". I wish for that formula to be pasted into the destination cells. of sheet 2 with the other formulas from sheet 1.

Related Conversations