Hello,
I am sad to hear that the possibillity of double selecting cels has dissapeared.
I often use that for calculating Sums or Averages in Situations as you see below.
I first select the cels B2:E6, F2:I6, B7:E11, F7:I11 and then over that selection I select B2:J12.
Then I use the Sum (or Average) button and in all the empty cells the Sum Or Average is calculate in the correct way.
This is now impossible. Now I have to do this in steps, as the latest selection B2:J12 deselects the previous selections.
It would be great if it would stil be possible to double select cells.
I must say that in certain situations the new way is handy. But I really miss the old possibillity certainly in sheets that are bigger than this example.
| Januari | Februari | Maart | Kwartaal 1 | April | Mei | Juni | Kwartaal 2 | Totaal |
Marieke | 1 | 0 | 0 | | 0 | 1 | 0 | | |
Chris | 0 | 2 | 3 | | 0 | 0 | 6 | | |
Lucas | 2 | 2 | 2 | | 0 | 0 | 1 | | |
Kathy | 0 | 0 | 0 | | 0 | 0 | 0 | | |
Afdeling 1 | | | | | 0 | 1 | 7 | | |
Rick | 0 | 2 | 0 | | 1 | 0 | 2 | | |
Joost | 0 | 0 | 0 | | 0 | 0 | 0 | | |
Fred | 1 | 0 | 0 | | 1 | 1 | 0 | | |
Paula | 0 | 0 | 0 | | 2 | 1 | 0 | | |
Afdeling 2 | 1 | 2 | 0 | | 4 | 2 | 2 | | |
Totaal | | | | | | | | | |