A
A
Alexander2020-05-13 17:15:29
excel
Alexander, 2020-05-13 17:15:29

Question about selecting cells in Excel?

Hello!
Tell me, what is the difference when we select several cells with the left mouse button, simply dragging over the cell area, and when we "cling" the selected green rectangle to the lower right corner and all the values ​​in the selected cells become the same?
Here is an example -

Example
5ebc00fb0f639285540405.gif

Thanks

Answer the question

In order to leave comments, you need to log in

2 answer(s)
A
AUser0, 2020-05-13
@AUser0

Straight aerobatics trolling. So I can't join.
The first case is cell selection.
The second case is copying from the selected cells to those included in the expanded selection.
And if the second case is done with the SHIFT key pressed, then it will happen sooooooo-o-o-o-oo....

B
BasiC2k, 2020-05-13
@BasiC2k

In the first case, you simply select cells for further actions on them.
In the second case, there is a change in values ​​and formulas according to certain rules.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question