What is the use of Auto Fill option? (Excel-2007)
Q. What is the use of Auto Fill option?
Ans. The Auto fill features makes inserting a series of values or text items in a range of cells easy. It uses the auto fill handle. You can drag the auto fill handle to copy the cell or automatically complete a series. If you drag the auto fill handle while you press the right mouse button, excel displays a short cut menu with additional fill options.
To display the list of Auto Fill options, click the Auto Fill Options button. The list of options varies according to the type of data: text and formulas, numbers, months, days of the week, and dates.
The full list of options that may be available is as follows:
| Copy Cells Fill Series Fill Formatting Only Fill without Formatting Fill Days Fill Weekdays Fill Months Fill Years |
|---|
0 comments:
Post a Comment