Suppose you want to create a scorecard for work and you need to auto fill dates but don't need weekends.
Is it possible to click and drag the auto fill and accomplish this?
Well the answre is yes!!
In Excel 2007:
1.Enter the first date in a cell
2.Select the range of cells in the column or row you want to fill including the cell with the first date
3.Select Home --> In Editing choose Fill --> Series...
4.Choose Type = Date then Date Unit = Weekday
5.Select OK.
Is it possible to click and drag the auto fill and accomplish this?
Well the answre is yes!!
In Excel 2007:
1.Enter the first date in a cell
2.Select the range of cells in the column or row you want to fill including the cell with the first date
3.Select Home --> In Editing choose Fill --> Series...
4.Choose Type = Date then Date Unit = Weekday
5.Select OK.
No comments:
Post a Comment
Please free to enter your comments. Thanks!