Square cell values, repost to same cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JeffreyT.Talbot@gmail.com - 19 Sep 2007 16:16 GMT

Column A in excel is populated by the following

Column A
_________
1
2
3
4
5
6
7

I know that I can put in column B a value of 2-->copy-->highlight
column A-->paste special--> then multiply column A values by 2.

But how do I square the values in A and repost to that column, such
that the end result is

Column A
_________
1
4
9
16
25 etc...

Reply to this Message

JE McGimpsey - 19 Sep 2007 16:20 GMT

One way:

Copy the cells in column A. Choose Edit/Paste Special, selecting the
Values and Multiply radio buttons. Click OK.

> Column A in excel is populated by the following
>
[quoted text clipped - 21 lines]
> 16
> 25 etc...

Reply to this Message

JeffreyT.Talbot@gmail.com - 19 Sep 2007 18:38 GMT

> One way:
>
[quoted text clipped - 29 lines]
> > 16
> > 25 etc...

the problem is that I have many columns in this workbook and need to
change to values of the numbers they contain to the squares

Reply to this Message

Peo Sjoblom - 19 Sep 2007 18:48 GMT

It was you who posted the paste special method and JE's method doesn't even
use a help cell, how is it a problem selecting all columns and copy them,
then just do edit>paste special and select multiply?
I mean what you want is n^2 correct?

Signature

Regards,

Peo Sjoblom

>> One way:
>>
[quoted text clipped - 32 lines]
> the problem is that I have many columns in this workbook and need to
> change to values of the numbers they contain to the squares

Just select all values

Reply to this Message

JeffreyT.Talbot@gmail.com - 20 Sep 2007 15:01 GMT

> It was you who posted the paste special method and JE's method doesn't even
> use a help cell, how is it a problem selecting all columns and copy them,
[quoted text clipped - 49 lines]
>
> Just select all values

Thank you very much, that is the solution

Reply to this Message