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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top