Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Tim Tim is offline
external usenet poster
 
Posts: 408
Default increase number of items shown in drop down list?

I am running Windows XP and dont have your problem. When I opened an excel
2003 file in excel 2007 I found that it takes longer to open the file without
having Excel 2007 already running (20-60 seconds).

The solution to this problem is easy and does not require any additional
software other than the standard Microsoft Windows Explorer.
1. Open Windows Explorer (explorer.exe)
2. Select Tools | Folder Options from the menu
3. Go to the File Types tab
4. Select list item XLS (Microsoft Office Excel 97-2003 Worksheet) and click
on Advanced. If the Application used to perform action: field the default
value should be C:\Program Files\Microsoft Office\Office12\EXCEL.EXE /e.
Change this to C:\Program Files\Microsoft Office\Office12\EXCEL.EXE %1.
Remember to enclose the full excel.exe path and %1 in parenthesis. Since
Windows 95 this is a way to escape spaces in file names; %1 will return the
file name of that file that is being opened by double-clicking.You can
uncheck Use DDE but Microsoft Office Excel 2007 will bring it back to what
you see above when you next open it.

5. Just confirm (hit OK) on all the Microsoft Windows Explorer dialogs and
next time you open a Excel 2003 file in Excel 2007 without having it already
running you wont have to wait! Problem solved!

You can try to check if this solution will solve your problem with windows
Vista.

Good Luck,

Tim



"kojaks43" wrote:

Using Excel 2007 - Home edition.

Created a list and placed drop down using data validation.
The drop down window shows some of the entries with a scroll bar. Can I
increase the size of the drop down so the scroll bar goes away?

Thanks

k

  #2   Report Post  
Posted to microsoft.public.excel.misc
Tim Tim is offline
external usenet poster
 
Posts: 408
Default increase number of items shown in drop down list?

Sorry the above answer was for the previous question.

Tim


"Tim" wrote:

I am running Windows XP and dont have your problem. When I opened an excel
2003 file in excel 2007 I found that it takes longer to open the file without
having Excel 2007 already running (20-60 seconds).

The solution to this problem is easy and does not require any additional
software other than the standard Microsoft Windows Explorer.
1. Open Windows Explorer (explorer.exe)
2. Select Tools | Folder Options from the menu
3. Go to the File Types tab
4. Select list item XLS (Microsoft Office Excel 97-2003 Worksheet) and click
on Advanced. If the Application used to perform action: field the default
value should be C:\Program Files\Microsoft Office\Office12\EXCEL.EXE /e.
Change this to C:\Program Files\Microsoft Office\Office12\EXCEL.EXE %1.
Remember to enclose the full excel.exe path and %1 in parenthesis. Since
Windows 95 this is a way to escape spaces in file names; %1 will return the
file name of that file that is being opened by double-clicking.You can
uncheck Use DDE but Microsoft Office Excel 2007 will bring it back to what
you see above when you next open it.

5. Just confirm (hit OK) on all the Microsoft Windows Explorer dialogs and
next time you open a Excel 2003 file in Excel 2007 without having it already
running you wont have to wait! Problem solved!

You can try to check if this solution will solve your problem with windows
Vista.

Good Luck,

Tim



"kojaks43" wrote:

Using Excel 2007 - Home edition.

Created a list and placed drop down using data validation.
The drop down window shows some of the entries with a scroll bar. Can I
increase the size of the drop down so the scroll bar goes away?

Thanks

k

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6
Default increase number of items shown in drop down list?

Tim, I think you answered another question and placed it on mine.
I am trying to have a data validation box open so all the available options
are visible. I seem to remember to being able to enlarge the depth of the
drop down to include all variables in 2003, but not in 2007.

"Tim" wrote:

I am running Windows XP and dont have your problem. When I opened an excel
2003 file in excel 2007 I found that it takes longer to open the file without
having Excel 2007 already running (20-60 seconds).

