From the course: Microsoft Office Specialist: Excel Expert (Microsoft 365 Apps) Cert Prep

Unlock the full course today

Join today to access over 25,200 courses taught by industry experts.

Fill cells using advanced Fill Series options

Fill cells using advanced Fill Series options - Microsoft Excel Tutorial

From the course: Microsoft Office Specialist: Excel Expert (Microsoft 365 Apps) Cert Prep

Start my 1-month free trial Buy for my team

Fill cells using advanced Fill Series options

“

- [Instructor] Autofill is a feature that fills cells based on the existing data in the pattern that you show Excel. Well, in this video, I'm going to show you how to use the advanced fill series options, such as creating a linear series or creating a growth series. Sound intriguing? Awesome. Well, let's go ahead and get started. We're working in the 0302 Advanced Fill Options workbook, and I first want to show you how I can complete the list of abbreviated months for my column headings. I'll click on June and use the autofill handle and go all the way across to December, and what I'm seeing here are not the fill series options, but rather, I'm seeing the quick analysis tools. Let me show you how to fix that, just in case this happens to you. We'll go to file, options, advanced, and come down to cut, copy, and paste, and just make sure that you have a check mark next to show paste options button when content is pasted.…

Contents