How do I copy a formula to a group of formulas in mac excel

2008?

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:

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.

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.

SorryMIKE

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 - PasteThis will put =$B2, =$B3, etc in these cells.

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!

Ask Your Question

Weekly Poll