(03) 9999 7780

Call for Queries?

Training Centre

View on Map

Save Time in Excel with AutoFill

Save Time with AutoFill in Excel

One of the great time savers in Microsoft Excel is Autofill, but would you like to know how to use it even more effectively?

Try this quick tip.

Step 1. Enter a value such as a Day or a Month name, then use the Fill Handle at the bottom right corner of the cell to drag down or across.

Step 2. Release the mouse, then click the Smart Tag that appears at the bottom of your selection to display more fill options.

Step 3. Click the desired option from the pop-up menu.

Job done! Your selection is filled using the option you choose.

Bonus Tip!

When dragging the Fill handle, use the right mouse button as you drag. This will automatically display the options without the need to click on the Smart Tag.

Summary

AutoFill is such a great time saver. Just type an entry such as Monday, January, Qtr 1 or today’s date, then use the Fill Handle at the bottom right of the cell to extend the values down or across the sheet.
What many users don’t know is that you can choose more options by clicking the Smart Tag that pops up at the bottom right of the range after dragging. In the example above I typed “Monday”, then used the fill handle to drag down a few rows. I then clicked the Smart Tag and selected Fill Weekdays to omit the weekend from my range.
I hope you found this quick tip helpful. Check in with us regularly for more Excel (and more) goodness!

Share This Post

Share on facebook
Share on linkedin
Share on twitter
Share on email
Keystroke Learning - Building Computer Skills to Enable Success

Learn Today Face to Face Online with Keystroke Learning

Learn with Keystroke Learning

Our training approach is professional yet friendly, motivating participants to learn quickly and easily. 

When you complete our training course, you will be ready to apply your new skills right away. 

If you have a customised training solution in mind or need to schedule our popular computer courses
Interested in learning more about our offerings?
Our team will take the time to discuss your requirements and help you make smart decisions that best meet your needs.
© 2016 Onwards – Keystroke Learning – ABN 11 620 050 759
Keystroke Learning - Building Computer Skills to Enable Success

Log in

Keystroke Learning - Building Computer Skills to Enable Success

Melbourne Training Centre

Suite 613, Level 6,   1 Queens Road Melbourne, VIC 3004

Venue Access Hours

Monday – Friday 8:30am – 5:00pm

Are you Running Late???