Prevent copied blank cells from replacing data
- Select the range of cells you want to copy.
- Click Copy
. - Select the upper-left cell of the paste area.
- Click the arrow to the right of Paste
and then click Paste Special. - Select the Skip blanks check box.