View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Skip cell with dates Skip cell with dates is offline
external usenet poster
 
Posts: 1
Default Leaving a cell blank

I have a range of cells (A1 to F1) that I fill with dates. In cell A1 I put
the date in (8/24/08) then use the control,+ and ; keys to drag the dates
across to the end or last cell. Now, How can I do this and skip one cell?
A1=8/24
A2=8/25
A3= skip the cell I want to leave it blank
A4= 8/26
A5=Etc
thanks,
Art