copy formulas in mac excel

Microsoft Microsoft excel mac 2008 upgra...
March 7, 2010 at 16:12:08
Specs: Macintosh
How do I copy a formula to a group of formulas in mac excel
2008?

See More: copy formulas in mac excel

Report •


#1
March 7, 2010 at 17:25:30
Don't understand what your trying to do.
Could you elaborate a bit?

MIKE

http://www.skeptic.com/


Report •

#2
March 7, 2010 at 18:03:18
Here are the instructions in my assignment however it is not for a
mac system:
Use a mixed reference to copy the formula to the rest of the cells.
Because you want
each reference to point to the Profit per Item value in column B,
you can reference $B2.
When you copy this formula to the next column, it will continue
pointing to column B,
but it will adjust the row number as you drag it to the next cell.
Autofill the first row:


Report •

#3
March 7, 2010 at 19:31:38

Report •

Related Solutions

#4
March 7, 2010 at 20:17:17
I appreciate your assistance, but it doesn't work on a mac system. I
just ended up copying cell by cell... not what was wanted but at least
I got the answers.

Report •

#5
March 7, 2010 at 20:29:38
When you select a cell, is there a very small box on the lower right corner of the cell?

If so, then you can grab that box and drag the contents.

Don't know if Mac's have it.
Sorry

MIKE

http://www.skeptic.com/


Report •

#6
March 8, 2010 at 06:24:18
In addition to the AutoFill feature that Mike mentioned, you can also do this, as an example...

1 - In A1 enter =$B1
2 - Copy this cell.
3 - Select A2:A10
4 - Paste

This will put =$B2, =$B3, etc in these cells.


Report •

#7
March 8, 2010 at 12:19:29
Thank you both very much for your assistance. I will
probably need it again before this next 7 weeks are
over.

Have a great day!


Report •


Ask Question