How do I remove infinite rows in excel 2016?
- 1 Answers
- 735 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
How do I delete the contents of an active cell?
How do I create a form control in excel 2016?
How do I merge two excel sheets without duplicates?
How do I check if a cell has a value match in excel?
What is chart in ms excel?
How do I calculate 25% of a number in excel?
How do I change the background color in an excel spreadsheet?
What are the two page orientation that you can set in excel?
How do you flip first name and last name in excel?
What is difference between spreadsheet and worksheet?
Is tableau better than excel?
What is format_text in excel?
MS Excel Microsoft 
