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.
Join the channel Telegram of the AnonyViet ๐ Link ๐ |
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