what is function of auto filter command in excel
Answers
Answer: is a basic that allows you to view specific rows in an Excel spreadsheet, while hiding the other rows.
hope i help
Answer:
What is microsoft excel :
Microsoft excel is nothing but a spreadsheet where we can store data, do calculations, and many more. It can be used to create charts and for editing purposes also. It has many formulas like sum , average........etc. It is generally in the form of spreadsheet. the most latest and new version of microsoft excel is "microsoft excel 2019".
Steps to open microsoft excel:
Step 1: Go to the start button and search for microsoft excel.
Step 2: there you will find an app with a green logo and open it aqnd hence your MS excel document is opened.
Function of auto filter command:
Autofilter command is used to show some rows in a excel sheet whereas the other rows will be hidden.
Steps for doing auto filter:
- Select the data which should not be hidden and then go to filter.
- Choose the boxes then and then after executing it your autofilter command has worked