​@Etaveras I have no idea why your CTRL+D wouldn’t be working. 

What about using the Excel Advanced: Set Cell Formula action instead?

What about writing a macro in Excel?

There are plenty of ways to do this so don’t get stuck on one thing that’s not working as expected.

Hello Mr. Aaron.

Here is an example of the code. I want to apply the Excel shortcut Control + D, but in AAW.

When executing, the formula is not applied to the other cells as it would be if I used the control + d command on the keyboard. 

Below is an image of what I would expect the bot to do when executing “iCTRL DOWN]d CTRL UP]” once I select the range of records with “dSHIFT DOWN]SCTRL DOWN][DOWN-ARROW].”

Hi Aaron.

I found the solution using an Excel macro:

1. Select a default length.
2. Start recording a macro.
3. In the recording, just press Ctrl + D.
4. Stop recording.
5. Save the macro.

I included the advanced Excel action “Run Macro” and entered the name. At this point, I validated it and everything works as expected and quickly.

In another context, I was unable to make this work with the keystroke action, which was my initial desire. :(

Make sure that you are using the small case d in your key combination. Also, it is better to add a Window→ Activate action just before the Simulate Keystrokes to move the focus on to your Excel file.

By the way, I have verified the same from my end and the short key is working for me through Keystrokes action.

Good morning, Mr. Padmakumar.

Although the approach I took allowed me to achieve the goal, it left me wondering if there was another way, since the keystroke wasn't working for me. I'm referring to “�CTRL DOWN]dNCTRL UP]”.

So I proceeded to validate with only one cell, and it worked. So I turned off this keystroke:

The next thing I did was use the action “cExcel advanced: Select cells/rows/columns],” and I see that it worked without any problems.

So I checked what the keystroke “ SHIFT DOWN]�CTRL DOWN]WDOWN-ARROW]” does in Excel, which visually selects the entire column from one point x to another point x.

What I noticed when executing that keystroke is that it simulated pressing ctrl + shift + left click, and when it was in that mode, it didn't allow me to perform another keystroke.

I am grateful to everyone involved, as they allowed me to arrive at an even simpler solution and not close my mind to the fact that, even though it worked for me using a macro, it was the most suitable one.

In this way, the task that used to take more than 2 hours I was now able to complete in 6 minutes. :)