Excel shortcuts

5 Keyboard Shortcuts for Filling Data in Excel

If you work with data in Excel, you know how important it is to be able to fill data quickly and efficiently. There are a few different ways to fill data in Excel, but the keyboard shortcuts are the quickest and most efficient way to do it. Here are 5 keyboard shortcuts for filling data in Excel:

  1. Ctrl + D � This shortcut will fill the data down from the cell you have selected. So, if you have a column of data that you want to fill down, simply select the cell in the column that you want to start from and press Ctrl + D.
  2. Ctrl + R � This shortcut will fill the data to the right from the cell you have selected. So, if you have a row of data that you want to fill to the right, simply select the cell in the row that you want to start from and press Ctrl + R.
  3. Ctrl + Y � This shortcut will fill the data down and to the right from the cell you have selected. So, if you have a block of data that you want to fill, simply select the cell in the block that you want to start from and press Ctrl + Y.
  4. Ctrl + Shift + D � This shortcut will fill the data down from the cell you have selected, but it will also fill in the formatting from the cell above. So, if you have a column of data that you want to fill down and you want to keep the formatting, simply select the cell in the column that you want to start from and press Ctrl + Shift + D.
  5. Ctrl + Shift + R � This shortcut will fill the data to the right from the cell you have selected, but it will also fill in the formatting from the cell to the left. So, if you have a row of data that you want to fill to the right and you want to keep the formatting, simply select the cell in the row that you want to start from and press Ctrl + Shift + R.

These are just a few of the keyboard shortcuts that you can use to fill data in Excel. There are many more, but these are the ones that I use the most. I hope you find them helpful!

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.