Excel - Getting Started with Autofill - MUST KNOW FEATURE
Posted on: 05/28/2023
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
Online Microsoft Teams Training with Chris Menard
50% off coupon
Just some of the topics covered
-
Navigation Teams
-
Using private Chat
-
Using group Chat
-
Teams Meetings
-
Scheduling Meetings
-
Meeting controls
-
Roles in a meeting
-
Sharing resources
-
PowerPoint in a meeting
-
Scheduling Team meetings from Outlook
-
Working with Teams and Channels
-
Conversations
-
Files
-
Wiki and OneNote
-
Using Outlook and Teams
-
Using apps in Teams

Recent Articles
Summarize Outlook Attachments with Copilot
In today’s fast-paced digital world, managing emails efficiently is crucial, especially when it comes to handling attachments. I demonstrate an exciting new feature that has rolled out in Microsoft Outlook’s Copilot — the ability to summarize Outlook attachments with Copilot
Chris Menard
Chris Menard is a Microsoft Trainer (MCT) and works as a full-time Trainer at BakerHostetler - one of the largest law firms in the US. Chris runs a YouTube channel with 900+ technology videos that cover various tools such as Excel, Word, Zoom, Teams, Gmail, Copilot, Google Calendar, and Outlook. To date, the channel has helped over 20 million viewers.
Menard also does 2 to 3 public speaking events yearly, presenting at the Administrative Professional Conference (APC), the EA Ignite Conference, the University of Georgia, and CPA conferences. You can connect with him on LinkedIn at https://chrismenardtraining.com/linkedin or watch his videos on YouTube at https://chrismenardtraining.com/youtube.
Categories