Ask Your Question

how to select entire column while using vlookup function in calc [closed]

asked 2013-06-24 07:30:40 +0200

mlimaye gravatar image

updated 2014-10-15 18:21:17 +0200

ratrace gravatar image

While using the V Look up function in calc, how do I select the entire column. I tried but in calc you have to drag down, but it is very difficult to do so in column having large no of lines.

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-11-02 21:59:18.429036

2 Answers

Sort by » oldest newest most voted

answered 2013-06-25 06:17:32 +0200

ROSt52 gravatar image

What @oweng describes works also in Windows.

Additional trick when using vlookup formulas and you need to select a long part of an empty column. Click into to top or bottom cell of the empty column, keep ctrl pressed and go the filled in neighbor row. Use @oweng's ctrl+shift+ down or up arrow, and move back to the empty column. Result the empty colum is selected over the same length as the neighboring columns. This works in Windows. Other, just try.

edit flag offensive delete link more

answered 2013-06-25 03:42:08 +0200

oweng gravatar image

Under GNU/Linux you can use CTRL+SHIFT+DOWNARROW to select a contiguous range of values. Alternatively you can name the range and use the name in the VLOOKUP() function. Highlight your range and then Insert > Names > Define...

edit flag offensive delete link more

Question Tools


Asked: 2013-06-24 07:30:40 +0200

Seen: 4,692 times

Last updated: Jun 25 '13