From long dropdown to a short one
I used to have a longer list of dropdown in the cell name(top left of
worsheet) including names given by me to ranges. I had to reinstall XL and now I do not get more than 7 items unless I scroll down. Is there a setting to change it back to show all names when clicked? Thanks. |
From long dropdown to a short one
Refer the below link
http://www.contextures.com/xlDataVal11.html If this post helps click Yes --------------- Jacob Skaria "XLFanatico" wrote: I used to have a longer list of dropdown in the cell name(top left of worsheet) including names given by me to ranges. I had to reinstall XL and now I do not get more than 7 items unless I scroll down. Is there a setting to change it back to show all names when clicked? Thanks. |
All times are GMT +1. The time now is 11:16 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com