| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
Auto Populate Cells
Hello,
I have 450 items that I need to enter into a spreadsheet. The are named A100 - A550. Is there a way to have this automatically populated into the cells rather than having to enter each one manually? Thanks for any advice |
|
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
Auto Populate Cells
John,
Not quite automatic but not bad. Put A100 and A200 in the top 2 cells of the range and drag over them to select them both. Hover the mouse over the black dot in the bottom right and press and hold the left mouse button and drag down to auto fill the amount you want. Mike "John" wrote: Hello, I have 450 items that I need to enter into a spreadsheet. The are named A100 - A550. Is there a way to have this automatically populated into the cells rather than having to enter each one manually? Thanks for any advice |
|
#3
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
Auto Populate Cells
Mike,
Thanks! Exactly what I needed. John "Mike" wrote: John, Not quite automatic but not bad. Put A100 and A200 in the top 2 cells of the range and drag over them to select them both. Hover the mouse over the black dot in the bottom right and press and hold the left mouse button and drag down to auto fill the amount you want. Mike "John" wrote: Hello, I have 450 items that I need to enter into a spreadsheet. The are named A100 - A550. Is there a way to have this automatically populated into the cells rather than having to enter each one manually? Thanks for any advice |
|
#4
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
Auto Populate Cells
Mike, I would have thought that you would put A101 into the second cell. not
A200? Gatsby "John" wrote: Mike, Thanks! Exactly what I needed. John "Mike" wrote: John, Not quite automatic but not bad. Put A100 and A200 in the top 2 cells of the range and drag over them to select them both. Hover the mouse over the black dot in the bottom right and press and hold the left mouse button and drag down to auto fill the amount you want. Mike "John" wrote: Hello, I have 450 items that I need to enter into a spreadsheet. The are named A100 - A550. Is there a way to have this automatically populated into the cells rather than having to enter each one manually? Thanks for any advice |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| auto populate cell based on previous cell drop down list selectio. | Excel Discussion (Misc queries) | |||
| auto color fill cells | New Users to Excel | |||
| Auto Selecting Cells | Excel Worksheet Functions | |||
| Populate multiple cells using the same reference | Excel Worksheet Functions | |||
| how do populate empty cells with the contents of populated cells . | Excel Discussion (Misc queries) | |||
Linear Mode
