How to generate random numbers with no duplicates in Excel Your email has been sent Over the last few months, I’ve written about several of Excel’s new dynamic array functions. They’re ...

When entering the functions, if you use the selection method to insert references, you will see Excel’s Table structure referencing at work instead of the actual range (array) references that I use.

To insert multiple rows in Excel, first highlight the number of rows you want to add. Then, right-click the selected rows and click Insert in the context menu. You can also add a row in Excel by ...