Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Save-As Option Disable | Excel Worksheet Functions | |||
how do I disable the option that keeps incrementing cells by 1? | Excel Worksheet Functions | |||
Disable Customize option next to a tool bar from VB | Excel Discussion (Misc queries) | |||
How to disable smoothline option. | Charts and Charting in Excel | |||
Disable "Save As" Option | Excel Discussion (Misc queries) |