To select multiple cells/ranges:
1. Place the selection on one of the desired cell/range.
2. Press Cmd (Ctrl for Windows) and select the other desired cells/ranges.
Multi-selection can be used to apply formats to discontinuous ranges simultaneously, select source ranges for charts, etc.
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.