subtract in Excel

December 27, 2010 at 12:27:28
Specs: Windows XP
Hi all, column A has 3312 entries (from A1 to A3312) and from each number I have to substract number 48. How can I do that for the whole column because I do not want to do it for each entry.

See More: subtract in Excel

December 27, 2010 at 14:04:51
In column B cell 1 use the formula


Then drag the formula down all 3312 rows.

Once you have all your subtractions done,
You need to change column B from a column of formulas to a column of real values,

First, highlight column B from cell 1 to cell 3312,
then on the Task Bar,
Select: Copy
Select: Past Special,
Select: Values
Click: OK

You could, if you wished, paste the values to A directly but
I would advise you NOT to until you have checked everything
in column B and are sure it's what you want.
Then simply copy column B to A


Report •

December 27, 2010 at 15:55:10
2 other options:

With a formula...

Enter =A1-48 in B1.
Hold your cursor over the lower right corner of B1 until you see the auto-fill plus sign.
Double click to auto-fill to the bottom of your list without having to drag.

Without a formula:

Enter 48 in B1.
Double click the auto-fill handle to put 48 next to each cell in your list.
Right-click the B above Column B and choose Copy.
Right-click the A above Column A and choose Paste-Special.
Click the circle next to Subtract, then OK.
Left-click the B and choose Clear Contents or Delete.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

December 29, 2010 at 01:14:26
Very helpful. Thank you both!

Report •
Related Solutions

Ask Question