A reader wrote to me recently asking me how to use AutoFill in Excel to reflect every other day rather than consecutive days. Seems he was setting up a worksheet to keep track of his diabetes and wanted to use readings every other day.
I was happy to tell him that it was very easy to accomplish this task.
- Simply key in October 6, 2011 in cell A1.
- In cell A2, key in October 8, 2011.
- Select both cells.
- When you hover your cursor and see the Fill handle, drag down the column.
Voila! Every other day will appear in your cells.