You can use Autofill for simple tasks like filling in the days of the week. But you can take this tool further and fill dates, patterns, and formatting. What’s more, you can fill cells with values that increase by a certain amount and even combine text from different rows.
Chapters:
0:00 Intro
0:23 Autofill a Pattern
0:47 Autofill with Fill Formatting
1:25 Autofill Linear Amounts
1:54 Exact Linear Amounts
2:41 Autofill Growth Amounts
3:13 Exact Growth Amounts
3:56 Autofill to Combine Text
4:31 End screen
What you’ll learn:
1. Autofill a Pattern
a. How to use Autofill when you have a pattern in your data
b. How to fill the remaining cells with the same letters in that order
c. How to replicate a pattern
2. Autofill Dates
a. How to use Autofill to complete a sequential series of dates
b. Basic Fill Adjusting Dates
c. How to increase the date automatically
d. How to use Autofill for the Short Date format
3. Autofill with Fill Formatting
a. How to copy formatting to unrelated data to save some time
4. Autofill Linear Amounts
a. How to automatically increase numbers in each cell
5. Exact Linear Amounts
a. How to select the exact value for the increase as well as the stopping value
b. How to Enter the Step value which is the number you want to increase each cell
c. How to enter a Stop value which is the number you want to end the series by
6. Autofill Growth Amounts
a. How to fill the remaining cells with all numbers increasing by multiply
7. Exact Growth Amounts
a. How to select the exact value for the Growth increase as well as the stopping value
b. How to Enter the Step value which is the number you want to multiply each cell by
c. How to enter a Stop value which is the number you want to end the series by
8. Autofill to Combine Text
a. How to combine text in different rows into a single cell
b. How to make the text from all cells combined into a single cel
Song: KSMK – Trip
Music provided by Vlog No Copyright Music.
Creative Commons – Attribution-ShareAlike 3.0 Unported
Video Link: https://www.youtube.com/watch?v=S5_BAtFklkU&t=0s
#computereverywhere #howto #autofill #microsoftexcel
Leave a Reply