Thread: Autofill Months
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob I Bob I is offline
external usenet poster
 
Posts: 2,819
Default Autofill Months

Format row as Date, "M" then drag across

Caz wrote:
Hi,

If I type Jan into a cell and drag across using the small black box, it does
not increment the month and the option from the smart tag just gives me the
option to copy with or without formulas. Although, this method does work
with numbers.

What do I need to do to drag and increase 1 month (or letter A B C etc) at a
time.

Thanks