I want to automate the formatting within Excel. How do I capture right click menu and select an item from there, such as “Format Cell”?

You can change ‘MouseButton’ property of Click Activity to ‘BTN_RIGHT’ to perform right click. To select the Value from the Popup list, Use ‘Indicate on Screen’ Navigate to the excel sheet, Press F2 (this will give you 3 seconds of wait time for selection), Right click within that 3 seconds, Move…

Format Excel Sheet by using right click menu

Learning Hub Academy Feedback

ruei September 12, 2018, 5:49pm 3

Thank you! This did it. @Rammohan91

1 Like

Topic		Replies	Views
Excel 任意のセルを右クリックできますか？フォーラム studio	4	7448	August 13, 2018
Click cell in excel file Help excel , activities , studio	7	9624	December 30, 2022
Can't select Excel cell menu option after menu popup Help	2	1678	July 25, 2018
Click A column n excel Help	4	796	October 24, 2019
Excelで右クリックして出てきたメニューを取得したい Studio excel , studio , question	7	3447	March 16, 2021

Format Excel Sheet by using right click menu

Related topics