Use Excel's Fill Down Command With Shortcut Keys GA S REGULAR Menu Lifewire Tech for Humans Newsletter! Search Close GO Software & Apps > MS Office

Use Excel's Fill Down Command With Shortcut Keys

Save time and increase accuracy by copying data to other cells

By Ted French Ted French Writer Former Lifewire writer Ted French is a Microsoft Certified Professional who teaches and writes about spreadsheets and spreadsheet programs. lifewire's editorial guidelines Updated on December 30, 2020 Reviewed by Jessica Kormos Reviewed by Jessica Kormos Saint Mary-of-the-Woods College Jessica Kormos is a writer and editor with 15 years' experience writing articles, copy, and UX content for Tecca.com, Rosenfeld Media, and many others. lifewire's editorial guidelines Tweet Share Email Lifewire / Alison Czinkota Tweet Share Email MS Office Excel Word Powerpoint Outlook

What to Know

Select the source cell. Then, highlight the range to which you want to copy it and press Ctrl+D.Alternatively, click the fill handle in the source cell and drag it over the target cells. This article shows how to activate the Fill Down command with a keyboard or mouse shortcut in Excel 2019, 2016, 2013, 2010, Excel Online, and Excel for Mac.

The Keyboard Method

The key combination that applies the Fill Down command is Ctrl+D. Follow these steps to see how to use Fill Down in your own Excel spreadsheets: Type a number into a cell. Press and hold the Shift key. Press and hold the Down Arrow key on the keyboard to extend the cell highlight from cell D1 to D7. Then release both keys. Press and Ctrl+D and release.

The Mouse Method

Use your mouse to select the cell that contains the number that you want to duplicate in the cells beneath it. Then, highlight the range to which you want to copy it, and press the keyboard shortcut Ctrl+D . Alison Czinkota / Lifewire

Use AutoFill to Duplicate the Data in a Cell

Here's how to accomplish the same effect as the Fill Down command, but instead with the AutoFill feature: Type a number into a cell in an Excel spreadsheet. Click and hold the fill handle in the bottom right corner of the cell that contains the number. Drag the fill handle downward to select the cells that you want to contain the same number. Release the mouse and the number is copied into each of the selected cells. The AutoFill feature also works horizontally to copy a number of adjacent cells in the same row. Just click and drag the fill handle across the cells horizontally. When you release the mouse, the number is copied into each selected cell. Was this page helpful? Thanks for letting us know! Get the Latest Tech News Delivered Every Day Subscribe Tell us why! Other Not enough details Hard to understand Submit More from Lifewire How to Hide and Unhide Columns, Rows, and Cells in Excel Use Excel's EOMONTH Function to Add or Subtract Months How to Merge and Unmerge Cells in Excel How to Make a Schedule in Excel Ignore Error Values When Finding the Average in Excel How to Use the Google Spreadsheets AVERAGE Function How to Use the Round Function in Excel How to Combine Two Columns in Excel How to Combine the ROUND and SUM Functions in Excel Formatting Numbers in Excel Using Shortcut Keys Learn How to Remove Extra Spaces From Excel Using TRIM How to Split Cells in Excel How to Use the MONTH Formula in Excel Splitting the Screen in Excel How to Calculate Percentage in Excel How to Add Numbers in Excel Using a Formula Newsletter Sign Up Newsletter Sign Up Newsletter Sign Up Newsletter Sign Up Newsletter Sign Up By clicking “Accept All Cookies”, you agree to the storing of cookies on your device to enhance site navigation, analyze site usage, and assist in our marketing efforts. Cookies Settings Accept All Cookies