Excel shortcuts

7 timesaving fill-down shortcuts for Excel

If you're an Excel user, you know that the fill-down shortcut is one of the most useful features in the program. It allows you to quickly fill a column with data from another column. For example, if you have a column of dates in one column and you want to fill the next column with the day of the week, you can use the fill-down shortcut. Here are seven other timesaving fill-down shortcuts that you can use in Excel:

  1. To fill a column with the same value, select the cells in the column, type the value, and then press Ctrl+Enter. Excel will fill the entire column with that value.
  2. To fill a column with a series of values that increase by a fixed amount, select the cells in the column, type the first value in the series, and then press Ctrl+Shift+Enter. Excel will fill the column with the series of values that increase by the fixed amount.
  3. To fill a column with a series of values that decrease by a fixed amount, select the cells in the column, type the first value in the series, and then press Ctrl+Shift+Enter. Excel will fill the column with the series of values that decrease by the fixed amount.
  4. To fill a column with a series of values that increase by a percentage, select the cells in the column, type the first value in the series, and then press Ctrl+Shift+Enter. Excel will fill the column with the series of values that increase by the percentage.
  5. To fill a column with a series of values that decrease by a percentage, select the cells in the column, type the first value in the series, and then press Ctrl+Shift+Enter. Excel will fill the column with the series of values that decrease by the percentage.
  6. To fill a column with a series of values that increase by a fixed amount, select the cells in the column, type the first value in the series, and then press Ctrl+Shift+Enter. Excel will fill the column with the series of values that increase by the fixed amount.
  7. To fill a column with a series of values that decrease by a fixed amount, select the cells in the column, type the first value in the series, and then press Ctrl+Shift+Enter. Excel will fill the column with the series of values that decrease by the fixed amount.

These seven shortcuts will save you a lot of time when you're working in Excel. Give them a try the next time you're working with data in a spreadsheet.

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.