The following assumes that the figures you want to multiply by 6.5 are in column C, starting at C4 - you will have to change C4 to whatever cell your figure is in. In cell D4 enter the formula =C4*6.5 and make sure it is still the active (selected) cell. At the bottom right hand corner of the active cell you will see a small square black blob, this is called the fill handle. Point to the fill handle and the cursor will change shape to a fine black cross. While it is that shape hold down the left mouse button and drag down as far as you want the formula to be repeated. If column C is already populated with data, and there are no blank cells double click on the fill handle.

In the cell next to the topmost entry of your column, type the equal sign, then click the cell to the left with one of your numbers in it, and *6.5, then "enter"; so you would type "=, then click the cell to the left with your number to be multiplied, then *6.5, enter" ... then, in that same cell which you just typed in, double-click the bottom right corner of the cell. To sum up all the numbers in a column, type in another cell "=sum(" Then, highlight the numbers(cells) you want to add together, and then press enter twice.

Let's make this something useful that you can change later on very easily if you want to. That is, today you want to multiply all of the values in a column by 6.5, and that's fine. Maybe tomorrow you might want to multiply by 8, or 6.55, just to see what those numbers look like. So in a blank cell somewhere that's not going to be in the way, put the multiplicand (the number you want to multiply all others by). Just leave it there for now. (You can -- and should !! -- learn to "Name" that cell with Insert / Name / Define, so that you can use it in calculations someday as: = A1 * Named_Cell, which will be very useful. But we'll do something much simpler right now.) We'll do a couple of things here, and you see which one you like best. 1. To CHANGE all of the numbers in the column and make them "what they were, times 6.5", do this: A. Go to the single-cell value where you entered "6.5" and do a Ctrl-C (or Edit / Copy -- it's the same operation). B. Now use the mouse to 'select' all of the numbers in the column whose values you want to CHANGE. C. With those numbers all 'selected', enter the menu commands Edit / Paste Special and click the "Multiply" check box. D. Hit 'Enter'. All of the numbers that you have selected should have been multiplied by 6.5 If that's not what you want, and you don't want to change those 'original' values (which is often the case), then try this instead: 2. You don't want to change the 'original' values in the column, so: A. In some part of the spreadsheet that contains the room you want to show the result of the calculations (it could be "the next column", an "inserted column", "another worksheet", or anything that works for you, enter an equals sign: = B. Now click the top cell in the column that you want to have multiplied, then type a * sign (multiply). Your cell will now show: = A1 * (Where I'm assuming that A1 is the top cell you want to multiply -- your starting cell address will show up. If you did this from "another worksheet", then it might show as: = Sheet1!A1 * C. Now click the cell containing your 6.5 and then immediately hit the F4 key. (I'll explain why in a bit.) Your cell now looks like: = A1 * $D$1 (if D1 was the cell that had the 6.5 value typed in) OR = Sheet1!A1 * $D$1 if you started from one worksheet and decided to show the results of the calculation in another worksheet (the worksheet that contains the 6.5 multiplier) OR = Sheet1!A1 * Sheet1!$D$1 (I know it sounds and looks complicated, but it's easier to do than it is to explain and FAR easier to do than to read about. Just try it.) D. The reason for those $$ around the D1 address is to make that an "absolute" reference. In the next step, you'll see why. E. Now that you have your first cell calculated, just 'Copy' that cell (either 'Ctrl-C' or Edit / Copy from the menu), move your cursor down to the next row, hold the mouse key down to 'select' as many cells below that as you want to copy the same formula, and then hit 'Enter'. F. Your formula has been copied, with the first term, the "A1" value, changing to "A2", "A3", "A4", etc., and the second term, the "D1" (or $D$1) value NEVER CHANGING. That is, you wanted the first term to change to 'next row' each time, but you wanted the cell containing 6.5 to remain the same. This is how you tell Excel to do that. Play with it. Try it all out. The best way to learn is to make a lot of mistakes and learn what's happening (or not happening) each time. The next best way to learn (believe it or not) is to try to explain it to someone else. I have never received any 'instruction' in Excel other than forums like this, but I have learned a LOT from 'explaining' Excel to others.