Down Arrow will probably be easier since you just pressed Down Arrow to open the filter menu.

You can use either the Down Arrow or Tab keys. So the full keyboard shortcut is: Alt+Down Arrow, E, Tab (or Down Arrow) If you want to jump down to the checkbox list below the Search box, you can just press Tab after Alt+Down Arrow, E. What a time saver! Bonus – Jump to the Checkbox List Now I can do the same thing in one step by pressing the letter “E”. This required me to press the down arrow key 7 times to get to the search box. Prior to learning this I was using the down arrow key to get to the search box.

I just learned this shortcut and it is my new favorite because it makes it so fast to type and filter exactly what you are looking for in the list. This places the cursor in the search box and you can begin typing your search.Īlt+Down+Arrow+E is the shortcut to open the filter drop down menu and jump directly to the search box. Now the filter is applied to every worksheet and as those are quite different the resulting XML is garbage.Ĭan I specify which worksheet to apply the filter to when exporting? Like by using the name or the order position of the sheet?Īs you can see there is also a second worksheet which I want to apply another XSLT filter to.When the filter drop down menu is open, you can press the letter “E” on the keyboard to jump to the search box. I based my filter on the second answer in this SO question and it worked fine until I added another Worksheet to the Calc file.

I'm using XSLT export filter to extract part of my OpenOffice Calc file into an XML file.

Filter openoffice calc