Select Column

A

afmullane

Hi guys,

I am looking to select a column to add a drop down box to all of the
column without adding a drop down box to the row at the top of the
column (the column name). Is there any way of selecting the entire
column without selecting the first row??

Any help would be greatly appreciated,

Aidan
 
A

afmullane

this dosn't seem to work at all

any more potential solutions would be appreciated,

Aidan Mullane
 
E

Elkar

Select the cell in row 2 of your column.

Then hit CTRL-SHIFT-DOWN

You may need to hit the down arrow a few times, depending upon how many
breaks in your data there are.

HTH,
Elkar
 
E

Elkar

What version of Excel are you using? Both of these solutions work on my
Excel 2003. I don't currently have access to an older version to test.
 
Top