Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Total rows when sorting data
Excel 2000 shows the number of rows like this 100 of 1000 on the lower left
corner of the spreadsheet when sorting data. Can someone tell me where that property is in Excel 2003? Thanks so much! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Total rows when sorting data
I do believe you mean "filtering" rather "sorting"
If you don't see a filtered count at lower left you either have the Status Bar disabled or have run up agaisnt one of the problems found at Debra Dalgleish's site. http://www.contextures.on.ca/xlautofilter02.html#Count Gord Dibben MS Excel MVP On Thu, 28 Aug 2008 12:49:01 -0700, 77Debbie77 wrote: Excel 2000 shows the number of rows like this 100 of 1000 on the lower left corner of the spreadsheet when sorting data. Can someone tell me where that property is in Excel 2003? Thanks so much! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Total rows when sorting data
You're right I meant filtering. And I do have the status bar showing but not
showing the number of rows when I filter. I will go to the website you suggested. Thanks Gord "Gord Dibben" wrote: I do believe you mean "filtering" rather "sorting" If you don't see a filtered count at lower left you either have the Status Bar disabled or have run up agaisnt one of the problems found at Debra Dalgleish's site. http://www.contextures.on.ca/xlautofilter02.html#Count Gord Dibben MS Excel MVP On Thu, 28 Aug 2008 12:49:01 -0700, 77Debbie77 wrote: Excel 2000 shows the number of rows like this 100 of 1000 on the lower left corner of the spreadsheet when sorting data. Can someone tell me where that property is in Excel 2003? Thanks so much! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting Rows Based on data in one column | Excel Discussion (Misc queries) | |||
Sorting data in rows | Excel Worksheet Functions | |||
Sorting rows of repetitive data | New Users to Excel | |||
sorting rows of data | Excel Discussion (Misc queries) | |||
Sorting data rows independently | Excel Discussion (Misc queries) |