Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dragging to fill dates
When I drag dates the date remains the same.
What do I need to ajust? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dragging to fill dates
Sounds like the dragged dates are not real dates.
Re-enter as a date that Excel recognizes. Gord Dibben MS Excel MVP On Sat, 26 Jul 2008 08:27:00 -0700, Matt S wrote: When I drag dates the date remains the same. What do I need to ajust? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dragging to fill dates
If it's a consecutive series of dates, you might just have to enter the
second date, select both, and then drag down. -- Tips for Excel, Word, PowerPoint and Other Applications http://www.kan.org/tips "Matt S" wrote: When I drag dates the date remains the same. What do I need to ajust? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dragging to fill dates
The problem Im having is not limited to dates. I cant fill sequential
numbers either. And, the problem is only occurring on one worksheet in the workbook. On the problem worksheet, whether I try to fill dates or integers, I cant. But, I added a worksheet and I can do exactly what Im accustomed to. I can drag a date or a set of numbers and get a sequential fill. Honestly. This is one has me really stumped. HELP! "Gord Dibben" wrote: Sounds like the dragged dates are not real dates. Re-enter as a date that Excel recognizes. Gord Dibben MS Excel MVP On Sat, 26 Jul 2008 08:27:00 -0700, Matt S wrote: When I drag dates the date remains the same. What do I need to ajust? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can fill handle be moved without mouse dragging? | Excel Discussion (Misc queries) | |||
Copying formulas by dragging fill box | Excel Discussion (Misc queries) | |||
fill in dates | Excel Discussion (Misc queries) | |||
Pre-fill dates on timesheet | Excel Worksheet Functions | |||
auto fill row with dates | Excel Discussion (Misc queries) |