https://bugs.documentfoundation.org/show_bug.cgi?id=158288
--- Comment #18 from ady <adylo811...@gmail.com> --- (In reply to Eyal Rozenberg from comment #14) > (In reply to ady from comment #13) > No. Ctrl is for a disjoint selection. When you want to select a contiguous > sequence of cells, you use the Shift key. I didn't want to get into the detailed steps; I assumed the intention of my words would be understood. 1. Click on a cell and drag the mouse to select an area. 2. Release the mouse button. The area is selected. 3. Press the [CTRL] key and repeat the mouse operation on another range of cells; they can be adjacent to the previously-selected area or not. Without pressing the [CTRL] key, the prior area would no longer remain selected. Again, the specific original problem of selecting A1:A4 is _solved_ by means of the Name Box. As for the L shape, I don't recall ever working like that with the keyboard, nor with the mouse, on any spreadsheet tool. As for the behavior when there are (partial) merged cells, my experience has always been like it is ATM on every spreadsheet tool I have used; and I have taken advantage of this behavior too. But maybe I am getting too old to remember. -- You are receiving this mail because: You are on the CC list for the bug.