| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| When entering data into a range of cells, select the entire range. | Excel Discussion (Misc queries) | |||
| In data range select final value. | Excel Discussion (Misc queries) | |||
| Select data to appear on 2nd sheet by date range... | Excel Discussion (Misc queries) | |||
| How do I select 13 months from a data range for charts | Charts and Charting in Excel | |||
| How do I select on two variables in a range of data in excel | Excel Worksheet Functions | |||
Hybrid Mode
