To continue my calendar I will want to skip a row. Highlight the two cells and fill to the right to continue numbering the week. In the row below type a 1 where the first day of the month starts. Drag to the right instead of down to continue the days of the week automatically. Type Monday in a cell and Tuesday in the cell to the right of it. You can not only fill down, you can fill to the right. However, there are so many applications for using fill down. I use fill down constantly just to get a list of numbers from 1 to 100 in seconds. Having a list of numbers quickly is very handy. The pattern will continue with a blank row between the values. Click on the fill down square and pull down.
When highlighting your pattern, highlight a blank row. Click and drag the square in the bottom right hand corner to continue the pattern.Īnother pattern you might want to use is skipping rows. Highlight the two cells to tell the spreadsheet that the pattern is to increase by 0.5. Type 1 in one cell and 1.5 in the cell below it. After filling down you now have 3, 4, 5, etc… Click on the square and hold the click as you drag the pattern down the column. The SquareĪfter highlighting the pattern look for the square in the bottom right-hand corner of the highlighted range. For example if I type the number 1 in a cell and the number 2 in the cell below it and then highlight the two cells to signal the pattern, I can “fill down” to continue the pattern. “Fill down” refers to copying the pattern in the spreadsheet down a particular range in a column. If you write a formula in a spreadsheet and then copy the formula to other cells, the spreadsheet recognizes the pattern and automatically adjusts the formula. One of the coolest things about spreadsheets is the ability for it to recognize patterns and apply it over a large range.
0 kommentar(er)
