excel automatically selecting multiple cells

In the «Name» field (which is located to the left of the formula row), you need to set the range of cells: B3:D12345 (or B3:D12345) and press «Enter».

Thus, you easily captured the huge range, in just a couple of clicks. In the window that appears, in the «Link» field enter the address: B3:D12345 (or B3:D12345) and click OK.

How to allocate a large range of cells in Excel? Press the key F5 or CTRL + G.

To return to normal operation, press the F8 again.

As you can see, in this mode, we have the ability to allocate several rhinestones. And now select the block F2:K5 with the mouse. A message appears in the status bar: «Extend the selection». Press the F8 key to activate the special mode.

How to allocate non-contiguous range of cells in Excel? Select the block B3:D8 with the mouse.

Thus, we have identified a block of the D3:G7 range. Now, still not releasing SHIFT, press the «down arrow» key four times until the cursor goes to G7. Click on the cell D3, and now holding SHIFT, press the right arrow key three times until the cursor moves to the cell G3.

You can select the ranges using the arrow keys on the keyboard.

This allocation operation can be conditionally written: A1 then SHIFT + B3. Click on the cell A1 now, then press and hold on the keyboard SHIFT, and after that click on the cell B3.But try to select block B3:D12345 in this way. It would seem that there is nothing simpler and this is enough for practical knowledge. To select a range, for example A1:B3, you must hover the mouse cursor over the cell A1 and hold the left mouse button to place the cursor on the cell B3.

when creating charts and diagrams, etc.

The working with the selected ranges of MS Excel cellsĪllocation of ranges is one of the basic operations when working with Excel.

Excel automatically selecting multiple cells