It can even be that you have not selected the entire range that has your sequential values. Once you have enabled this, you can easily use Excel Fill handle feature! STEP 3:In the Advanced category, under Editing options, select the Enable fill handle and cell drag-and-drop check box. STEP 2: Click Options from the menu on the left side

If you are unable to use this function, you can simply fix it using the steps below: Let’s see how you can overcome these problems. If you are unable to use this function or the filled values are not as per your pattern, you can easily fix it. STEP 4: After using the Excel fill handle, your values will be filled, like so! STEP 3: Go to the bottom right of your selection, you can drag the fill handle Excel to copy data or to fill adjacent cells with a series of data. STEP 2: Select the cells in which you have entered the values. STEP 1: Enter the starting values of your sequence in a range of cells. You can easily learn how to use fill handle in Excel by following the steps below: So using the fill handle, you can fill all the cells below with values that follow in the series, like 4,5,6…. This is known as a fill handle Excel and it can fill adjoining cells with subsequent data following a certain pattern.įor example, cells A1, A2, and A3 have the values 1,2, and 3. In Excel, you are equipped with a tool that can help you fill values in neighboring cells.

Excel for mac not working