Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rows not being displayed
I'm using Excel 2007 and have defined a range A6 : AP1476 to be autofiltered.
I know there is a value of 0 in one row and I can't get it to display with autofilter. It's in row I'm unable to view anything below row 1019. I can't even sort the data below 1019. Can someone direct me to a fix for this? I can see through a search that I have data in A1473 to A1476 with zeros, but can't get to it through autofilter. Thanks for any assistance, Barb Reinhardt |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rows not being displayed
Somewhere on that ribbon (View tab|Window Group), there's a freeze panes icon.
Make sure your panes aren't frozen. Then scroll up. Barb Reinhardt wrote: I'm using Excel 2007 and have defined a range A6 : AP1476 to be autofiltered. I know there is a value of 0 in one row and I can't get it to display with autofilter. It's in row I'm unable to view anything below row 1019. I can't even sort the data below 1019. Can someone direct me to a fix for this? I can see through a search that I have data in A1473 to A1476 with zeros, but can't get to it through autofilter. Thanks for any assistance, Barb Reinhardt -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table - Controlling how many rows of data are displayed in t | Excel Discussion (Misc queries) | |||
How do I lock the top 2 rows (headings) so that they are always displayed when moving around the spreadsheet? | Excel Discussion (Misc queries) | |||
How do I limit the number of rows displayed on a worksheet? | Excel Discussion (Misc queries) | |||
How do I reduce number of Rows displayed in Excel worksheet? | Setting up and Configuration of Excel | |||
Number of rows displayed in worksheet | Excel Discussion (Misc queries) |