Excel experts, step...
 

MegaSack DRAW - This year's winner is user - rgwb
We will be in touch

[Closed] Excel experts, step this way if you please

2 Posts
3 Users
0 Reactions
62 Views
Posts: 32
Free Member
Topic starter
 

If I want to have a column with the same date (quarter start date) in every cell, how can I do it. If I type it in the top cell then try to just pull it down it adds one day each time.

Thanks in advance,

BB


 
Posted : 01/07/2009 5:35 am
Posts: 99
Free Member
 

Hold down CTRL and drag down.


 
Posted : 01/07/2009 5:38 am
Posts: 368
Free Member
 

or put the same date in 2 cells, highlight both and then drag down - it will recognise that you don't want to add one each time


 
Posted : 01/07/2009 7:09 am