Ask Your Question

i do not want scroll to select cells

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

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 +0200

LeroyG gravatar image

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


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 +0200

keme gravatar image

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


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 +0200

Seen: 34 times

Last updated: Jun 17 '20