I have a formula and a format in a cell in the second (and other) row and I would like to copy both the formula and the format to the right (I have column monthly heading) I have been dragging the formula to the right, which is fairly cumbersome because I have a lot of cells to fill. Is there a more effecient way to do this? Thanks.