excel

  pat2068 23:04 23 Jun 2004
Locked

does anyone know of a program that will let you change months like jan to feb when you reach the 31st of the month with just the enter key i want it for accounts thanks leo

  pat2068 23:22 23 Jun 2004

bump

  VoG II 09:34 25 Jun 2004

Can you explain *exactly* what you are trying to achieve, please?

  Jakey boy 09:38 25 Jun 2004
  pat2068 18:53 25 Jun 2004

i do accounts and i want a program that will change from month to month when you press enter
when you reach the 31 jan and press enter i would like it to change to feb and so on with all the dates down the left hand side leo

  VoG II 18:59 25 Jun 2004

In Excel, write a date in A1 and press the Enter key.

(for example 1-jan-2004).

Hover the cursor over the bottom right of A1 and the cursor should turn into a +

Hold down the left mouse button and drag the mouse down the page and Excel will automatically add consecutive dates for you. Release the mouse button when you have sufficient.

When you need more dates down the left hand side follow the same procedure and Excel will add more.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Best phone camera 2017

Stunning new film posters by Hattie Stewart, Joe Cruz & more

iPad Pro 10.5in (2017) review

28 astuces pour profiter au mieux de votre iPhone