Month function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

This is probably a real simple solution, but how do I disable the function
that automatically sorts the months/days/etc. when I autofill something in a
cell.

i.e. I'm trying to create a column which has JULY in each cell, however,
when I try and drag down JULY to copy it to other cells below, the cells
automatically display AUGUST, SEPTEMBER and so forth.

Thanx
Srain
 
Try holding down the Ctrl key when dragging.

Does that help?
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)
 
Back
Top