How to generate random text using the RANDARRAY ... or remove the content that’s in the way. When you select any cell in a spill range, Excel highlights the entire range with a blue border.

Generating random lists of numbers in Excel is handy ... it will be quicker to select the whole column instead. Then, in the Data tab, click "Remove Duplicates." Next, make sure the details ...