User Tools
Writing /app/www/public/data/meta/toolsandtechnologies/autofill_data_in_a_large_sheet.meta failed
toolsandtechnologies:autofill_data_in_a_large_sheet
Auto fill data in a large sheet
Author: Michelle McCausland
- With the range selected (A2:A11), press [F5] to display the Go To dialog.
- Click Special.
- Select Blanks.
- Click OK. Doing so selects only the blank cells.
- In the anchor or active cell, enter =A2 (be sure to adjust the cell reference accordingly when applying this to your own work).
- Press [Ctrl]+[Enter] to copy the formula in the active cell to all of the selected cells. Doing so will produce the repeated-date series.
toolsandtechnologies/autofill_data_in_a_large_sheet.txt · Last modified: 2021/06/25 10:09 (external edit)
