ExcelBanter - disable consecutive date option

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - disable consecutive date option (https://www.excelbanter.com/excel-discussion-misc-queries/168371-disable-consecutive-date-option.html)

srain001

disable consecutive date option

Hi,

How do I disable the consecutive date function? I'm trying to drag and drop
JANUARY in a column, but it keeps displaying the different months.

Thanx
Srain

Soundar

disable consecutive date option

Hi,

First type Jan in the cell and then hold CTRL key and then drag using fill
handler.

Hope this will clear your doubt.

Regards,
Soundar.

"srain001" wrote:

Hi,

How do I disable the consecutive date function? I'm trying to drag and drop
JANUARY in a column, but it keeps displaying the different months.

Thanx
Srain

Gord Dibben

disable consecutive date option

Right-click and drag.

Release button and "Copy Cells"

Gord Dibben MS Excel MVP

On Tue, 4 Dec 2007 06:08:01 -0800, srain001
wrote:

Hi,

How do I disable the consecutive date function? I'm trying to drag and drop
JANUARY in a column, but it keeps displaying the different months.

Thanx
Srain

All times are GMT +1. The time now is 07:08 PM.