Select Column

  • Thread starter Thread starter afmullane
  • Start date Start date
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
 
this dosn't seem to work at all

any more potential solutions would be appreciated,

Aidan Mullane
 
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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop Down Box Selection 3
produce list automatically from choice of drop down list 1
Filtered drop down list 2
Auto-filter selection 1
Keyboard shortcut to select a column? 7
SUMIF with NAME RANGE 1
Excel Excel: How do I put a formula in a drop down list 11
Display index of column headers in column A 9

Back
Top