Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
List
I need to have list down the left side that goes from 100-520 but everytime I
try and drag the list down it goes from adding 10 to just adding 1. I type 100,110,120,130 and drag and it switches to all 100. I also need to have Percentages on the top row. 40%-95% going up by 5%. So I can quickly get the percentage of 100 or 420 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
List
Enter your 1st number (100) then highlight down your column.
go 'edit'.....'fill'....'series' Make the step value 10 and the end value 520 Then do the same thing across the top, 1st number 40, step 5 end value 95 then format them as % "creating a reference list" wrote: I need to have list down the left side that goes from 100-520 but everytime I try and drag the list down it goes from adding 10 to just adding 1. I type 100,110,120,130 and drag and it switches to all 100. I also need to have Percentages on the top row. 40%-95% going up by 5%. So I can quickly get the percentage of 100 or 420 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
List
Thanks. I now have 40%-95% across the top and 100-520 down the side. Now
does anyone know the formula for percentage. I want to be able to see what ex. 85% of 320. "tim m" wrote: Enter your 1st number (100) then highlight down your column. go 'edit'.....'fill'....'series' Make the step value 10 and the end value 520 Then do the same thing across the top, 1st number 40, step 5 end value 95 then format them as % "creating a reference list" wrote: I need to have list down the left side that goes from 100-520 but everytime I try and drag the list down it goes from adding 10 to just adding 1. I type 100,110,120,130 and drag and it switches to all 100. I also need to have Percentages on the top row. 40%-95% going up by 5%. So I can quickly get the percentage of 100 or 420 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
List
Assuming your column down starts in A2, and your row across starts in B1:
=$A2*B$1 and drag across and down. Be sure to enter the $ signs. -- smither fan "creating a reference list" wrote: Thanks. I now have 40%-95% across the top and 100-520 down the side. Now does anyone know the formula for percentage. I want to be able to see what ex. 85% of 320. "tim m" wrote: Enter your 1st number (100) then highlight down your column. go 'edit'.....'fill'....'series' Make the step value 10 and the end value 520 Then do the same thing across the top, 1st number 40, step 5 end value 95 then format them as % "creating a reference list" wrote: I need to have list down the left side that goes from 100-520 but everytime I try and drag the list down it goes from adding 10 to just adding 1. I type 100,110,120,130 and drag and it switches to all 100. I also need to have Percentages on the top row. 40%-95% going up by 5%. So I can quickly get the percentage of 100 or 420 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
List
Another way is to type 100, 110, select both cells, after you've
selected the four cells you'll see a tiny black square in the bottom right of your selection, click on that and drag down until you've reached 520, do the same for your percentages... Sandy creating a reference list wrote: I need to have list down the left side that goes from 100-520 but everytime I try and drag the list down it goes from adding 10 to just adding 1. I type 100,110,120,130 and drag and it switches to all 100. I also need to have Percentages on the top row. 40%-95% going up by 5%. So I can quickly get the percentage of 100 or 420 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
List
sorry, meant "after you've selected both cells"
creating a reference list wrote: I need to have list down the left side that goes from 100-520 but everytime I try and drag the list down it goes from adding 10 to just adding 1. I type 100,110,120,130 and drag and it switches to all 100. I also need to have Percentages on the top row. 40%-95% going up by 5%. So I can quickly get the percentage of 100 or 420 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
List for AutoFilter and list for Subtotals have different meanings? | New Users to Excel | |||
Filter the results of a list based on a previous vlookup against the same list | Excel Worksheet Functions | |||
Creating a List based on your choice from Another List | Excel Discussion (Misc queries) | |||
How to link data from one drop-down list to another | Excel Worksheet Functions | |||
Refresh a Validation List? | Excel Discussion (Misc queries) |