software

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: www.excelforum.com/member.php...oamp;userid=33567
View this thread: www.excelforum.com/showthread...hreadid=533495
Select the cell in the second ro, hold down the shift key and hit end
then down.--
mrice------------------------------------------------------------------------
mrice's Profile: www.excelforum.com/member.php...oamp;userid=10931
View this thread: www.excelforum.com/showthread...hreadid=533495
this dosn't seem to work at all

any more potential solutions would be appreciated,

Aidan Mullane--
afmullane
------------------------------------------------------------------------
afmullane's Profile: www.excelforum.com/member.php...oamp;userid=33567
View this thread: www.excelforum.com/showthread...hreadid=533495Select 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

quot;afmullanequot; wrote:

gt;
gt; Hi guys,
gt;
gt; I am looking to select a column to add a drop down box to all of the
gt; column without adding a drop down box to the row at the top of the
gt; column (the column name). Is there any way of selecting the entire
gt; column without selecting the first row??
gt;
gt; Any help would be greatly appreciated,
gt;
gt; Aidan
gt;
gt;
gt; --
gt; afmullane
gt; ------------------------------------------------------------------------
gt; afmullane's Profile: www.excelforum.com/member.php...oamp;userid=33567
gt; View this thread: www.excelforum.com/showthread...hreadid=533495
gt;
gt;

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.

quot;afmullanequot; wrote:

gt;
gt; this dosn't seem to work at all
gt;
gt; any more potential solutions would be appreciated,
gt;
gt; Aidan Mullane
gt;
gt;
gt; --
gt; afmullane
gt; ------------------------------------------------------------------------
gt; afmullane's Profile: www.excelforum.com/member.php...oamp;userid=33567
gt; View this thread: www.excelforum.com/showthread...hreadid=533495
gt;
gt;