![]() ![]() 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).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |