How to filter on a marked value in Business Central?
If you want to filter on a specific value, there’s a quick shortcut.
This is what happens in the video
Filtering a list in Business Central to show only the records you need takes just a couple of clicks. If you want to narrow down a list to a specific value, there’s a quick shortcut that saves you from opening the filter pane and typing the value manually.
You can right-click a value in the column header and choose “Filter to This Value”, or you can mark the value and press Alt+F3. Both methods filter the list to the exact value you selected.
How to filter a list to a specific value in Business Central
Imagine you have a list of sales orders and you only want to see the ones with the location code Warehouse1. Instead of building the filter manually, you can let the value you already see on screen do the work.
Mark the value you want to filter on. Right-click in the column header and select “Filter to This Value”. The list is now filtered to show only the records with that exact value.
Using the Alt+F3 keyboard shortcut
There’s an even faster way if you prefer the keyboard. Mark the value and press Alt+F3. This gives you the same result as the right-click menu, filtering the list to the selected value.
Q&A
How do I filter a Business Central list to a specific value?
Mark the value you want to filter on, right-click in the column header and select “Filter to This Value”. The list will then show only the records that match that exact value.
Is there a keyboard shortcut for filtering to a value in Business Central?
Yes. Mark the value and press Alt+F3. This filters the list to the selected value, giving the same result as the “Filter to This Value” option in the right-click menu.