When is fill down useful in excel

This is one of the toughest challenges I have faced early on in my career. Before I tell you what was the challenge let me show you the data first. In the above data, I was asked by my manager to fill down in excel the year to remaining cells until we find the other year i.

I have to fill year from A3 cell to A6 cell. This is the sample of the data but there was a huge amount of data I was needed to fill. To be very frank I spent 1 extra hour than my usual shit time to complete the task. However, later I learned the technique to fill this void cells with the above cell value. Follow the below steps to apply the same logic. Step 5: No do not move your cursor to select any cells. Rather press equal and give a link to the above cell.

Step 6: After giving a link to the above cell, do not simply press enter. You need to use different logic here. In my daily job, I deal with 5 to 10 lakhs of rows of data every day. Often I require to fetch the data from one worksheet to another. Drag the fill handle across the cells that you want to fill. Under Editing Options , check the Enable fill handle and cell drag-and-drop box. To change how you want to fill the selection, click the small Auto Fill Options icon that appears after you finish dragging, and choose the option that want.

For more information about copying formulas, see Copy and paste a formula to another cell or worksheet. You can use the Fill command to fill a formula into an adjacent range of cells. Simply do the following:. Drag the fill handle down or to the right of the column you want to fill. You can always ask an expert in the Excel Tech Community or get support in the Answers community.

Follow these steps to fill a formula and choose which options to apply: Select the cell that has the formula you want to fill into adjacent cells. Fill formulas into adjacent cells You can use the Fill command to fill a formula into an adjacent range of cells. Simply do the following: Select the cell with the formula and the adjacent cells you want to fill.

Click Formulas. Video Link Highlight the range of cells where you wish to perform the fill. Make sure that your starting value is in the first cell that you select.

Click on the Home tab, select the Fill button from the Editing group on the right and in the drop-down menu, select Series. If you have highlighted a row, set Series in to Rows; if you have highlighted a column, set Series in to Columns. For example, 1, 2 begins the set 1, 2, 3, 4, 5… This also works with dates, days of the week, etc.

Video Link Single-click on a cell that contains a formula. You should see a black bold line around it, and a black square in the bottom right corner. When you move your mouse cursor over that square, the cursor turns to a black cross or plus sign.

This is the fill handle. By clicking and holding the left mouse key, you can drag the fill handle down a column or across a row. You will see the cell s you are copying surrounded by a less prominent border. You can also select multiple adjacent cells in the same row or column, and drag down or across in the same way to copy multiple rows or columns of cells at the same time.

Video Link 5 Creating a Custom Series for Filling Data Excel is a powerful tool for creating and organizing data, but we do not always want to order items in a standard or recognizable way. Video Link Click the File tab in the top-left corner of the Excel window. Select Options at the bottom of the left-hand column. In the list on the left of the Excel Options window, click the Advanced tab. On the right, scroll to the bottom and click the Edit Custom Lists button.