Ask Your Question

Mix rows of a spreadsheet by random or somehow else fast?

asked 2018-04-29 22:13:24 +0200

inJesus gravatar image

updated 2018-04-30 00:27:44 +0200

David gravatar image

How to blend, mingle the filled rows of a spreadsheet?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2018-04-30 00:22:04 +0200

Regina gravatar image

Idea: Add a temporary column, fill it with =rand(). Sort sheet using this column. Delete temporary column. In case your sheet has formulas, you need to check the option "Update references when sorting range of cells." in Tools > Options > Calc > General. Make a backup of the file before trying it.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-04-29 22:13:24 +0200

Seen: 1,922 times

Last updated: Apr 30 '18