
By Default, Linear option is selected, that’s for numeric values ! For auto-filling months or days, select Autofill option and then ENTER. How do I autofill in Excel using keyboard?Īlt + E+I+S then press ENTER. Now the formula is copied to the whole column without dragging the fill handle. How do you fill down in Excel without dragging?Īlternatively, press hit Ctrl + D to fill down or Ctrl + R to fill right.

Where is the Fill Down option in Excel?.How do I autofill in Excel using keyboard?.

How do you fill down in Excel without dragging?.
