Calc often predicts what data you want to enter into a sheet. By spotting trends in your data, Calc uses educated guesses to fill in cell data for you. Calc uses data
fills to copy and extend data from one cell to several additional cells.
Fills The automatic placement of values in sheet cells based on a pattern in other cells.
51. Fill Cells with Data
One of the most common data fills you perform is to copy one cell's data to several other cells. You might want to create a pro forma balance sheet for the previous five-year period, for example. You can insert a two-line label across the top of each year's data. The first line would contain five occurrences of the label
Year , and the second line would hold the numbers
2004 through
2008 . After entering all the data in year 2004's column, you only need to select that column and drag to fill in the remaining columns.
Even if the only fill Calc performed was this copying of data across rows and columns, the data fill would still be beneficial. Calc goes an extra step, however: It performs smart fills, too. Calc actually examines and completes data you have entered.
Using Calc's fill capability to enter the years 2004 through 2008 across the top of the sheet requires only that you type 2004 under the first Year title, select the cell, and then drag the fill handle right four more cells. When you release the mouse button, Calc fills in the remaining years.
Calc fills in not only numbers in sequences but can also determine sequential years and other sequences (such as extending cells containing 3, 6, and 9 to new cells that hold 12, 15, 18, and so on). Calc also extends days of the week and month names. Type Monday in one cell and drag the
fill handle to let Calc finish the days of the week in every cell you drag to.
Fill handle A small black box, at the bottom-right corner of a selected cell or range, that you drag to the right (or left or down or up) to fill the range of data with values related to the selected range.
1. | Type the Initial Label Type your first label, such as Year, and then press Enter . This will be the value you will fill succeeding cells with. Although you could copy the value to the Clipboard with Ctrl+C and then paste the value to other cells with Ctrl+V , the fill handle is quicker to use.integers , Calc extends the range by increasing the integer by one. Combine text and numbers for more advanced fills. For example, if you extend QTR 1 with the fill handle, Calc continues with Qtr 2, Qtr 3, and so on. Integers Numbers without decimal points such as 0, 52,164, and 435 (also called |
4. | Start Months To see Calc's smarter fill capability, you can type a month name and drag that month's fill handle across or down the sheet to fill in the rest of the months. |
5. | Calc Fills in Month Names When you release your mouse, Calc fills in the remaining month names for you. If you drag the fill handle fewer than 11 additional months, Calc only fills in those months. Therefore, you would drag the January cell's fill handle down only five more cells if you wanted to show the months January through June only. |
6. | Start Year Type the initial year. Any single number, such as a year or any other number without a decimal point, whose fill handle you drag will increment by one in each cell you drag the fill handle to. |
7. | Calc Fills in Remaining Years When you release your mouse, Calc fills in the remaining years by incrementing the years for you throughout the range. |
![[View full size image]](/image/library/english/13860_07inf04_alt.jpg;446283){kind=link}