Select a menu item in excel ribbon

(0) Share

Report

Posted on by jb0100

Hello

Im trying to select items in the menu using keystrokes, for example, sort which is alt-d-s.

I just cannot do this, i have tried sending keys but I only got "alt" to work (by selecting the file in title ond/or class and using {alt}) and display the letter to press in order to select a menu from the ribbon, but when I "press" the letter in PAD, it writes down the letter in a cell instead of selecting a menu.

Also, playback is too slow, any ideas on how to speed it up?

Thanks!

Categories:

Power Automate Desktop

All responses (3)

Answers (1)

Sort by

VJR 7,635 on at

Like
a
(1)

Report
Copy link

Link copied!

{Alt}({D})(S) works but you need to have the rows of data selected before running this command and also the right window should have the focus.
jb0100 15 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello

Found that {alt}ds worked just fine... I do need to have the range selected beforehand.

Thanks!
Verified answer

VJR 7,635 on at

Like
a
(1)

Report
Copy link

Link copied!

Keep in mind PAD recommends to have the alphabet within a circular brace in such cases. Therefore I have suggested {Alt}({D}).