0

I have a small problem. I have an excel file where I simply want to add a filter to all my columns. Firstly I don’t want to put a certain condition into the filter but just the option to filter with the toolbar with the small arrow.

Can anybody help me out?

kwoxer
  • 3,734
  • 4
  • 40
  • 70
SiemCode
  • 11
  • Not sure what you want? More info and images needed. – kwoxer Sep 29 '20 at 13:48
  • The concern is that when you go to one cell and type ctrl+shift+L. That should create a filter on-top of the datatable within Excel. That is what I want to automate. I solved it by adding the click activity 3 times but I think that solution is not really elegant. Maybe there is a better way. – SiemCode Sep 30 '20 at 09:14

1 Answers1

1

You could use the Send Hotkey activity to send "ctrl+Shift+L" enter image description here

Yunnosch
  • 26,130
  • 9
  • 42
  • 54
Schpenn
  • 108
  • 1
  • 11