I have a spreadsheet and I want to put the date in a cell as 10-10 for example. I then want to use the black cross so that it enters all the way down the column but when I do it goes up a day at a time but I want 10-10 to enter in each cell. How please?
dazwm, the only way I can think of to do what you want is to set up a macro to implement the action based on one of the solutions offered, and to assign that macro to a button or keyboard shortcut. I can't see how it can be done just by double clicking the black cross because Excel doesn't know how many cells to fill - or have I got the wrong end of the stick?
This thread is now locked and can not be replied to.