Answer Posted / Gaurav Kumar Gupta
To "remove infinite rows" in Excel 2016, go to the Data tab and click on "Filter". Select the column that contains the infinite rows and uncheck the checkbox for "Filter by Color", if it's applied. Then select the entire data range and go to Home > Editing > Clear All. After clearing, go back to Data > Sort & Filter and turn off filtering.n
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Please Help Members By Posting Answers For Below Questions
