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 Writer Former Lifewire writer Ted French is a Microsoft Certified Professional who teaches and writes about spreadsheets and spreadsheet programs. our editorial process Ted French Updated on December 05, 2019 reviewed by Jessica Kormos Lifewire Tech Review Board Member 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. our review board Article reviewed on Mar 24, 2020 Jessica Kormos The Ultimate Guide to Keyboard Shortcuts The Ultimate Guide to Keyboard Shortcuts Introduction Windows Timesavers The Best Windows 10 Keyboard Shortcuts Essential Keyboard Shortcuts for Better Productivity How to Use the Shortcut Alt + Underline Shortcut to Create New Folders Essential Shortcuts for iTunes Mac, iOS & iPad Quick Tricks The Best Mac Shortcuts Keyboard Shortcuts for Finder Mac Startup Keyboard Shortcuts 18 Shortcuts for Apple's iOS Shortcuts App iPad Keyboard Tips and Smart Keyboard Shortcuts Android & iPhone Shortcuts The Best Android Shortcuts You Should Be Using Create and Use iPhone X Shortcuts Email Shortcuts The 30 Best Gmail Keyboard Shortcuts for 2020 How to Use Yahoo Mail Keyboard Shortcuts The Complete Apple Mail Shortcut List Shortcuts in iOS Mail Delete Shortcut Keys for Popular Email Programs How to Use Outlook.com Keyboard Shortcuts Create Text Snippets With Shortcuts in Mac OS X Mail Online & Browser Shortcuts Top 36 Shortcuts for Edge and IE 11 Keyboard Shortcuts: Google Chrome for Windows Create Web Page Shortcuts in Chrome for Windows Control Safari Windows With Keyboard Shortcuts Shortcuts for Safari Toolbars Shortcuts for Safari on OS X & Sierra Excel Shortcuts The 23 Best Excel Shortcuts Shortcut Excel's Fill Down Command Shortcut the Current Date/Time Formatting Numbers Adding Worksheets Shortcut to Saving Your Work Creating a Chart MAX Function Shortcut More Office Shortcuts Top 10 Microsoft Word Shortcuts The 5 Best Hidden Word Shortcuts Add Shortcut Keys to AutoText Entries Uppercase Shortcut Key How to Reset Keyboard Shortcuts in Word Shortcut to Speed Up PowerPoint Presentations Other Useful Shortcuts The Best Google Docs Shortcuts 18 Shortcuts for Linux Mint 18 Cinnamon Changing Linux Mint Cinnamon Shortcuts Fedora GNOME Keyboard Shortcuts Maya Keyboard Shortcuts Create or Reassign Keyboard Shortcuts in MS Office Useful Keyboard Shortcuts for Photoshop CC Time-Saving Fill Tool Shortcuts in Photoshop The 5 Most Useful GIMP Keyboard Shortcuts How to Use the GIMP Keyboard Shortcut Editor Shortcuts to Type a Tilde Mark Tweet Share Email Inputting numbers, text, and formulas in Excel spreadsheets can be tedious and prone to error if you enter each cell text or value separately. When you need to input the same data into a number of adjacent cells in a column, the Fill Down command can quickly perform the task by using just the keyboard. Alternatively, you can also use the AutoFill feature. Alison Czinkota / Lifewire The information in this article applies to Excel versions 2019, 2016, 2013, 2010, Excel Online, and Excel for Mac. Use Fill Down to Duplicate the Data in a Cell 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, such as 395.54, into cell D1 in an Excel spreadsheet. Press and hold the Shift key on the keyboard. 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 hold the Ctrl key on the keyboard. Press the D key on the keyboard. Release both keys. The Mouse Method With most versions of Excel, you can use your mouse to select the cell that contains the number that you want to duplicate in the cells beneath it. You can then select the last cell of a range to highlight the first and last cells and all the cells between them. Use the keyboard shortcut Ctrl+D to copy the number that is in the first cell to all the selected cells. 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. Instead of tediously retyping or copying and pasting a formula, select the box that contains the formula and use the AutoFill feature to accomplish the task.