Blog

How to Copy and Paste Non Blank cells only from the Column in Excel

How to Copy and Paste Non Blank cells only from the Column in Excel

            


             Today we are introducing the new tip which is very useful in our basic routine activity, as many time we need to copy the text from the columns which contains blank cells and actually we required only the Non-Blank cells only. Here we have the very easy method by using Go-To Special tool.
 
Step-1
Select the data, click on the Find & Select tool in Home Tab, and click on Go To Special option (Ctrl+5) click on the constant option and click ok
 
 
 
Step-2
Copy the data and paste the data in another column.



 

Video Link: Watch Video

Phone : +91 8606648045
Email : info@excelskillcorner.com
Excel Skill Corner
Kerala, India.