When selecting a cell with a value in it and then selecting a number of cells to the right of it and then pushing ctrl+d if fills the selected cells with the values from the row above the selected cells rather than the first cell with a value in it. 220 10 10 10 10 400 becomes 220 10 10 10 10 220 10 10 10 10 after selecting 400, then selecting 4 cells to the right of it and pressing ctrl+d
apparently ctrl+d is a fill down command and does not work with rows. There seems to be no similar fill right or fill selected cells key shortcut.