When you use AutoFill in Excel by pressing the Ctrl key, the values filled in the empty cells are repeated. For example, you have to fill consecutive numbers in the first 20 cells of a particular ...

My copy of Excel (XP) occassionally won't display the "short cut menu" when you drag a series to "autofill" it. (I.E. the date)Since it doesn't appear (sometimes), I can't choose to fill in only ...