select range containing data

  • Thread starter saman110 via OfficeKB.com
  • Start date
S

saman110 via OfficeKB.com

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.
 
P

Pete_UK

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

Hope this helps.

Pete
 
P

Pete_UK

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
 
Top