Many Excel users are often required to use array formulas, below note will help to understand how to :-
a) Create an Array formula
b) Convert an existing formula to an Array formula
The keyboard shortcut to apply Array functionality to a formula is :-
Ctrl + Shift + Enter
If you have already entered the formula and now wish to convert the same into an array formula,
Just select the cell, press F2 and press key combination Ctrl + Shift + Enter.
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.
Creating a shortcut key using Array is interesting to do. Excellent info you discussed. But there is a problem with a printer, when I try a shortcut key to print it doesn't work properly. So I research and with this canon printer error 5200 I solve this problem.
There are some features that the users have to know and one of them is the shortcuts for applying the array functionality. There are some array application users who are not aware of this and they can use the keyboard shortcuts in their work.