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.
Are you aware of the FILTER function? Could it come in handy? (Does require Excel 2021 or subscription to Microsoft 365; does work on Macs)
It's hard to say at a distance because you haven't fully described the nature of those check-in records, and what you're using FILTER them. Is it possible for you to post a mock-up or facsimile (no real names) so we could take a look at your actual layout? Post it on OneDrive or GoogleDrive with a pin here that grants access.
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.
