How to use Excel array functions

How to use Excel array functions

First select the table cell to be filled with data;

Then enter in the function "={}", the data between rows are separated by ",", and the data between columns are separated by ";";

Finally Press and hold [Ctrl] [Shift] [Enter] to fill the cells.

Recommended tutorial: "PHP Tutorial"

The above is the detailed content of How to use Excel array functions. For more information, please follow other related articles on the PHP Chinese website!