Reapply a Filter

Let’s say you have applied a filter to a list.

The list is dynamic and the values have been updated by a refresh – the filter is out of date.

You don’t have to go into the filter drop down to re-apply the filter.

You can use a keyboard shortcut whilst in any cell in the table.

Ctrl + Alt + L


Related Posts

					
			
				Excel Has Ordinals 18/07/2023
			
					
			
				Formatted Table – Change Default Colour 01/09/2022
			
					
			
				Power Query Zoom 15/09/2021
			
					
			
				Open the Power Query Editor 28/04/2021
			
					
			
				Pivot Table Shortcuts 09/04/2021

Please note: I reserve the right to delete comments that are offensive or off-topic.

5 thoughts on “Reapply a Filter”

Sue says:

23/10/2020 at 11:15 pm

Thank you 🙂

Reply
Nifaadh Alavi says:

27/11/2020 at 4:35 pm

This just made my day <3
I was using Alt + H + S + Y all these days….

Reply
- Neale Blackwood says:
  
  27/11/2020 at 4:51 pm
  
  Glad it helped.
  
  Reply
Rahul Katariya says:

12/02/2021 at 3:28 pm

This was working until day before and suddenly stopped working. Any guess to why?

Reply
- Neale Blackwood says:
  
  12/02/2021 at 3:39 pm
  
  It is still working for me.
  
  Have you installed a new App they may use the same shortcut?
  
  Reply

A4 Accounting

Helping you Excel Yourself with spreadsheets

Reapply a Filter

Related Posts

Leave a Reply Cancel reply

5 thoughts on “Reapply a Filter”