knjl
(Kenneth)
November 18, 2020, 8:09am
1
I’m trying to copy and insert copied cells by using only Type Into. More than a single row.
Using Shift+Space to select the entire row, while holding “Shift+Space”, I’ll need to "k(down)’ as well since I’m copying multiple rows.
AND
Inserting the copied cells using Ctrl+Shift+“=”.
1 Like
Hey @knjl ,
Use type into and pass your key combination.
Make sure u keep the simulate type as false.
You can follow the same for other combinations as well.
Thanks
1 Like
knjl
(Kenneth)
November 18, 2020, 9:13am
3
Hi Nithin, it still doesn’t work. Because I need to hold Shift and Space together then press down to select multiple rows.
J0ska
November 18, 2020, 9:57am
4
To press and hold shift use “[d(shift)]”,
To release shift use “[u(shift)]”
Cheers
1 Like
knjl
(Kenneth)
November 19, 2020, 1:13am
5
Hi Joska, understand how that works for let’s say saving, we will do as “[d(ctrl)]s[u(ctrl)]”. But what I’m trying here is to hold both the shift and space and press down twice then release both the shift and space.
1 Like
@knjl - I tried your keystrokes in “Keyboard Shortcuts” → Record Multiple Shortcuts…Please see the below shortcuts system created on the right…
knjl
(Kenneth)
November 19, 2020, 8:03am
7
Hi Prasath, I don’t have “Keyboard Shortcuts” on mine to enter from. Probably different version but thanks!
Hey @knjl ,
Adding to @prasath17
You can try [d(shift)] [d(space)] [k(down)] [k(down)] [u(shift)] [u(space)]
Hope this helps.
Thanks
J0ska
November 19, 2020, 8:14am
9
You are not the first one who wants hold “space” but it seems not possible
Yes that’s right. I’ve tried the d and u modifiers but didn’t work. It did work well with ctrl.
Recently what I had to do is to hold space or pagedown, so to load a long list of elements inside a web, but neither of them worked with this u and d thing. I ended up using ctrl+home and ctrl+end several times to achieve this. I think it would have been easier to just hold space or pagedown, but I couldn’t make it work.
Thanks for your answer. Cheers.
The following sequence will hold shift, press space, press 3x down and release shift. Not sure if it helps…
"[d(shift)] [k(down)][k(down)][k(down)][u(shift)]"
Cheers
knjl
(Kenneth)
November 19, 2020, 8:29am
10
Unfortunately it is still not working… Thanks Joska
prasath17
(Guru)
November 19, 2020, 1:21pm
11
@knjl - I didn’t ask you to try Keyboard shortcuts…you can manually try what system has provided by looking at my screenshot…
Please show us what you have tried so far? I.e show your code
J0ska
November 19, 2020, 3:29pm
12
This applies to “Modern” activities and is not applicable to “Traditional” activities.
Cheers
prasath17
(Guru)
November 19, 2020, 6:38pm
13
@knjl - Here you go… I was able to solve this…
The keystrokes are " Shift+Space – Shift + Down – Shift + Down – Ctrl +C
Again I have tried this in Keyboard shortcuts…You can try this manually in sendhotkey…
Output
1 Like
knjl
(Kenneth)
November 20, 2020, 6:59am
14
Hi thanks all. I’ve manage to solve it with the help of all of you and while playing around with it, Solution is as shown.
system
(system)
Closed
November 23, 2020, 6:59am
15
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.