N
N
N24582020-06-24 00:57:35
excel
N2458, 2020-06-24 00:57:35

Is it possible to select an absolute range with the mouse?

Is it possible to select a range of cells with absolute addressing when writing a formula?

In other words, when writing a formula СУММand selecting a range with the mouse, it turns out like this: =СУММ(А1:А20). And I would like this =СУММ($А$1:$А$20):

Answer the question

In order to leave comments, you need to log in

1 answer(s)
J
John Smith, 2020-06-24
@N2458

selected a range, pressed F4 - got an absolute range.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question