How can you square many numbers in different cells at once in an excel spreadsheet?

i really need help there are so many numbers i have to do for coursework...!





please can you help me.


thankyou.How can you square many numbers in different cells at once in an excel spreadsheet?
You can do it many ways. The absolute simplest, which retains the list of original numbers, is to 1) highlight and copy the list of numbers, and paste it into an appropriate place, and then 2) immediately click on Paste|Special and look for and select ';Multiply'; and press Enter.





That will multiply the number in each cell by itself, which happens to be squaring.





For instance, perhaps you have a row of numbers (or a column, but I'll say row so people see it works either way 鈥?for that matter, it could be several rows and columns or even a batch of cells individually marked with Ctrl-click) that you want to square. Maybe cells B8:K8. You want the squares to appear on an answering page in the test (a test given as a spreadsheet one interacts with). Highlight the range B8:K8 and click Copy, then go to the answering page and click on the first cell available for this answer. Now click Paste which places the original numbers in the row starting in the clicked cell. Finally, click Paste|Special, hunt for and click in the little bullet hole next to ';Multiply'; and press Enter.





And done! If you wanted to multiply such a range by, say 48.449576, you would have pasted the original set so as to absolutely accurately define the range on the answering page, then type ';48.449576'; into one of them, copy and paste it to the rest and then re-copy the original set of numbers and do the Paste|Special thing again. As you can see, it multiplies the clipboard contents by whatever is in each cell. (The original problem put the numbers you wanted to square in those cells, not ';48.449576,'; so that when you did the Multiply thing you squared them.)





If you wish, of course, you could use a formula like ';=B8^2'; and copy and paste it to the range where you desire the answers. This is a little more ';permanent'; than the other way and for empty cells in the original range you end up with zeroes showing in the answer area. This is probably the most common way to approach it, but as mentioned, it has a couple issues.


For instance, perhaps you have a row of numbers (or a column, but I'll say row so people see it works either way 鈥?for that matter, it could be several rows and columns or even a batch of cells individually marked with Ctrl-click) that you want to square. Maybe cells B8:K8. You want the squares to appear on an answering page in the test (a test given as a spreadsheet one interacts with). Highlight the range B8:K8 and click Copy, then go to the answering page and click on the first cell available for this answer. Now click Paste which places the original numbers in the row starting in the clicked cell. Finally, click Paste|Special, hunt for and click in the little bullet hole next to ';Multiply'; and press Enter.





And done! If you wanted to multiply such a range by, say 48.449576, you would have pasted the original set so as to absolutely accurately define the range on the answering page, then type ';48.449576'; into one of them, copy and paste it to the rest and then re-copy the original set of numbers and do the Paste|Special thing again. As you can see, it multiplies the clipboard contents by whatever is in each cell. (The original problem put the numbers you wanted to square in those cells, not ';48.449576,'; so that when you did the Multiply thing you squared them.)How can you square many numbers in different cells at once in an excel spreadsheet?
Easy - in the column next to the numbers, add this formula





=A1*A1 - that squares the value in the cell A1





fill this down or across, wherever you need the squared numbers.