Suppose we want to enter months name in our excel sheet. So for that we will write January in one cell, and now we can autofill other months in different cells in MS Excel. For that we just need to navigate our mouse pointer to the bottom right corner of 'January' cell and then extend it as per our requirement.
Autofill functionality works from both side that is up to down and left to right.
Similarly we can use autofill functionality for writing weekdays and dates.
Autofill formulas are a type of Excel formula that automatically fills in data in cells.
Autofill formulas are a great tool for saving time and ensuring accuracy. They also provide a more efficient way of completing online forms by automatically filling in fields with information that is already known or guessed.
The autofill functions are not limited to a single cell. You can use them in columns or rows as well. You just need to select the cells you want the autofill function to apply to and then choose the desired autofill formula.
If you delete an Autofill formula from a cell, the cells below will have the same data.
Autofill is one of the most useful features in MS Excel. It can save you a lot of time by automatically filling in cells with predefined values. Autofill can be used to quickly fill out a form or spreadsheet with data by selecting a range of cells and then clicking on the autofill button on the toolbar.
Very good 👍👍
I learned a lot of formulas and functions through this lecture in free of cost. Thanks
Please give us an assignment or workbook to download and practice Excel after watching videos.
MORI PARTH RAMESHBHAI
IT'S VERY GOOD AND USEFULL APLICATION WHERE WE CAN LEARN MANY COURSE AND MAKE CARRIER FREE OF COST . HOW CAN I APPRICIATE YOU I DON'T HAVE ANY WORDS REALLY IT'S VERY USEFUL FOR WHO CAN DO JOB LIKE ME
In this video they have mentioned like 2.1% increase in the salary how it can be above 1 lakhs , it should be 52000+2.1%+52000 which seems to be 53092 so, it's my feels as per the question they have