# Tagged Questions

**0**

votes

**2**answers

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

**1**answer

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

**1**answer

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

**4**answers

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

**5**answers

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

**3**answers

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 ...