Question: how to calculate all possible combinations in excel?
Answer: Step 1: Open the sheet. You first need to open the sheet with data from which you want to make all possible combinations. ... 
Step 2: Select cell for result. You now need to select a cell where you want to have the result of possible combinations to appear. ... 
Step 3: Drag the formula to other cells.