If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|