Re: Does anyone know how I can put percentages beside this raw figure data in a sprea
I don't know exactly what your question is, and am interpreting your question re using a different number each time in a couple of ways; hopefully one of these will be helpful to you:
1. If you want to put in a set of numbers, e.g. A1 = 1, A2 = 2, A3 = 3 and so on to A20 = 20, you don't have to type in the numbers each time. Just type 1 in A1 and 2 in A2. Highlight cells A1 and A2, then bring your mouse pointer to the bottom right of cell A2. The pointer will change from a fat white cross to a narrow black cross. Click and drag downwards as far as cell A15 and the numbers will be filled into this area, i.e. 1, 2, 3, 4, 5, up to 20. If you just select 1 cell then the number in that cell will be copied down.
2. If it's the formula you want to copy, e.g. the percentage result in a cell, the same theory applies, just click on the bottom right of the cell you want to copy the formula of and drag down as far as you need to. Say cell C1 = A1 + B1, when you drag down from C1, then the cell underneath (C2) will contain the formula A2 + B2, i.e. Excel knows that you want to apply the same formula to different cells.
Hope the above is somewhat useful, if not then perhaps you could be more specific and you will get plenty of help.
You're coming off as being very defensive and I would read Leghorn's comments as trying to be helpful. How was anyone supposed to know you need to get some work done for Monday? And if you ask more specific questions then you will get more specific advice, there are some people here who are really good with spreadsheets.
I don't know exactly what your question is, and am interpreting your question re using a different number each time in a couple of ways; hopefully one of these will be helpful to you:
1. If you want to put in a set of numbers, e.g. A1 = 1, A2 = 2, A3 = 3 and so on to A20 = 20, you don't have to type in the numbers each time. Just type 1 in A1 and 2 in A2. Highlight cells A1 and A2, then bring your mouse pointer to the bottom right of cell A2. The pointer will change from a fat white cross to a narrow black cross. Click and drag downwards as far as cell A15 and the numbers will be filled into this area, i.e. 1, 2, 3, 4, 5, up to 20. If you just select 1 cell then the number in that cell will be copied down.
2. If it's the formula you want to copy, e.g. the percentage result in a cell, the same theory applies, just click on the bottom right of the cell you want to copy the formula of and drag down as far as you need to. Say cell C1 = A1 + B1, when you drag down from C1, then the cell underneath (C2) will contain the formula A2 + B2, i.e. Excel knows that you want to apply the same formula to different cells.
Hope the above is somewhat useful, if not then perhaps you could be more specific and you will get plenty of help.