US Trends

what keyboard shortcut is used to auto fill a series of values in excel 2010

In Excel 2010, there isn’t a single “magic” shortcut that fully replaces the mouse double‑click on the fill handle, but there are two main keyboard approaches people use to auto fill a series of values:

  1. Use the Fill Series dialog (true series control)
    This is the closest thing to a dedicated “auto fill series” shortcut.

    • Select the starting cell(s) that define your pattern (for example, 1 and 2 for a 1‑step number series).
    • Extend the selection to the range you want filled (with Shift+Arrow keys).
    • Press:

      • Alt → H → F → I → S
        This opens the Series dialog, where you can choose:

        • Series in: Rows or Columns
        • Type: Linear, Growth, Date, AutoFill, etc.
        • Step value and Stop value
    • Confirm with Enter to fill the series.
  1. Use Fill Down / Fill Right after defining a series pattern If Excel can already “see” the pattern from the top cells, you can fill the rest with standard fill shortcuts:
    • Enter the pattern in the first one or two cells (for example, 1 in A1 and 2 in A2).
    • Select down or across to the cells where you want the series continued (Shift+Arrow or Ctrl+Shift+Arrow).
    • Then use:
      • Ctrl + D to fill down
      • Ctrl + R to fill right These commands repeat or extend what’s above/left into the rest of the selection, and in many Excel 2010 tutorials they are presented as the main “fill series” keyboard method when combined with a pattern in the first cells.

So, if you’re answering the specific question “what keyboard shortcut is used to auto fill a series of values in Excel 2010?” the most precise ribbon‑based shortcut is:

Alt + H, F, I, S – opens the Series dialog to auto fill a series.

Quick Scoop

  • For a full Series dialog (control over step, stop, dates, etc.):
    • Use Alt + H, F, I, S.
  • For quick vertical/horizontal continuation (once the pattern is set):
    • Use Ctrl + D (down) or Ctrl + R (right).

These are the commonly taught shortcuts in Excel 2010 era guides and videos for auto filling series without relying on the mouse.

Meta description (SEO style):
Learn what keyboard shortcut is used to auto fill a series of values in Excel 2010: use Alt + H, F, I, S to open the Series dialog, plus Ctrl + D and Ctrl + R to extend patterns without the mouse.

Information gathered from public forums or data available on the internet and portrayed here.