Question

tto see all the rows again after applying filter click _ command​

Answer 1

Answer:

Tips. Remove all the blank or empty rows by right-clicking the row header, and then click "Delete" to bring the data in the lower rows up the worksheet. To clear all the filters from the worksheet, click the "Clear" button in the Sort & Filter group on the Data tab. The rows will restore on the worksheet.