The solution to this problem is easy and does not require any additional
software other than the standard Microsoft Windows Explorer.
1. Open Windows Explorer (explorer.exe)
2. Select Tools | Folder Options from the menu
3. Go to the File Types tab
4. Select list item XLS (Microsoft Office Excel 97-2003 Worksheet) and click
on Advanced. If the Application used to perform action: field the default
value should be C:\Program Files\Microsoft Office\Office12\EXCEL.EXE /e.
Change this to C:\Program Files\Microsoft Office\Office12\EXCEL.EXE %1.
Remember to enclose the full excel.exe path and %1 in parenthesis. Since
Windows 95 this is a way to escape spaces in file names; %1 will return the
file name of that file that is being opened by double-clicking.You can
uncheck Use DDE but Microsoft Office Excel 2007 will bring it back to what
you see above when you next open it.

5. Just confirm (hit OK) on all the Microsoft Windows Explorer dialogs and
next time you open a Excel 2003 file in Excel 2007 without having it already
running you wont have to wait! Problem solved!

You can try to check if this solution will solve your problem with windows
Vista.

Good Luck,

Tim



"kojaks43" wrote:

Using Excel 2007 - Home edition.

Created a list and placed drop down using data validation.
The drop down window shows some of the entries with a scroll bar. Can I
increase the size of the drop down so the scroll bar goes away?

Thanks

k

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,979
Default increase number of items shown in drop down list?

Showing more items in the data validation list wasn't possible in
earlier versions of Excel either.

As T.Valko mentioned, you could use a combo box instead. There's a
sample file he
http://www.contextures.com/xlDataVal11.html
that you could convert to Excel 2007 format.

kojaks43 wrote:
Tim, I think you answered another question and placed it on mine.
I am trying to have a data validation box open so all the available options
are visible. I seem to remember to being able to enlarge the depth of the
drop down to include all variables in 2003, but not in 2007.

"Tim" wrote:


I am running Windows XP and dont have your problem. When I opened an excel
2003 file in excel 2007 I found that it takes longer to open the file without
having Excel 2007 already running (20-60 seconds).

The solution to this problem is easy and does not require any additional
software other than the standard Microsoft Windows Explorer.
1. Open Windows Explorer (explorer.exe)
2. Select Tools | Folder Options from the menu
3. Go to the File Types tab
4. Select list item XLS (Microsoft Office Excel 97-2003 Worksheet) and click
on Advanced. If the Application used to perform action: field the default
value should be C:\Program Files\Microsoft Office\Office12\EXCEL.EXE /e.
Change this to C:\Program Files\Microsoft Office\Office12\EXCEL.EXE %1.
Remember to enclose the full excel.exe path and %1 in parenthesis. Since
Windows 95 this is a way to escape spaces in file names; %1 will return the
file name of that file that is being opened by double-clicking.You can
uncheck Use DDE but Microsoft Office Excel 2007 will bring it back to what
you see above when you next open it.

5. Just confirm (hit OK) on all the Microsoft Windows Explorer dialogs and
next time you open a Excel 2003 file in Excel 2007 without having it already
running you wont have to wait! Problem solved!

You can try to check if this solution will solve your problem with windows
Vista.

Good Luck,

Tim



"kojaks43" wrote:


Using Excel 2007 - Home edition.

Created a list and placed drop down using data validation.
The drop down window shows some of the entries with a scroll bar. Can I
increase the size of the drop down so the scroll bar goes away?

Thanks

k




--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Items in drop-down list alphabetized andy62 Excel Worksheet Functions 6 March 13th 07 06:49 PM
increase number of files listed In the drop down box on my compute vicki Excel Discussion (Misc queries) 3 February 2nd 06 07:08 PM
How do I increase font size in a drop-down list in Excel? hdaniels_uwco Excel Discussion (Misc queries) 1 October 11th 05 05:36 PM
How to add and delete items from a list box or drop down box? Fifee Excel Discussion (Misc queries) 3 August 12th 05 01:49 PM
How do I increase type size in an Excel drop down list? [email protected] Excel Discussion (Misc queries) 1 January 27th 05 01:27 AM


All times are GMT +1. The time now is 10:34 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright 2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"