2007-05-11 04:09:00 · 2 answers · asked by clarissa.explainsitall 1 in Computers & Internet ➔ Software
As others have said you can do the copying or simply double click on the plus sign (+) of the first row.Then it will get copied to other cells provided there is no space left in between
But if you have some values you have taken from somewhere else & you want to apply them to all of the rows, then make sure you make them absolute values before proceeding. Otherwise you'll get an error like "#N/A"
You can do this by using F4 key or the dollar mark $
2007-05-11 06:03:11 · answer #1 · answered by voyager 6 · 2⤊ 1⤋
great... but how do you have a single SIMPLE formula apply to the entire column. Example: Product of contents in column A and a constant (like 10)? so the formula is =Product(A,10) BUT THIS YIELDS AN ERROR! PLEASE HELP
2015-03-22 11:09:28 · answer #2 · answered by Mari 1 · 1⤊ 0⤋
Insert the formula in the first box and then put the cursor in the lower right corner of that box until it turns to a + sign. Click and drag the cursor to highlight the boxes in the column that you want the formula to be copied in.
2007-05-11 04:17:46 · answer #3 · answered by Texas Girl 3 · 0⤊ 1⤋
Put the formula in the first cell and then put your cursor over the bottom right of that cell until you see the plus sign (+). Left click and hold it while you drag it down the length of the column. That should do it.
2007-05-11 04:17:01 · answer #4 · answered by Sunshine 6 · 2⤊ 1⤋
Select a range of cells (the entire column in this case), type in your formula, and hold down Ctrl while you press Enter. This places the formula in all selected cells.
2007-05-11 05:27:57 · answer #5 · answered by danlthewizard 2 · 3⤊ 1⤋
if you mean that the formula is in the entire column, just copy the formula and paste it. if you mean that you want to use a whole column in a formula like to add every number entered into column a you would do A:A in the formula. =sum(A:A)
2007-05-11 04:23:49 · answer #6 · answered by Anonymous · 2⤊ 4⤋