File has 2300 lines; Filter stops at line 1538.

Hi all!

I am having an issue with a file that was passed down. Filters applied will not affect any values past row 1538. Ctrl+Arrow also stops at line 1538 even though cells are populated throughout the column without blank cells.

Let me know what I should do.

Using Microsoft Excel 2010,

File has 2300 lines; Filter stops at line 1538.

Hi,

In this excel range (A2:A1538) is in table format. other data as normal format. so you can change the table format to normal format by following below steps:

1. Select the range (A2:A1538)
2. Click-Design tab
3. in the tools group click convert to range.
4. then click "Yes"

i hope this will helpful for you.

Regards,
B. Sudhagar