Select Column
 

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

Select Column
 

Select the cell in the second ro, hold down the shift key and hit end
then down.


--
mrice


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

Select Column
 

this dosn't seem to work at all

any more potential solutions would be appreciated,

Aidan Mullane


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

Select Column
 

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

Select Column
 

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.

"afmullane" wrote:


this dosn't seem to work at all

any more potential solutions would be appreciated,

Aidan Mullane


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