Скачать или смотреть How to insert filters to data - Microsft excel

“In this video, we’ll learn how to insert filters in Microsoft Excel — a quick way to sort and analyze your data.”

Why Use Filters

“Filters let you quickly show only the data you need — like specific dates, amounts, or names — while hiding the rest.”

Method 1: Using the Ribbon

“First, click on any cell inside your data range.”

“Now go to the top and click on the Data tab in the Ribbon.”

“Then click on the icon labeled Filter — it looks like a small funnel.”

7“Filter arrows will now appear on each header in your table.”

Method 2: Using Shortcut Key

8“Want to go faster? Just press Control + Shift + L on your keyboard.”

“That’s the shortcut to instantly add or remove filters from your data range.”

now lets see How Filters Work

1“Click the filter arrow next to a column header — and you’ll see options to sort data, search for specific values, or filter by condition.”

“You can even filter by color if you’ve used conditional formatting or manually applied colors.”