moderated Re: Microsoft Excel
Van Lant, Robin
Be aware that you do not want to have dollar signs in your formula if you are trying to copy them down the Colum. A $ sign in front of a number or letter in a cell reference tells excel to always look at that particular cell, even if the formula is copied to another place. So, if I have a formula to add the content of column A and column b and place the answer in Column c, my formula might be =A1+B1. This would corrected adjust to =a2+b2 if you copy and past the formula into C2.
Robin
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of
Hicks Steven (CORNWALL IT SERVICES) via Groups.Io
Sent: Tuesday, March 31, 2020 10:41 PM To: main@jfw.groups.io Subject: Microsoft Excel
Hi friends,
I Have a formula in cell b2. I Want that same formula to apply to the whole column b. Is there an easy way to do that please?
127 Public Square, Cleveland, OH 44114 If you prefer not to receive future e-mail offers for products or services from Key, send an email to mailto:DNERequests@... with 'No Promotional E-mails' in the SUBJECT line.
|
|