FILL DOWN in GOOGLE SHEETS will amaze you each time you use it!
If a single cell (no pattern) is selected, Fill Down will only repeat the cell contents. When you select cells with a pattern and Fill Down, you will see the pattern repeated. The exception to this is the memorized days of the week and months of the year. You only have to type one day of the week or one month of the year in a cell and when you Fill Down, the pattern will be repeated. This also works with dates and time. If you type a date or time in a cell and Fill Down, it will list the consecutive dates or times. Fill Down will always follow the format (and abbreviation, if used) of the original selected cell(s). Finally, Fill Down can also be used to fill right, fill left, and fill up. P.S. - Fill Down works to copy formulas, too!
