How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask Tom Your Own Question

Tom, Mac Support Specialist
Category: Mac
Satisfied Customers: 675
Experience:  8 years experience as a Mac administrator for a college
Type Your Mac Question Here...
Tom is online now
A new question is answered every 9 seconds

New to Mac Excel and cant figure this out on PC I can highlight

Customer Question

New to Mac Excel and can't figure this out: on PC I can highlight a cell with a formula in it then "drag" the formula down or across and it autofills and updates each cell. IE: Cell Q8 has formula =sum(Q1:Q7), dragging over autofills formulas as =sum(R1:R7), =sum(S1:S7), etc. In mac when I drag over or down it just copies the originating formula.
Submitted: 7 years ago.
Category: Mac
Expert:  Tom replied 7 years ago.
HelloCustomerand thanks for using

Go the the top right of the cell so that a hand appears.
Hold down the option key on the keyboard and the hand will turn into a fist with a plus sign.
Move it over now and it will adjust the formula.