How do I markup a column of numbers without adding a column?

  • Thread starter Thread starter Afreshb
  • Start date Start date
A

Afreshb

I am trying to markup a column of numbers but do not wish to add a column
(eg. Column A * .05 for Column B). Is this possible?
 
You mean you want to add 5% to a range of cells? If so,
Enter 1.05 in an empty cell.
Copy that cell.
Highlight the range you want to change
Right-click, choose Paste Special...>Multiply>OK
Delete the 1.05 if desired.

Regards,
Fred
 
If your data is in A1:A99, you could use a formula like:

=a1*.05
Or probably
=a1*1.05
(since it's a markup)

and drag down.

I'm not sure what you mean about not adding a column, though.

=========
Another approach--with your data in A2:A99 (not row 1!)
This would go in B2:
=a2*$B$1
and drag down

You'd put 1.05 or 105% or .05 or 5% (or whatever you wanted)
 
I would say OP does not want to use a helper column.

Wants to do it in situ.


Gord
 
Back
Top