I often make worksheets that have a column for the month. Many records contain the same month in the "month" column.
Say my data occupies the range B2:H10, and column A is the "month" column. I decide that I want to assign the month "January" to every item in the list. If I enter "January" in cell A2 and double-click the fill button, the months will be incremented as they fill down the column. I can copy and paste into the entire column, but that's annoying (is there a shortcut key combo to select from the current cell down to the last empty cell in the same column? Even if there is, there must be an easier way than copying and pasting.)
What would be ideal is if I could just turn off the increment feature of the fill button event.
Thanks.
Say my data occupies the range B2:H10, and column A is the "month" column. I decide that I want to assign the month "January" to every item in the list. If I enter "January" in cell A2 and double-click the fill button, the months will be incremented as they fill down the column. I can copy and paste into the entire column, but that's annoying (is there a shortcut key combo to select from the current cell down to the last empty cell in the same column? Even if there is, there must be an easier way than copying and pasting.)
What would be ideal is if I could just turn off the increment feature of the fill button event.
Thanks.