0
votes
2answers
657 views

In Excel, how do I copy a formula down or over, skipping cells?

Ex: =A1+A2 next cell down A3+A4 next cell down A5+A6, not A1+A2, A2+A3, A3+A4. I am trying to net cells, some are exact duplicates, some are not
0
votes
1answer
177 views

Copy formula with changing references

Need your help because I am not sure of the correct formula to use (if ever there is one!) in Excel 2010. Say in column A, I have my figures (A1 to A1000). Suppose in column B I need to get the ...
4
votes
1answer
1k views

How do I copy the results of a calculation without copying the formula behind it? Open Office Calc

How do I copy and paste only the results of a calculation without copying the formula behind it? I'm learning to use Open Office Calc. I remember other spreadsheets that had a values function, or ...
3
votes
4answers
4k views

How can I show values in the formula bar instead of cell references?

Here is what I have in my worksheet: A1=2 B1=3 C1=A1+B1 I want the actual cell to show 5 but when I copy C1 I want the formula in the cell to show =2+3, not =A1+B1 or 5 is there a way to do ...
3
votes
5answers
23k views

Excel: copy cell formatting in equation

If I make an equation: ' on cell A2 =A1 Is there a way to make A2 have the exact same formatting as A1 and not just the value? EDIT: i.e. I want a FORMULA that copies both the value and the ...
0
votes
3answers
15k views

Excel 2007 formulas not autofilling when I drag down

If you write a formula like: =sumproduct((something=$A1)*(somethin=$B1)) Giving a result of 8. Usually the references and results change as you drag it down into other cells. Well,the references ...