Reapply a Filter

Post author:Neale Blackwood
Post published:26/10/2016
Post comments:5 Comments
Reading time:1 min read

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

					
			
				Alphanumeric Sort in Excel 19/05/2026
			
					
			
				Clear Data from an Excel Table 24/03/2026
			
					
			
				Excel and Financial Years and Months 10/03/2026
			
					
			
				When to Avoid Using Colours in Excel 17/02/2026
			
					
			
				Another Blank Cell Issue in Excel 10/02/2026

This Post Has 5 Comments

Sue 23/10/2020 Reply

Thank you 🙂
Nifaadh Alavi 27/11/2020 Reply

This just made my day <3
I was using Alt + H + S + Y all these days….
1. Neale Blackwood 27/11/2020 Reply
  
  Glad it helped.
Rahul Katariya 12/02/2021 Reply

This was working until day before and suddenly stopped working. Any guess to why?
1. Neale Blackwood 12/02/2021 Reply
  
  It is still working for me.
  
  Have you installed a new App they may use the same shortcut?

Leave a Reply Cancel reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.