How is Autofill helpful? Explain with an example.
Answers
Answered by
1
Answer:
AutoFill is a very useful Excel feature. It allows you to create entire columns or rows of data which are based on the values from other cells. In other words, Excel compares the selected data and tries to guess the next values that will be inserted.
Example:
Look at the following example. In cell B2, there is the word- “January”. Excel automatically recognizes it as the first month. Click this cell to activate it. Move the cursor to the bottom right corner so that it will change to a small black cross.
Drag your cursor to cell F2. As long as you hold down the mouse button, Excel shows you which month will be inserted into the last cell in a small rectangle.
Attachments:
Similar questions