Microsoft Excel

Excel - Getting Started with Autofill - MUST KNOW FEATURE

Chris Menard

27 May 2023 — 1 min read

Using AutoFill in Excel is one of Excel's most used features. To be proficient in Excel, you need to master AutoFill. In this video, we will look at using Autofill with Series, Columns, Number Patterns, Dates, and Text.

Topics covered in the video

- Quick navigation around the sheet - Using the Format Painter - Adding a formula - Autofill - Autofill Tips - Autofill Series - Autofill column - Autofill with number pattern - Autofill with dates - Autofill with date pattern - Date and time tips - Insert date and time - Autofill with text

AutoFill in Excel

What is AutoFill in Excel?

AutoFill is a great feature that automatically picks up series or patterns and fills in data. For example, If you type January in cell B1, and Autofill to the right, AutoFill will start putting in February in C1, March in D1, April in E1, and will continue.

Autofill Months in Excel

AutoFill number. In cell A2, type in 1. In cell A3, type in 2. Select A2 and A3, and Autofill down the series.

Autofill numbers

YouTube Video on AutoFill

Excel - Getting Started with Autofill - MUST KNOW FEATURE

Chris Menard to Present “Executive Insights: Harnessing Excel for Strategic Analysis” at EA Ignite Conference

November 4, 2025 Microsoft MVP and productivity expert Chris Menard will be presenting a highly anticipated session titled “Executive Insights: Harnessing Excel for Strategic Analysis” at the EA Ignite Conference, held at the Renaissance Nashville Hotel. This premier event, running from November 3–5, 2025, is tailored for executive assistants

Chris Menard to Present “Mastering Microsoft 365 Copilot” at EA Ignite Conference

Chris Menard will present “Mastering Microsoft 365 Copilot” at EA Ignite in Nashville on Nov 3, 2025. Learn how Copilot boosts productivity in Word, Excel, PowerPoint, Outlook, and Teams during this hands-on session.

Microsoft Teams: Save Chat and Channel Messages is Back!

How to use the newly returned feature that lets you save Chat and Channel Messages in Teams so you can keep important conversations at your fingertips.

OneDrive Request Files: How to Use OneDrive to Collect Files Securely

OneDrive Request Files feature allows you to collect files from people inside or outside your organization, without letting those people see anyone else’s uploads.