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?
Hallo
Maybe not what you ask for … but why not simply type the obvious keys, eg A1:B20
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.
Try Shift + Arrows.
Asked: 2016-10-25 12:48:44 +0100
Seen: 49 times
Last updated: Oct 25 '16
Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
