If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Applying formula's to many cells
I am trying to multiply many cells by 1000, it will take years to type
"*1000" into every cell. Is there any quick method of applying this sum to all cells? Cheers Luke |
#2
|
|||
|
|||
Hi Luke
yes, type 1000 into an unused cell somewhere and then copy it, select the cells that you want to multiply by 1000 and then choose edit / paste special, multiply (please, test first on a backup of your data to see if this is what you're really after) Cheers JulieD "Luke" wrote in message ... I am trying to multiply many cells by 1000, it will take years to type "*1000" into every cell. Is there any quick method of applying this sum to all cells? Cheers Luke |
#3
|
|||
|
|||
Text constants will be unaffected but if you want to restrict
to number constants and change empty cells to zeros you might want to reduce the Selection to number constants with Edit, Goto, Special, Constants, Numbers if you also have formulas involved you will have to repeat for Edit, Goto, Special, Formulas, numbers --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm "JulieD" wrote in message ... Hi Luke yes, type 1000 into an unused cell somewhere and then copy it, select the cells that you want to multiply by 1000 and then choose edit / paste special, multiply (please, test first on a backup of your data to see if this is what you're really after) Cheers JulieD "Luke" wrote in message ... I am trying to multiply many cells by 1000, it will take years to type "*1000" into every cell. Is there any quick method of applying this sum to all cells? Cheers Luke |
#4
|
|||
|
|||
-----Original Message----- I am trying to multiply many cells by 1000, it will take years to type "*1000" into every cell. Is there any quick method of applying this sum to all cells? Cheers Luke . Try using PRODUCT. then copy it to as many cells as you need. ie. +Product(A3,B3) This will multiply what ever is in A3 by what ever is in B3. Then copy the formula down as far as you want using the PASTE SPECIAL command. Hope this helps. Greg |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Displaying cell formulas in certain cells only | E Edgington | Worksheet Functions | 4 | April 23rd, 2004 07:17 AM |
Ignore blank cells in formulas & in average | theroo | Worksheet Functions | 1 | November 8th, 2003 05:49 PM |
formula's in cells | JohnT | Worksheet Functions | 1 | November 3rd, 2003 02:11 AM |
Adding cells with formulas calculating the value | Chris | Setting up and Configuration | 1 | October 15th, 2003 10:59 AM |