![]() ![]() ![]() ![]() Excel automatically inserts the next entry and repeats the pattern if you continue to drag past the ending entry. (The Fill handle is on the bottom-right corner of the cell border – a small, black plus sign). Common sequences only require one entry, such as Monday or Friday, to have the following days of the week automatically fill as you drag the icon down or across. Before we explore creating your own custom lists, here are a few tricks to tame the AutoFill feature:Įxcel just needs to see a pattern to fill out the remaining cells. You may already use some of Excel’s AutoFill capabilities to complete names of months, days and years and/or to copy formulas, so you know it is an amazing time saver. Create your Own Lists to Work with AutoFill ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |