LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jim Willy
 
Posts: n/a
Default Excel auto filter does not show all choices for the field?

I have a spreadsheet with client information in approx 3900 rows. Using auto
filter to scroll through alphabetized last name field, the data ends part way
through alphabet. Deleting that row, or a group of rows surrounding that one,
doesn't change the result, it always stops at the same line number. This is a
recent problem, it worked fine for two years!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel auto filter doesn't recoginize case - won't filter AA from A Mikey Excel Discussion (Misc queries) 1 September 29th 05 08:18 PM
how do I auto name worksheets in Excel? Kathryn W Excel Worksheet Functions 4 September 2nd 05 06:36 AM
How to Join/concatenate a date field with a time field in Excel? Alan Excel Discussion (Misc queries) 4 August 9th 05 10:07 PM
Word field codes in Excel data file Includetext mranz Excel Discussion (Misc queries) 1 December 7th 04 11:19 PM
auto filter question Juco Excel Worksheet Functions 1 November 28th 04 02:51 PM


All times are GMT +1. The time now is 05:08 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"