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

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?

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

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...MultiplyOK
Delete the 1.05 if desired.

Regards,
Fred

"Afreshb" wrote in message
...
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?

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

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)

Afreshb wrote:

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?

--

Dave Peterson

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

I would say OP does not want to use a helper column.

Wants to do it in situ.


Gord

On Tue, 02 Feb 2010 10:31:34 -0600, Dave Peterson
wrote:

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

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

Could be.

Gord Dibben wrote:

I would say OP does not want to use a helper column.

Wants to do it in situ.

Gord

On Tue, 02 Feb 2010 10:31:34 -0600, Dave Peterson
wrote:

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

--

Dave Peterson