The Random Generator app for Excel populates the selected cells with random integers, reals, and dates. Use the app to generate data of different types:
Select the type of data you need, enter the minimum and maximum numbers or dates, and click “Generate”, - that’s all you need to do.
Please note that any formulas in your range will be overwritten with values. You can cancel the process to keep them, or continue to get random values in the selected cells.