hi i am new here and i would like to know if it is possible to edit a whole column (marked field)
and multiply it by 4
example:
1
2
3
4
5
6
7
8
9
10
output:
4
8
12
16
20
24
28
32
36
40
hi i am new here and i would like to know if it is possible to edit a whole column (marked field)
and multiply it by 4
example:
1
2
3
4
5
6
7
8
9
10
output:
4
8
12
16
20
24
28
32
36
40
Last edited by wizardchris90; 11-27-2012 at 08:17 AM.
Write number 4 in one (any) cell
Copy that cell
Select column (you want to multiply)
Right click -> Paste spetial -> Multiply
Never use Merged Cells in Excel
Sure
Type 4 in an empty cell, then copy the cell.
Select the range you want to multiply, then right click and pastespecial > multiply.
Hi wizardchris90
See attached B1=4 copy, select cells & paste special.
Change column values.PNG
that was few quick answers ^^ thanks guys and thanks for picture and ofc it works. i did 99 columns yesterday with a calculator that was long hahaha ~20 min.
Last edited by wizardchris90; 11-27-2012 at 08:45 AM.
It really seems like you are new to excel. :P
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks