Excel Guides

Skipping Rows when Filling in Excel

When you are filling in data in an Excel spreadsheet, you may want to skip certain rows so that the data is entered in the correct cells. There are a few different ways to do this:

  1. You can use the Tab key to move to the next cell, skipping any intervening rows. Simply press the Tab key after entering data in a cell, and Excel will take you to the next cell in the column.
  2. If you want to skip more than one row, you can hold down the Ctrl key while pressing the Tab key. This will move you to the next cell in the column, skipping any intervening rows. You can keep holding down the Ctrl key and pressing Tab to keep moving through the cells.
  3. If you want to skip cells in other columns as well as rows, you can use the arrow keys. Pressing the right arrow key will take you to the next cell in the row, while pressing the down arrow key will take you to the next cell in the column. You can also hold down the Ctrl key while using the arrow keys to move through cells.
  4. Fill handle:
    • (Windows) To quickly fill in a series of cells that follow a pattern, select the first few cells in the series, position your mouse pointer over the lower-right corner of selection until you see a black cross (+), and then drag to include all of cells that you want to fill. As you drag, Excel displays a preview of how it will fill your selection based on what's in adjacent cells.



    • (Mac) To quickly fill in a series of cells that follow a pattern, select all of cells that should contain formulas or other content that follows a pattern (for example: "1", "2", "3"), and then drag from bottom right corner of selection until you see a black crosshair (+). As you drag, Excel displays a preview of how it will fill your selection based on what's in adjacent cells.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.