Filter data in Excel Sheet in Excel

Advertisements

Prev Tutorial Next Tutorial

How to Filter data in Excel Sheet in Excel

If your worksheet contains a lot of content, it can be difficult to find information quickly. Filters can be used to narrow down the data in your worksheet, allowing you to view only the information you need.

Normal Filter Excel Sheet Data

  • Select the Data Tab, then click the Filter command.
  • A drop-down arrow The drop-down arrow will appear in the header cell for each column.
  • Click the drop-down arrow for the column you want to filter. In below example, we will filter column D to view only HR department data.
  • The Filter menu will appear.
  • Uncheck the Box next to Select All to quickly deselect all data.
  • Check the boxes next to the data you want to filter, then click OK
filter data in excel sheet filter data in excel sheet filter data in excel sheet

Clear Filter

To clear filter select the Data tab, then again click on selected Filter command.

Download Sheet for Practice

Employee Details Sheet


Prev Tutorial Next Tutorial

Google Advertisment

Buy This Ad Space @$20 per Month, Ad Size 600X200 Contact on: hitesh.xc@gmail.com or 9999595223

Magenet is best Adsense Alternative here we earn $2 for single link, Here we get links ads. Magenet


For Projects 9999595223

Google Advertisements


Buy Websites 9999595223

Buy College Projects with Documentation Contact on whatsapp 9999595223. Contact on: hitesh.xc@gmail.com or 9999595223 Try this Keyword C++ Programs

Advertisements