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