To drag cells in Excel using keyboard, follow these steps:
- Select the range holding the Shift and arrow keys.
- Press Ctrl+D to fill the value down, or Ctrl+R to fill it right.
It will fill the values for the selected cells.
Dragging values is particularly useful for time-saving tasks such as data entry, creating consistent calculations, and replicating patterns. It contributes to a more efficient and organized Excel workflow.
In this Excel tutorial, we will discuss how to drag cells using only keyboard shortcuts.
The usual method for dragging a cell value is using the fill handle icon towards the end of the range. However, some keyboard shortcuts are available if you want to avoid using a mouse completely.
In the following figure, we have used keyboard shortcuts to the drag value “Marketing” down.
2 Cases of Dragging Cells in Excel Using Keyboard
There are two shortcuts to drag cell values for two different scenarios. They are:
Drag Values Vertically Down Using Ctrl+D
Suppose, there is a dataset of Employee ID, Full Name and Department in the range B6:D16. Multiple people belong to the same department. Instead of inserting each value individually, we can use the keyboard shortcut Ctrl+D to fill up the value downwards.
Follow the steps below to drag cells downward:
- Select the first cell.
- Hold the Shift key and down arrow to select the range below.
- Press Ctrl+D to fill the empty cells with the first value.
- Repeat the process for all of the ranges.
The cell values will fill downward.
Read More: How to Enable Drag Formula in Excel
Drag Values Horizontally Using Ctrl+R
Now take a dataset like the following image where the salaries of the employees remained the same in April and May.
We need to drag these values to the right. The shortcut is Ctrl+R for Excel in this case.
Follow these steps to drag cells horizontally using keyboard:
- Select the first data.
Our initial data is in the range D7:D16. So, we selected the whole range.
- Now hold the Shift and right arrow keys to select the cells on the right.
- Press Ctrl+R to fill the cells on the right.
The cell values will fill horizontally after that.
Read More: How to Drag Formula in Excel with Keyboard
Other Keyboard Shortcuts: Alternatives of Dragging Cells
The keyboard shortcuts we discussed above are dedicated to dragging copy the value down or right. There are other shortcuts available too which accomplish the same task. Although, not particularly for dragging, they can copy or fill down, or mimic the filling process.
Other keyboard shortcuts you can use to drag cell values in Excel are:
1. Ctrl+C and Ctrl+V
This is the shortcut for copying and pasting- which is the same thing the dragging shortcut offers.
Follow these steps to use the copy-paste shortcuts to fill values in Excel:
- Select the range you want to copy.
- Press Ctrl+C to copy the range.
- Now move to the cell you want to paste the value.
- Press Ctrl+V to paste the range.
2. Ctrl+Enter
This shortcut fills a range with the same value. The main difference between this key combination with others is this one requires us to select the range first before entering a value. Then using the key combination we can fill out the range with a single value or formula.
Follow these steps to quickly fill a selected range of cells with the content of the active cell:
- Select the range first using the Shift and arrow keys.
- Then press F2. The first cell in the selection will go into Edit mode.
- Insert the value in the first cell manually.
- Now press Ctrl+Enter.
This will fill up the selection with the same value.
Read More: How to Drag Formula and Ignore Hidden Cells in Excel
3. Access Key Combinations
Pressing the Alt key in Excel, you will see letters underlined in the ribbon or menu options. Press one of these letters while holding down the Alt key and you will activate the corresponding command.
These are not actual shortcuts. The key combinations mimic what we do from the ribbon with keyboards. We can use the fill feature (what dragging accomplishes) from the ribbon with Alt key combinations.
Follow these steps to use access key combinations instead of dragging:
- Select the cells you want to fill. The first cell in the selection should be the one containing the value.
We have selected the D13:D16 range for the demonstration. Cell D13 contains the value we will drag.
- Now press Alt, H, F, I, and S in order.
- The Series box will appear. Select AutoFill from here.
You can navigate using the Shift and arrow keys from the keyboard if you want to avoid using the mouse completely.
- Click on OK.
Now the rest of the cells will have the initial value.
Read More: How to Use Fill Handle to Copy Formula in Excel
Download Practice Workbook
Conclusion
Dragging cells in Excel using keyboard shortcuts enhances efficiency and precision in data manipulation. Keyboard shortcuts such as Ctrl+R, and Ctrl+D offer a quick alternative to dragging the mouse cursor. Other shortcuts such as Ctrl+C, Ctrl+V, Ctrl+Enter, and Alt key combinations also offer the same result that ensures streamlined workflow.
If you have any questions, suggestions, or recommendations, let us know in the comments below.
Frequently Asked Questions
How to drag formula in Excel using keyboard?
You can replicate a formula downwards using the Ctrl+D shortcut and horizontally right using Ctrl+R. These are the vertical and horizontal drag shortcuts we mentioned above. They work for replicating formulas too.
How to copy above cell in Excel?
Use the shortcut Ctrl+Shift+ “ (quote) to copy the content from the cell above. The main difference between this shortcut and Ctrl+D is that Ctrl+D replicates formulas with respective cell references. Meanwhile, Ctrl+Shift+“ will only copy and paste the value.
What is the Flash Fill shortcut in Excel?
Excel’s Flash Fill shortcut is Ctrl+E. Insert a value, and select the range including the first value. Then press Ctrl+E. Excel will sense the pattern and fill up the rest of the value. Depending on the complexity of the range and changes, you may need to insert more than one value.
Related Articles
- Excel Fill Down to Next Value
- How to Fill Formula Down to Specific Row in Excel
- How to Use Fill Handle in Excel
- How to Drag Formula Horizontally with Vertical Reference in Excel
- [Solved]: Fill Handle Not Working in Excel
<< Go Back to Fill Handle in Excel | Learn Excel
Get FREE Advanced Excel Exercises with Solutions!