How do I spread within a "series" of increasing numbers in a column in MS Excel?
Starting the beside the cell "design1place1.jpg". I inevitability to drag down the column so that the series continues to "design1place2.jpg". Next would be "design1place3.jpg" and so on adjectives the approach up to "design1place235.jpg"!!. How do I do this?
Answers:
Put numbers starting from 1 thru 235 in the subsequent column. (You can use "Fill" or drag pick for this) Say your first cell is B1 (number 1)
Then type
="design1place"&B1&".jpg"
Copy it down
You will own to use macros on something similar to that, and it's be ages since I've have to use macros near Excel, so can't dispense you step by step directions. Just G00GLE Excel macros and read up on it. It's a bit complicated, though.
Sorry I couldn't be of more comfort.
Using the Fill function, it cannot repeat the workbook next to a number. You will hold to use two columns.
It seem similar to you can use a header within the first col.,
"Design 1" If you want or want every row to contain that, you can copy and pulp it to adjectives the rows, or, place the cursor on the header, "Design 1", underscore adjectives the desired rows within the col. Click on "Edit", "Fill", "Down".
In the second col., The header will be "Place".
You shouldn't entail "Place" to appear surrounded by every row. The header indicates that.
This can be done in duplicate opening, but next you will obligation a third col. for the numbers.
Under "Place", within the subsequent row, Enter 1, down and enter 2, down and enter 3.
Now, place the cursor on number 1, underline adjectives the desired rows.
Click on "Edit". Move to "Fill". A menu pops up, choose "Series".
From the menu box, Choose "Columns",
surrounded by type, choose "Linear",
Step advantage, 1,
Stop importance 235,
afterwards OK.
Does anyone know how to convert American dollars into Japanese yen?
Can Men Be Dietitian?
How to engineer money online?
Can your electric provider disconnect your service after you hold be properly switched to another provider
Did any body ever recieved the mail from some African dune inspector and he/ other ask to verbs Millions of
Answers:
Put numbers starting from 1 thru 235 in the subsequent column. (You can use "Fill" or drag pick for this) Say your first cell is B1 (number 1)
Then type
="design1place"&B1&".jpg"
Copy it down
You will own to use macros on something similar to that, and it's be ages since I've have to use macros near Excel, so can't dispense you step by step directions. Just G00GLE Excel macros and read up on it. It's a bit complicated, though.
Sorry I couldn't be of more comfort.
Using the Fill function, it cannot repeat the workbook next to a number. You will hold to use two columns.
It seem similar to you can use a header within the first col.,
"Design 1" If you want or want every row to contain that, you can copy and pulp it to adjectives the rows, or, place the cursor on the header, "Design 1", underscore adjectives the desired rows within the col. Click on "Edit", "Fill", "Down".
In the second col., The header will be "Place".
You shouldn't entail "Place" to appear surrounded by every row. The header indicates that.
This can be done in duplicate opening, but next you will obligation a third col. for the numbers.
Under "Place", within the subsequent row, Enter 1, down and enter 2, down and enter 3.
Now, place the cursor on number 1, underline adjectives the desired rows.
Click on "Edit". Move to "Fill". A menu pops up, choose "Series".
From the menu box, Choose "Columns",
surrounded by type, choose "Linear",
Step advantage, 1,
Stop importance 235,
afterwards OK.