Instead, Excel observes the rules of Absolute and Relative Cell References (i.e. However, with this type of Autofill, there is no 'series fill' option. The Excel Autofill feature also works with functions and formulas in Excel.
RELATIVE CELL REFERENCE EXCEL DEFINITION QUIZLET FULL
These are: Weekdays (abbreviated or full names): However, there are some text values that Excel recognises as part of a series. The Excel Autofill will generally fill a column with text values by repeating the value(s) in the first cell(s). Fill Years - Look for a pattern in the year when filling the selected cells.Fill Months - Look for a pattern in the month when filling the selected cells.Fill Weekdays - Look for a pattern in the day when filling the selected cells, but do not include Saturdays or Sundays in the series.Fill Days - Look for a pattern in the day when filling the selected cells.As well as the four options for simple numbers and times, there are also the following: However, for dates, there are additional Auto Fill options. Copy Cells, Fill Series,Fill Formatting Only, Fill Without Formatting). Times have the same four Auto fill options as are shown above, for simple numbers (i.e. However, as with simple numbers, you have the option of clicking on the 'Auto Fill Options' box, to select a different type of Auto fill. As dates and times are stored in Excel as numbers, these can also be used with the Excel Autofill.īy default, if you just type in a single date or time and drag the fill handle, dates and times will complete in a series, by adding one day (for dates), or one hour (for times).