You could always go to a blank sheet, type A1 in cell A1 and then drag across for as many cells as desired, then Copy/Paste(Transpose) the range that was created into the sheet and starting cell where it is eventually wanted.Hi Ford - She wants to know if dragging the fill handle to fill a series is flexible or if it's locked in to the default. For example, when we drag Monday, we know we get Tuesday. If we drag a date, we get the next day. If we use CTRL while dragging, it will have the opposite effect. Her initial question to me was if I have A1 typed in a cell and I drag the fill handle, I get A2. Would there be a way to set it up to get B1 instead. The only way I could tell her was Edit Custom Series.