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
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies