| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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) | |||
Linear Mode
