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.

Thanks.

In column B cell 1 use the formula =A1-48

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: OKYou 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 AMIKE

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.

Very helpful. Thank you both!

Ask Your Question

Weekly Poll

Have you played Jackbox during the pandemic?

Discuss in The Lounge

Poll History