Seclecting row or column in excel by using keystrokes

[ravi338]

Hello,

I want to select a column (in Excel) by entering a keystroke ([CTRL DOWN]spacebar[CTRL UP]).
Apparently this is not working.

I tried different ways of entering keystroke ([CTRL DOWN]SPACE[CTRL UP]).

Can someone suggest me how to do this.

 

[VJR]

Hi ravi338,

[CTRL DOWN][ ][CTRL UP]
This will work. Notice that there is a single space within the middle square brackets.

 

[ravi338]

Thanks VJR

 

[VJR]

Thanks VJR

Hi ravi338, did the keystroke sequence work in selecting the Excel column?

 

[ravi338]

Hello VJR,

Error is coming "No cells are found", when i apply [CTRL DOWN][ ][CTRL UP].

I would like to select a filter for a particular column, for this i have used shift ctrl L ([ctrldwn][shiftdwn]l[ctrlup][shiftup).
This is selecting entire row of a excel. This is ok for me.

Here my question is how to deal with filters in excel by using AA.

Like i want to select a name by using excel filter each time.

Thanks VJR