| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell drag and drop
Hi all,
I want to use the Cell Drag and Drop to extend date input: Wednesday Jun 18, 2008 Thursday Jun 19, 2008 Friday Jun 20, 2008 .... How can I do it Clara -- thank you so much for your help |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell drag and drop
Instead of typing in the dates as shown in your posting, type in an actual
date (for example 6/18/2008 or Jun 18, 2008), select the column and Format Cells using this custom format... dddd mmm dd, yyyy That custom format will show the date in the format you want, but the entry in the cell will be a date, so it can be dragged down. Rick "clara" wrote in message ... Hi all, I want to use the Cell Drag and Drop to extend date input: Wednesday Jun 18, 2008 Thursday Jun 19, 2008 Friday Jun 20, 2008 ... How can I do it Clara -- thank you so much for your help |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell drag and drop
if I have understand what you want.
assuming your first date is in a1. use in a2 =a1+1 (format as you need) and drag it down. hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "clara" escreveu: Hi all, I want to use the Cell Drag and Drop to extend date input: Wednesday Jun 18, 2008 Thursday Jun 19, 2008 Friday Jun 20, 2008 ... How can I do it Clara -- thank you so much for your help |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell drag and drop
Hi Marcelo,
It works well. Thank you. You know I like your patriot legend Pele Clara -- thank you so much for your help "Marcelo" wrote: if I have understand what you want. assuming your first date is in a1. use in a2 =a1+1 (format as you need) and drag it down. hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "clara" escreveu: Hi all, I want to use the Cell Drag and Drop to extend date input: Wednesday Jun 18, 2008 Thursday Jun 19, 2008 Friday Jun 20, 2008 ... How can I do it Clara -- thank you so much for your help |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell drag and drop
Thanks for the feedback, glad to help you -- regards from Brazil Thanks in advance for your feedback. Marcelo "clara" escreveu: Hi Marcelo, It works well. Thank you. You know I like your patriot legend Pele Clara -- thank you so much for your help "Marcelo" wrote: if I have understand what you want. assuming your first date is in a1. use in a2 =a1+1 (format as you need) and drag it down. hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "clara" escreveu: Hi all, I want to use the Cell Drag and Drop to extend date input: Wednesday Jun 18, 2008 Thursday Jun 19, 2008 Friday Jun 20, 2008 ... How can I do it Clara -- thank you so much for your help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Fill Handle doesn't display - Allow cell drag and Drop option is c | Excel Discussion (Misc queries) | |||
| how do I drag & drop cell text only | New Users to Excel | |||
| HOW DO I DRAG AND DROP W/O TAKING CELL BORDER? | Excel Worksheet Functions | |||
| How do I set cell drag and drop to be on as a default | Excel Discussion (Misc queries) | |||
| cell drop and drag | Excel Worksheet Functions | |||
Hybrid Mode
