- #WHERE IS THE FILL BUTTON ON THE MAC FOR EXCEL HOW TO#
- #WHERE IS THE FILL BUTTON ON THE MAC FOR EXCEL PLUS#
- #WHERE IS THE FILL BUTTON ON THE MAC FOR EXCEL SERIES#
In fact, they work for the first four columns in our example. The four steps above will work in a lot of cases. Excel fills the cells with the right stuff. Click the lower right-hand corner with that black plus, hold the mouse button down, and drag down (or to the right). Move the mouse over that until the cursor looks like a little black “+” as shown below.Ĥ. Look for a little box at the lower right-hand corner of the selected cell. Click on the cell again to select it, and let go.ģ. Type something into a cell and hit Enter (or Return).Ģ. All I did was type the first row of data. Actually, I let Excel do most of the typing for me, using a feature called Auto Fill. That’s one cell of data per second– very, very, very quick, and it’s not because I’m such an amazing typist.
It took me 59.4 seconds to enter this data. Notice anything? Of course you did– each column is a series, progressing from a starting item to an ending item in some sort of regular way.
How to Save Time with Auto-Fill in Excel.
/FillDownSolution-5bdf35c84cedfd00265f70b0.jpg "where is the fill button on the mac for excel")
Enter your step value and any other values on the Series window and click OK.Updated July 6th, 2016. Click Series and the Series window appears as shown below. A drop-down menu appears as shown in the second image. Click the Fill button located on the Editing section of the ribbon's Home tab as shown in the first image. Then select that cell and the cells that you want to auto fill. The Series window can be reached via the ribbon in Excel version 2007 and newer. Enter the desired step value in the box provided and click OK. Click Series or Fill Series on the menu and the Series window displays - as shown above. When you release the mouse button, a menu displays. Hover until you see the Fill Handle and with the RIGHT mouse button, drag the Fill Handle until you have selected the cells to autofill. Fill Handle Right-Click MenuĮnter the first number in the top cell. These two other methods require more steps, but the user only needs to enter the first number of the series in the spreadsheet. Example of Days of the Week (column M): For more information, see How to Autofill Days and Weekdays in Microsoft Excel.Īlternate Methods of Autofilling a Linear Series. Example of Autofilling Hours (column L): See our separate tutorial, How to Autofill Hours and Other Time Increments for more information. Example of Month Names (column K): For detail instructions, see How to Autofill Months and Years. Example of Thousands (column J): In this example, Excel autofills by thousands as our step value is 1000. Example of Multiples of 5 (column I): The Fill Handle is handy for creating multiples of a number. Example of Every 4th Number (column H): In this linear series, the step value is 4, so we enter 2 and 6 in the first two cells in column H. Example of Odd Numbers (column G): When the first two numbers are entered, Excel knows that the step value is 2 and autofills with odd numbers. In each case we entered the first two values so Excel could determine the step value. More Examples of Auto Fill of a Linear Series See Alternate Methods of Autofilling a Linear Series below. There are two other methods in Microsoft Excel to autofill a linear series that you may find of interest though they require more steps. Release the mouse button and the worksheet cells are autofilled (figure 3). Press the LEFT mouse button and drag to select the cells to auto fill (figure 2). Select (highlight) the two cells and hover the cursor over the bottom right corner until the Fill Handle (+) appears - see figure 1. Enter the first two numbers in the first two adjacent cells. Open your Excel worksheet and follow the directions below. How to Create a Linear Series with the Fill Handle In several cases the right mouse button may need to be used, but we'll always inform you if this is the case. Release the mouse and the cells are filled. To autofill, press the left mouse button over the Fill Handle and drag over the cells to be autofilled. When you select your starting cells and hover the mouse over the lower right corner of the cell range, the Fill Handle, a plus sign, appears. How to Use the Fill HandleĮxcel's Fill Handle is a cool tool used inside the worksheet.
But in each case we add or subtract the same number. has a step value of 2 because each new number in the series is "two more" that the number before.Ī linear series can consist of decimals, decreasing values, or negative numbers. In a linear series, the next number in the series is obtained by adding a constant, or step value, to the current number.
Alternate Methods of Autofilling a Linear Series. More Examples of Auto Fill of a Linear Series. How to Create a Linear Series with the Fill Handle. Read our disclosure policy to learn more. ○ This tutorial contains affiliate links.
0 kommentar(er)
