I am stuck with the simplest of matters. I have a column of dates and want to save time by dragging down and seeing the dates obediently fill the cells. I cannot achieve this and the help says use fill cell which I cannot even find.
Thoughts please? TIA
Welcome @Borders2!
Select the last two cells in your column. Then, at the bottom right corner, you see a little blue square (Just above my red mark):
Put your mouse on it until the cursor changes to a big cross, press the left button and drag down. The dates will fill automatically, using the numbers of days between the two initial cells (in my example, 3 days).
Maybe your dates are just text, not real dates. This wiki page would help, How to convert number text to numeric data
Select the cell range, then choose menu Sheet - Fill Cells - Fill Series - (•) Linear - OK.