#USING FILL IN EXCEL FOR MAC SERIES#
#USING FILL IN EXCEL FOR MAC MAC#

Using this option will extend the data in the series to the selected cells. When Date is selected as the type, it determines how many dates should be skipped between each recorded value.ĭetermines a value at which the series should no longer be continued. When Linear or Growth is selected as the type, determines the amount that the previous value is added to or multiplied by to come up with the results for the next cell. When Linear or Growth is selected as the type, calculates the average difference between values existing in selected cells and uses that difference to calculate the fill values. When Date is selected as the type, determines whether numbers are listed for each day (Day) for each day in the weekday (Weekday), for that day of every month (Month), or for that day of every year (Year).

In the Series dialog box, select the desired options:ĭetermines whether the additional information will appear in a vertical line (rows) or in a horizontal line (columns).ĭetermines whether the additional information will differ from the previous entry by a specific interval (Linear), by multiplying the previous entry by a specific value (Growth), by creating a series of dates according to the selected date format (Date), or by automatically detecting what type of fill you would like to apply (AutoFill).

(Optional) If you selected the Series option.

NOTE: This option changes the contents of these cells by moving the data to fit within the new rows. This option brings up the Series dialog box, which allows you to select the type of pattern you would like to use.ĮXAMPLE: If the first cell contains the day Sunday, Excel will fill the following cells with Monday, Tuesday, etc.ĭistributes text in the first selected cell throughout several selected rows. Repeats the contents of the selected cells in another selected worksheet.įills in data that is part of a pattern, rather than simply repeating the data across selected cells.

Repeats the contents of the first cell throughout the selected cells to the left of it. Repeats the contents of the first cell throughout the selected cells above it. Repeats the contents of the first cell throughout the selected cells to the right of it. Repeats the contents of the first cell throughout the selected cells below it. From the Edit Menu, select Fill » select the appropriate option:.

Starting with the cell containing the contents to be copied, select the group of cells to be filled.Type the information (cell contents or formula) in the first cell of the group.To extend the series, refer to the mouse option below. This option copies (repeats) the information from one cell to another. Other examples include filling months of the year and hours of the day. For example, if the first cell contains Sunday, Excel will fill the following cells with Monday, Tuesday, etc. NOTE: If Excel recognizes a pattern in the information you entered, the additional cells will contain the next item in the pattern. You can configure how Excel automatically fills in the information for you, and you can create custom patterns of information. If the first cell of your group contains text, the text will be repeated in the additional cells. If the first cell contains a formula, the formula will be repeated in the additional cells. Using the Fill command is the most convenient way to repeat information in neighboring cells of an Excel worksheet. This article is based on legacy software.

#USING FILL IN EXCEL FOR MAC MAC#

(Archives) Microsoft Excel 2007: Using the Fill Command Mac

Using fill in excel for mac