select range containing data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

saman110 - 21 Mar 2008 01:24 GMT

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.

Reply to this Message

Pete_UK - 21 Mar 2008 01:33 GMT

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

Hope this helps.

Pete

> 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
[quoted text clipped - 4 lines]
> --
> Message posted viahttp://www.officekb.com

Reply to this Message

Pete_UK - 21 Mar 2008 01:36 GMT

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

> Press F5 (or click on Edit | GoTo), then click Special and then non-
> blanks.
[quoted text clipped - 13 lines]
>
> - Show quoted text -

Reply to this Message