Select the cells containing the data
Click an empty cell where you want the result
Enter `=MAX(A1:A10)-MIN(A1:A10)`
Replace `A1:A10` with your actual cell range
Press Enter
Use the same formula for any other data range by changing the cell references