Move a row in Google Sheets

preview_player
Показать описание
Move a row in Google Sheets.



#HowToGoogleSheets
#GoogleWorkspaceHowTo
Рекомендации по теме
Комментарии
Автор

I was looking at how to move multiple rows at once and turns out selecting the required rows and then clicking the blue box with bold outline and moving it around can move multiple rows like shown in the video for one row.

llliiilll
Автор

How do I in another scenario, after ticking a check box (Example row 20) then it will proceed to move up to row 2?

The scenario is that I will have lets say 30 row of random data, and a check box on each row, after I check, it will rearrange to the top.

So if I check row 20 now, it goes to row 2, I check row 15, it goes to row 3, I check row 21, it goes to row 4 and so forth?

Cause I want to keep track in order the task I did after checking everything.

xlostlovex
Автор

My issue is that sometimes when I move a row, it messes up the sheet somehow. I cant move a row before row 2 as the formulas start at 2, so I know that, but seems like anywhere else it gets messed up and some functions stop working.

mstinamichele
Автор

i dont want to move entire row only inside row how do i do it! in excel its simply done by holding shift key but how do i do it in sheets!??

zacky