Donate SIGN UP

Excel Help

Avatar Image
lukey121 | 10:48 Sun 04th May 2008 | Technology
3 Answers
Can someone help me with excel. If I enter the date 01/05/08 how do I make it go all the way down the page in each row. so its goes 2/5/08 3/5/08 etc. or do I have to write each date in?
Gravatar

Answers

1 to 3 of 3rss feed

Best Answer

No best answer has yet been selected by lukey121. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.
You can put a formula in the the cell below such as =A1+1.
The copy the formula to the rest of the cells in the column.
Another option is the auto fill, type in the date and then move the cursor to the corner of the box until you see a "+" and then drag the cursor down. The dates will then appear. beso's function will be the one to use if you want to input varying start dates.
If you will need to change the dates ... beso's best method
if not THECORBYLOON's makes sure you can't (easily - by mistake)

1 to 3 of 3rss feed

Do you know the answer?

Excel Help

Answer Question >>