How to use AutoFill Excel: a step-by-step guideIf you are a frequent user of Excel, you might have realized that filling in spreadsheets manually takes a really long time. It is a very tedious job. If you are looking for a way to exponentially reduce the time you spend on Excel spreadsheets, then take a look at how to use AutoFill Excel. Using the Microsoft AutoFill feature makes the process of filling spreadsheets really easy as it lets you fill-up the spreadsheet's cells much faster than if you did it manually. Here is our really simple step-by-step guide on how to use AutoFill Excel. This feature is mostly used when copying formats and formulas, filling in lists, dates, numbers, and many more. The very first step in the process is to open a blank Excel sheet. From here on, just fill the very first cell A1 with whatever you wish to fill. It could be numbers, names, month, or day of the week. Read also Follow this easy guide on how to jump a car Here is how to fill each of the above: Say you wish to have the number 10 all over the worksheet, follow the next steps: If you want to add numbers where they increase in value: A1 =10, A2 =20, A3 = 30 and so forth, do the following: Read also Flash Fill Excel: Find out how to use it quite easily READ ALSO: How to find and remove duplicates Excel: tutorial Months are extremely easy to fill in spreadsheets. Once the first month has been added to the cell, just drag the small cursor in the desired side (downwards or across). Excel automatically fills in all the other months of the year. Note that they can be inserted in full (January) or in short-form (Jan). The program will automatically follow whichever direction is set in the first cell. It should be noted that if you want the cells to have the same month, for example, February over 5 cells, you will need to hold down 'CTRL' on your keyboard as you drag the fill handle, the little black cursor, down. Failure to do this will led to the months being inserted as they would normally appear on the calendar. Weekdays follow the same pattern as months do. Read also Master the concept of how to multiply in Excel with our easy guide Inserting names into the boxes works just the same as with the above names options. Whatever name has been included in the first cell shall be repeated over the other boxes in the worksheet. If the names need to alternate, just fill the required cells with the names and then drag the cursor in the desired side. They shall be inserted in the desired alternating format. The fill function is found at the top right corner of your worksheet. This function is not as fast or as effective as the AutoFill one. However, as you insert in dates, you will note that as you drag the black cursor, a smaller box appears. This has more options. It gives you the option to copy cells, fill series, months, among many others. Instead of having to drag the fill handle all over your sheet, there are two other ways in which you can make the job of filling cells even shorter: Read also How to add in Excel: Simple instructions to follow Instead of dragging the black cursor all over your worksheet, this option lets you copy values/words on cells by just double-clicking on them. Doing this allows Excel to go ahead and copy whatever is in the cell above to all the cells below it. It should be noted that it will stop copying if it encounters an empty row on your spreadsheet. Here are the steps that you will follow: Read also A step by step guideline of how spell check in Excel works Using these two ways makes the time spent on spreadsheets even shorter than before. We hope that this 'how to use AutoFill Excel' step-by-step guide helps you with your spreadsheet needs. READ ALSO: How to split cells in Excel: An easy tutorial Source: Legit.ng If you are a frequent user of Excel, you might have realized that filling in spreadsheets manually takes a really long time. It is a very tedious job. If you are looking for a way to exponentially reduce the time you spend on Excel spreadsheets, then take a look at how to use AutoFill Excel. READ ALSO: Ctrl+D Ctrl+R READ ALSO: