Forum Discussion
Solved
Filter Reapply Shortcut
Hi, I am new to Excel and am looking for a way to Reapply filters on Excel on my Mac with a keyboard shortcut. I know how to use the menu however I need a quicker solution as I use this to rapidly mo...
Thank you for the replies.
I am using Excel 365, I have a spreadsheet with 460 user records, I have a data entry box above the main table and input the name I want to find and use OR filter in a column in the table to find the Member No. or Name I entered which returns TRUE or FALSE for each record, which I then filter to show "True". I need to filter in the main table as I enter data to complete the checkin. However, when I enter the next name or Membership number the column values change it does not change the record until I reapply the filter.
I am looking for a quick method to do the refresh so I don't hold up people in the check-in queue.
Ross1953 In My English Excel for Windows it is alt+a, y. Perhaps it is similar for Mac? There should be a key like command you can press and then the short-cut characters for the ribbon should appear.
- Thank you for replying. Mac's don't have an alt key, I tried to find the key combination but can't find anything on the internet.
- Looks like what I was talking about does not exist on a Mac: https://answers.microsoft.com/en-us/msoffice/forum/all/excel-ribbon-shortcut-in-mac/ac572c7c-6b31-4a5b-b368-d77a09f84eb8
Perhaps you should try placing the Reapply filter button on your Quick Access toolbar?