What would be the line of code if I just want to move the active cell to the right cell? Just one column to the right of the active cell? Please help... Expecting your reply! 🙂
In MS Excel, you can select a row, then hover over until the cursor turns into a hand and then drag the selected row into a new place. If you press shift while doing this, it allows you to place the selected row in between two other rows. Google Sheets seems not to do this, unless you know one way to do it.
YOU EXPLAINED THAT IN A VERY CLARE WAY. GOOD TEACHER. LOVE YOU.
Thank you for explaining so clearly.
👍
Nicely explained. thank you
Thank you so much for this! Great help!!! 👍🏻👍🏻
Glad it helped!
This was excellent. Thank you.
There a way to get cell value automatic to a specific cell ?
What would be the line of code if I just want to move the active cell to the right cell? Just one column to the right of the active cell? Please help... Expecting your reply! 🙂
activecell.offset(0,1).select
@@ExcelGoogleSheets Thank you so much! You are a life saver :)
Could you please put this series in a single playlist so we can follow and refer to in case we need them. Thank you.
th-cam.com/play/PLv9Pf9aNgemseHLvmD_GNgUiuH92y1bgU.html
Why selection(1,2) is same as selectionoffset(0,1)?
In regards to another subject inside Google Sheets, how can I drag and drop cells or rows IN BETWEEN other cells or rows in Google Sheets?
I'm not exactly sure what you're trying to do. Are you asking how to do this with a script or just in Sheets? How do you define "in between"?
In MS Excel, you can select a row, then hover over until the cursor turns into a hand and then drag the selected row into a new place. If you press shift while doing this, it allows you to place the selected row in between two other rows. Google Sheets seems not to do this, unless you know one way to do it.