Select multiple cells/ranges
To select multiple cells/ranges:
Go to the
icon, then choose View from the menu dropdown below the sheet tabs. Turn on the Multiple Selection toggle.
This will insert a widget in the editor, using which you can turn on/off multiple selection quickly.
Once the widget is on, you can select the desired cells/ranges and perform the desired action in one go.