Prevent copied blank cells from replacing data

Microsoft Office Excel 2003

Show All Show All

Prevent copied blank cells from replacing data

  1. Select the range of cells you want to copy.
  2. Click Copy Button image.
  3. Select the upper-left cell of the paste area.
  4. Click the arrow to the right of Paste Button image and then click Paste Special.
  5. Select the Skip blanks check box.