Hello,
I just filtered data and I need it to remain filtered but can I do so and get rid of the filter arrows? I can't have it pasting into word with them on.
Thanks.
Hello,
I just filtered data and I need it to remain filtered but can I do so and get rid of the filter arrows? I can't have it pasting into word with them on.
Thanks.
The arrows won't paste into word, you don't have to worry about that.
As a picture metafile they still do
Hi,
If you are using a Table, you can turn off the display of the filter button on the Design tab for the table. If not, you could use an advanced filter instead, or use code to hide the dropdowns.
Don
Please remember to mark your thread 'Solved' when appropriate.
Hi
Create a column at the end of your table and link to the column that you want to filter. Then apply filter to that column only.
EG Columns A to C has your table and you want to filter on column B then
create column in D that link to Column B. Then apply filter to Column D only.
Untitled.jpg
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks