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.
