Home » Forums » Open Source Learning Center » Question and Answer

File has 2300 lines; Filter stops at line 1538.

Submitted by rbalboa829 on 24 May, 2017 - 20:40

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,

‹ how do i do something like this macro to put duplicated data in rows into columns and then remove duplicates ›
»

File has 2300 lines; Filter stops at line 1538.

Submitted by Sudhagar on 27 May, 2017 - 02:03.

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

»