| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
row limitations on excel
I need a worksheet to use more than 1000 independent lines. Is that
possible? My tickets numbers are all different numbers. I can make the work sheet, but cannot use the auto filter to find certain numbers. Anyway around this? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
row limitations on excel
To simply FIND something, use Edit/Find.
"Pamela" wrote in message ... I need a worksheet to use more than 1000 independent lines. Is that possible? My tickets numbers are all different numbers. I can make the work sheet, but cannot use the auto filter to find certain numbers. Anyway around this? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
row limitations on excel
thanks, but i need to use the auto filter and it won't go past 1000
independent rows, is there anyway to make it available for more than 1000 rows? "Bob Umlas" wrote: To simply FIND something, use Edit/Find. "Pamela" wrote in message ... I need a worksheet to use more than 1000 independent lines. Is that possible? My tickets numbers are all different numbers. I can make the work sheet, but cannot use the auto filter to find certain numbers. Anyway around this? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
row limitations on excel
Thanks, but that is not what i am after. I need a worksheet to be able to
auto filter more than 1000 rows. If the column I am auto filtering is more than 1000 rows of independent numbers, after row 1003, will not show on the auto filter drop down list. Any ideas? "Pamela" wrote: I need a worksheet to use more than 1000 independent lines. Is that possible? My tickets numbers are all different numbers. I can make the work sheet, but cannot use the auto filter to find certain numbers. Anyway around this? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
row limitations on excel
Autofilter filter more then 1000 rows but only show 1000 unique items in the dropdown
See http://www.contextures.com/xlautofilter02.html#Limits -- Regards Ron de Bruin http://www.rondebruin.nl "Pamela" wrote in message ... Thanks, but that is not what i am after. I need a worksheet to be able to auto filter more than 1000 rows. If the column I am auto filtering is more than 1000 rows of independent numbers, after row 1003, will not show on the auto filter drop down list. Any ideas? "Pamela" wrote: I need a worksheet to use more than 1000 independent lines. Is that possible? My tickets numbers are all different numbers. I can make the work sheet, but cannot use the auto filter to find certain numbers. Anyway around this? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
row limitations on excel
Excuse my clock!
-- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Ragdyer" wrote in message ... Just choose "Custom" from the drop down list, and set your criteria there. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Pamela" wrote in message ... thanks, but i need to use the auto filter and it won't go past 1000 independent rows, is there anyway to make it available for more than 1000 rows? "Bob Umlas" wrote: To simply FIND something, use Edit/Find. "Pamela" wrote in message ... I need a worksheet to use more than 1000 independent lines. Is that possible? My tickets numbers are all different numbers. I can make the work sheet, but cannot use the auto filter to find certain numbers. Anyway around this? |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
row limitations on excel
Just choose "Custom" from the drop down list, and set your criteria there.
-- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Pamela" wrote in message ... thanks, but i need to use the auto filter and it won't go past 1000 independent rows, is there anyway to make it available for more than 1000 rows? "Bob Umlas" wrote: To simply FIND something, use Edit/Find. "Pamela" wrote in message ... I need a worksheet to use more than 1000 independent lines. Is that possible? My tickets numbers are all different numbers. I can make the work sheet, but cannot use the auto filter to find certain numbers. Anyway around this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| excel limitations | Excel Discussion (Misc queries) | |||
| Limitations od Excel Sheet | Excel Worksheet Functions | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
| Excel Autofilter - limitations? | Excel Discussion (Misc queries) | |||
Linear Mode
