Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

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.