Whether you're assigning random shifts, anonymizing a study, or shuffling a deck, randomizing rows in an Excel table manually ...

Excel's Custom Views tool lets you create a snapshot of your spreadsheet, allowing you to toggle between layouts.

If Excel is not recognizing functions after reboot, change calculation settings, disable Show Formula, run Excel ...