Ask Your Question

# Revision history [back]

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.