Lesson 6: Skip Blanks – Fill in blank data cells yourself – Basic Excel

Back to the basic Excel Series for beginners, today, I will introduce the Skip Blanks feature to make it more convenient for everyone to copy and paste in Excel.

Skip blanks for what?

Imagine you have 2 columns (1 column has only 1 cell with values ​​and 1 column has values). You want to replace the valuable positions from the column where only a few cells have been filled to the remaining column. Then Skip Blanks will come to work and help you. It will automatically ignore cells that are empty and only “Paste” cells that have a value.

Skip Blank User Manual

Step 1: select Range from B1:B12

Step 2: Right-click and select Copy

Step 3: Select cell A1

Step 4: Right-click and select Paste Special

Step 5: Select Skip Blank

Step 6: Click OK

So I just finished the Skip Blank feature tutorial. Leave a comment to let me know where you guys are