Ask Your Question

i do not want scroll to select cells

asked 2020-06-12 17:34:49 +0100

max2 gravatar image

I do not want to scroll to select cells in LibreOffice. What shall I enter into a cell to select cells from A:42 to A:102 say ?

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2020-06-12 18:21:16 +0100

LeroyG gravatar image

updated 2020-06-17 16:29:54 +0100


If you are writing or editing a formula in a cell (or in the Imput line), just type A42:A102; otherwise pulse in the Name Box (also named Sheet Area Imput Field), type A42:A102, and press Enter.

Name Box and Imput line

EDIT: Name Box is also named Sheet Area Imput Field. To access the Name Box you could press Ctrl+Shift+T.

You could edit your question, or comment an answer. Do not use Answer to comment.

Mark the circle to the left of the answer that solved your question.

edit flag offensive delete link more

answered 2020-06-12 17:46:56 +0100

keme gravatar image

updated 2020-06-12 17:47:57 +0100


Generally, a range address is given by the adresses of two opposite corners, separated by a colon.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-06-12 17:34:49 +0100

Seen: 29 times

Last updated: Jun 17