Selecting a Range (SHIFT and click in Excel)

[#1]

Hello! First of near a cajillion questions, I reckon.

We have our first dashboard put together, how do I show a business user how to select a range (say, of dates), where in Excel I would have used SHIFT? CTRL is too frustrating to do one at a time.

Thank you,

Kristen

www.vionicshoes.com

[#2 · Accepted solution]

left click using mouse and drag.

[jagan]

Hi,

Just click on a value and drag the mouse to select a series of values.

or Hold Ctrl button and select the multiple required values.

If your field is numeric then enter the range like this  >=1<=10 and press enter, it selects values 1 to 10 in a list box.

Regards,

Jagan.

[#4]

Thank you, both!