| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I want to select every other column | Excel Discussion (Misc queries) | |||
| Conditional Format as a MACRO | Excel Worksheet Functions | |||
| how can i multiply two columns | Excel Worksheet Functions | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Hybrid Mode
