You can adjust the transparency of heatmap cells using the Opacity mode in the Display settings. By choosing Opacity mode, the base color of the cells remains the same, but their transparency changes according to the data values in each bucket. This helps in differentiating areas of high and low data concentrations more effectively.