#1
|
|||
|
|||
Autofill dates - how can I get the same date and consecutive dates?
I hope that this is a simple one for someone to answer!
If I highlight a cell with a date in it and get the black cross in the right hand lower corner, I can extend a series of dates (I'm using the UK system of day - month - year) and it will add a day on for me in each of the next cells. If I needed to have the same date in a few of the next cells and then pick up the date addition again, how can I do this other than by typing manually, each date, please? I have Windows 10 and Excel version 14.0.7166.5000 (32 bit). Thanks in anticipation. |
#2
|
|||
|
|||
To keep the same date press Ctrl when you begin to drag down
|
#3
|
|||
|
|||
Thanks for your quick reply Philb1 and for the clear instructions. Used it already!
|
#4
|
|||
|
|||
I like easy ones like that
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Formula or VB to get max date with multiple dates and predecessors? | mjank72 | Excel | 1 | 07-02-2015 06:20 PM |
HELP: Return a value with a date that falls between two other dates | hionman | Excel | 5 | 11-12-2014 09:56 AM |
Date Format: how to output dates that are not US? | tinfanide | Word VBA | 0 | 10-28-2013 03:30 AM |
Default dates for a Date Picker | BoringDavid | Word VBA | 2 | 09-11-2013 01:42 AM |
Creating a consecutive list of dates in a MS word document whenever it is accessed | CrabApple | Word | 11 | 05-17-2012 03:21 PM |