Pull the Fill handle down, according to the number of cells you want to fill.
When you release the mouse, Excel will display a small icon representing the Auto Fill Options. Click it.
Click Fill Weekdays (the last option). That's all there is to it! Excel will fill the selected range with only weekdays.
Susan Sales Harkins is an IT consultant, specializing in desktop solutions. Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals.