select range containing data
 

I have selected some rows and in those rows I have data.
Rows goes all the way to the end of the sheet. Is there anyway I could
select only cells with data in them.

thx.

--
Message posted via http://www.officekb.com

select range containing data
 

Press F5 (or click on Edit | GoTo), then click Special and then non-
blanks.

Hope this helps.

Pete

On Mar 21, 12:24*am, "saman110 via OfficeKB.com" <u35670@uwe wrote:
I have selected some rows and in those rows I have data.
Rows goes all the way to the end of the sheet. *Is there anyway I could
select only cells with data in them.

thx.

--
Message posted viahttp://www.officekb.com

select range containing data
 

Sorry, I was thinking of Autofilter.

Try again:

Press F5 (or click on Edit | GoTo), then click Special and then
Constants or Formulas (tick which)

Hope this helps.

Pete

On Mar 21, 12:33*am, Pete_UK wrote:
Press F5 (or click on Edit | GoTo), then click Special and then non-
blanks.

Hope this helps.

Pete

On Mar 21, 12:24*am, "saman110 via OfficeKB.com" <u35670@uwe wrote:



I have selected some rows and in those rows I have data.
Rows goes all the way to the end of the sheet. *Is there anyway I could
select only cells with data in them.

thx.

--
Message posted viahttp://www.officekb.com- Hide quoted text -

- Show quoted text -