Using fill down in Microsoft Excel 2019

Often, you will need to copy a cell from the range above it, usingthe exact data and formatting. The fill down facility is the quickestway to do this by using the Ctrl key on the keyboard and theD keyboard letter.

  1. Open theEfficientDataEntry.xlsx workbook. 
  2. Cell B9 contains the text Marketing, which has formats applied.
  3. To copy the cell content and the cell formatting, click to selectcell B10, and then press and hold downthe Ctrl keyboard key and press the D keyboardkey.
  4. The content and formatting are duplicated into the next cell.

Leave a Comment