6 lessons in order
With Google Sheets, autofill allows you to enter data without having to type it all by hand. When working with numbers, dates, or the days of the week, autofill can be used to extend cells. It can also be used to duplicate formulas between cells. To use autofill, you must first enter data in a […]
Learn how to autofill in Google Sheets without dragging using keyboard shortcuts, the suggested autofill box, or the Fill Down feature.
Autofill date in Google Sheets when a cell is updated using Apps Script or checkbox triggers with automatic timestamping options.
Learn how to autofill cells in Google Sheets based on another column using VLOOKUP, ARRAYFORMULA, IF statements, or custom Apps Script rules.
Learn how to add serial numbers in Google Sheets using Fill Handle, ROW, SEQUENCE, incremental addition, and ARRAYFORMULA techniques.
Learn how the Smart Fill feature works in Google Sheets, what it does, and how to use it to quickly auto-complete and format your data.