top of page


This function randomly shuffles the order of each row in table.

Consider this table with a normal sequence of rows.

Example Table - before scramble

Once the 'Scramble' button is clicked, the following pop-up appears, warning the user that the function only scrambles values, and that any formulae or links will be deleted.

Example Table - pop-up dialog

The result is a scrambled table where the sequence of rows is now in random order.

Example Table - after scramble
bottom of page