Ancestors

Toot

Written by Jamie Teh on 2025-01-09 at 05:44

Is there seriously no way to move a row up or down in Google Sheets with the keyboard? I'd even accept a menu command (reachable either via the menu bar or with the alt+/ menu search), but I can't even find that. Please tell me I'm missing something? #accessibility

=> More informations about this toot | More toots from jcsteh@aus.social

Descendants

Written by Peter Saathoff-Harshfield on 2025-01-09 at 07:04

@jcsteh Select the row with shift + space. Then, in the edit menu there’s a “Move” submenu that contains “Row up” and “Row down”.

=> More informations about this toot | More toots from pesh@mastodon.social

Written by Jamie Teh on 2025-01-09 at 07:22

@pesh Thanks. I didn't know about shift+space. Unfortunately, however, even after pressing that, my Edit menu doesn't contain a Move item. There is Delete, but no Move. I don't understand why.

=> More informations about this toot | More toots from jcsteh@aus.social

Written by Peter Saathoff-Harshfield on 2025-01-09 at 07:24

@jcsteh Hmm, that item is disabled until you’ve selected a whole row or column.

=> More informations about this toot | More toots from pesh@mastodon.social

Written by Jamie Teh on 2025-01-09 at 07:25

@pesh Right. But shift+space does select the whole row, and yet I still don't get the move item. It's strange... and annoying.

=> More informations about this toot | More toots from jcsteh@aus.social

Written by Peter Saathoff-Harshfield on 2025-01-09 at 09:36

@jcsteh That sucks. I’m’ sorry, but I can’t think of what could be happening.

=> More informations about this toot | More toots from pesh@mastodon.social

Written by Jamie Teh on 2025-01-09 at 10:11

@pesh I appreciate the help anyway. It at least tells me that the Edit -> Move menu is supposed to be there and just isn't for some reason in this situation. That's more than I knew before, so thank you.

=> More informations about this toot | More toots from jcsteh@aus.social

Written by Jamie Teh on 2025-01-10 at 01:13

@pesh Turns out you need to press shift+space twice to select all the cells in the row and then the row itself. https://icosahedron.website/@JoshGrams/113798362474991162

=> More informations about this toot | More toots from jcsteh@aus.social

Written by Peter Saathoff-Harshfield on 2025-01-13 at 22:12

@jcsteh Ah. I didn’t quite get this for a few days, but I just realized I had only been trying this on a row that only had one cell with any content in it.

=> More informations about this toot | More toots from pesh@mastodon.social

Written by Josh Grams on 2025-01-09 at 12:20

@jcsteh Oof, that's bad. I poked around for a while and it looks like you can Shift+Space twice to select the whole row (once selects all cells in the row with content, twice selects the row itself) and then Alt+Shift+E for the edit menu, M for move, then J for move row down or K for move row up.

=> More informations about this toot | More toots from JoshGrams@icosahedron.website

Written by Jamie Teh on 2025-01-09 at 21:53

@JoshGrams Thank you. Someone else pointed out shift+space and the Move menu, but the missing piece was that you have to press shift+space twice.

=> More informations about this toot | More toots from jcsteh@aus.social

Written by Tamas G on 2025-01-09 at 12:55

@jcsteh probably not, but I hope you have an answer as this could come in handy for my work too. Just like when I discovered that to do a dropdown chip in Docs, you gotta shift+right arrow the object (highlight it) to get the dropdown options to be arrowable. Still can't check checkboxes in to-do list via keyboard though, either. Of course, when it comes to telling you that you can now use Gemini to summarize cells, they don't miss a beat with the announcing, which I just find ironic.

=> More informations about this toot | More toots from Tamasg@mindly.social

Written by Jamie Teh on 2025-01-10 at 01:13

@Tamasg In case you didn't see this, https://icosahedron.website/@JoshGrams/113798362474991162

=> More informations about this toot | More toots from jcsteh@aus.social