Ask Your Question

How to select area for functions with keyboard

asked 2016-10-25 12:48:44 +0100

Joysn gravatar image

When i create formulas with the formula wizard, i can or need to select areas where the formula applies. Like for SUM(ref1:ref2) where ref1 is one cell reference and ref2 is the second cell reference. Selecting with the mouse is supported, but how can i select that area with the keyboard only?

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2016-10-25 13:19:12 +0100

karolus gravatar image


Maybe not what you ask for … but why not simply type the obvious keys, eg A1:B20

edit flag offensive delete link more


Sometimes the tables are rather big, and to find out the cell address of the table requires to scroll / move there first, and then move back to type in the cells address. But yes, it is possible like this, select the area first, then copy the address from the field located on the top left corner, and then paste the address into the formula field in the dialog.

Joysn gravatar imageJoysn ( 2016-10-25 14:10:02 +0100 )edit

answered 2016-10-25 13:29:29 +0100

gabix gravatar image

Try Shift + Arrows.

edit flag offensive delete link more


This keys are not active from Functionwizard.

karolus gravatar imagekarolus ( 2016-10-25 13:34:07 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-10-25 12:48:44 +0100

Seen: 49 times

Last updated: Oct 25 '16