- Save time and improve accuracy by copying data to other cells
- Use padding to duplicate data in a cell
- Keyboard method:
- Mouse method
- Use auto-complete to duplicate data in a cell
Save time and improve accuracy by copying data to other cells
Entering numbers, text, and formulas into Excel spreadsheets can be tedious and error-prone if you enter each cell of text or value individually. When you need to enter the same data in multiple adjacent cells in a column, the Fill command can quickly complete the task using only the keyboard. Alternatively, you can also use the autocomplete feature.
The information in this article applies to Excel 2019, 2016, 2013, 2010, Excel Online, and Excel for Mac.
Use padding to duplicate data in a cell
Shortcut that applies the Fill command:
CTRL + D
Follow these steps to see how to use Fill Down in your own Excel spreadsheets:
Enter a number, such as 395.54, in cell D1 in the Excel spreadsheet.
Press and hold a key Shift on keyboard.
Press and hold a key Arrow down on the keyboard to increase cell selection with cells D1 before D7 . Then release both keys.
Press and hold a key ctrl on keyboard.
Press key d on keyboard.
Release both keys.
In most versions of Excel, you can use your mouse to select the cell with the number you want to duplicate in the cells below. You can then select the last cell in the range to highlight the first and last cells and all intermediate cells.
Use hotkey ctrl + d to copy the number in the first cell to all selected cells.
Use auto-complete to duplicate data in a cell
Here’s how to achieve the same effect as the Fill command, but with the AutoComplete feature instead:
Enter a number in a cell in an Excel spreadsheet.
Press and hold fill mark in the lower-right corner of the cell with the number.
Drag the fill handle down to select the cells where you want to place the same number.
Release the mouse button and the number will be copied to each of the selected cells.
The auto-complete feature also works horizontally to copy the number of adjacent cells in one row. Just click and drag fill mark cells horizontally. When you release the mouse button, the number is copied to each selected cell.
Instead of tedious typing or copying and pasting a formula, select the field that contains the formula and use AutoFill to complete the task.