Best Microsoft Excel Bloggers

Thursday, July 16, 2015

Copying Only the Cells that Contain Data

In my last blog entry I talked about using Go To Special to find blank cells. In this entry, written by guest Joe Helstrom, we cover using it to find blank cells as a useful way to only copy cells that contain data.

 Have you ever had a couple of columns of data that you wanted to combine into one column?  What do you do when there are blank spaces in some of the columns of data?  Many will cut and paste the data from one column to the other, then manually delete the rows containing blanks.  This begs the question; Is there an easier way?
Of course there is! One way is to use the GoTo Special feature in Excel.  This feature is located in the Home menu, under Find & Select on the far right hand side of the toolbar. 

Click here for an example of how to do this.

Ms. Excel- Resident Excel Geek