How to skip blanks cells while paste in Excel?

This function is used in Excel to repeat the same words with the same location in the paste area ignoring other values in the area/table.

1- Select the range of cells.

2- To perform the task do the following:

  • Press Ctrl + C. Or
  • Right click on the cell then select Copy.

3- Select the paste area.

4- Do one of following:

  • Press Alt + E + S. or Ctrl + Shift + V.
  • Click Right, select Paste Special.

5 Select Skip Blanks from left bottom of an appeared window.

6 Click OK and see the result.

Copyright © 2016 - 2018 Explainry.com | All Rights Reserved