Need a list of weekdays?
The Auto Fill button allows us to quickly create a lists of days of the week.
However, the list includes Saturday and Sunday. Thankfully Excel offers a very simple solution to create a list that only includes weekdays.
To quickly create a list of Weekdays only:
- First type in your starting date.
- Now click and drag the Auto Fill button to display dates going forward.
- When you release the mouse button Excel will display the Auto Fill Options box.
- Click the drop-down arrow on the box and then select Fill Weekdays.
- Excel will remove any dates that fall in the weekend and only dates for week days will be displayed.
We cover many more fabulous time saving tips and features in our Excel training courses.
Sharyn is an expert trainer. She became the first certified Microsoft® MOUS Authorised Instructor in New Zealand.
She is endorsed by Microsoft® as a qualified Microsoft® Office Specialist and has more than 20 years of experience in the training industry, developing and delivering technology training workshops. Her approach to taking the “techie-speak” out of technology training has placed her as a preferred supplier to many of New Zealand’s leading organisations.
If you enjoyed this you may also enjoy...
How to subtract in Excel
Let me help you learn how to subtract in Excel. It’s simple when you’re shown how, but read to the end to make sure you understand what happens when you multiply and subtract, or divide and subtract in the same formula. This is a tricky one, so please don’t skip over it!
How to unhide columns in Excel
Join the 'Excel at Work Insiders' group today!
100% free. Join now and unlock offers exclusive to this group!
And gain instant access to your first exclusive bonus:
'Steps to becoming Proficient in Excel'!
A list of over 100 skill topics you need to know to become a proficient user of Excel
Need a hand to unhide columns in Excel? There are different methods or unhiding available to you, depending on the version of Excel you are using. I’ll take you through the method that will work on any version.
Best Excel Keyboard Shortcuts for Beginners | Tips and Tricks
Learn the BEST Excel keyboard shortcuts. Perfect for Beginners and for those who want to save time and work smarter. It doesn’t matter if I’m delivering a Stage 1 or a Stage 3 Excel training course – when I’m demonstrating to the class I whip around the screen, format, select and modify and update using shortcut
How to remove Excel formulas and keep the results
If you share Excel files outside of your organisation you’ll enjoy this post where I share with you how to remove Excel formulas and keep the results so that you can confidently send a file knowing you aren’t disclosing confidential information inside of your formulas.
Move, Copy and Paste information in Excel
Learn how to move, copy and paste information in Excel. Once you have mastered Cut, Copy and Paste you will find yourself shifting data around easily and reusing copied data, saving you the need to recreate the same information again. All Windows applications have access to the Windows Clipboard. This is a special area used for
Add colour, borders and alignment settings to Excel data
Learn how to add colour, borders and alignment settings to your Excel data to give your worksheet a more professional look and to make it easier for others to read.