User Tools
Writing /app/www/public/data/meta/toolsandtechnologies/autofill_data_in_a_large_sheet.meta failed
toolsandtechnologies:autofill_data_in_a_large_sheet
Differences
This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
| toolsandtechnologies:autofill_data_in_a_large_sheet [2017/05/12 13:49] – created mmcc | toolsandtechnologies:autofill_data_in_a_large_sheet [2021/06/25 10:09] (current) – external edit 127.0.0.1 | ||
|---|---|---|---|
| Line 1: | Line 1: | ||
| + | ====== 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. | ||
| + | |||
Page Tools
