Go To Special

My primary use  for Go To Special  has been to select only the visible data in subtotals and pivot tables; however, it has a lot of other uses.
To learn more about this feature,click here to read my guest blogger's entry.

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.