Increasing range for autofilter?

#1 July 23rd, 2004, 12:52 PM

Is there anyway to increase the range of the autofilter without having
to use advanced filter? I have about 3,000 lines in my spreadsheet so
far and its only showing about the first 1,000 of the category chosen.

If I must use advanced filter is there a link I can go to that will
show me. I am having trouble understanding the guide in Excel.

---
Message posted from http://www.ExcelForum.com/

#2 July 23rd, 2004, 01:06 PM

Hi

Have a look he
http://www.contextures.com/xlautofilter02.html#Limits

--
Andy.

"jkb724 " wrote in message
...
Is there anyway to increase the range of the autofilter without having
to use advanced filter? I have about 3,000 lines in my spreadsheet so
far and its only showing about the first 1,000 of the category chosen.

If I must use advanced filter is there a link I can go to that will
show me. I am having trouble understanding the guide in Excel.

---
Message posted from http://www.ExcelForum.com/

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Setting chart data range automatically	LoucaGreen	Charts and Charting	4	July 27th, 2004 02:06 AM
Access2000: Copy a range of rows to another range of rows using VBA	Arvi Laanemets	Worksheet Functions	1	May 10th, 2004 08:48 AM
Printing named range only	ray	Worksheet Functions	4	April 26th, 2004 05:29 PM
is there a formula that can count a range of cells with text?	Frank Kabel	Worksheet Functions	0	March 11th, 2004 08:04 PM
Question about an argument, in an OFFSET dynamic range formula	Terry B.	Worksheet Functions	6	December 10th, 2003 10:53 PM