Format Excel Sheet by using right click menu

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,

  1. Use ‘Indicate on Screen’
  2. Navigate to the excel sheet,
  3. Press F2 (this will give you 3 seconds of wait time for selection),
  4. Right click within that 3 seconds,
  5. Move your cursor to the value of the popup and wait for the wait time to get over,
  6. Once over select that value form the popup.

Hope it helps.

Rammohan B.

Thank you! This did it. @Rammohan91

1 Like