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

"afmullane" wrote:


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


--
afmullane
------------------------------------------------------------------------
afmullane's Profile: http://www.excelforum.com/member.php...o&userid=33567
View this thread: http://www.excelforum.com/showthread...hreadid=533495