Excel Validation list brick wall!
 

Just goto view zoom

"Alex Garner" wrote:

I may have hit a brick wall - none the less here is my issue.

My department works with a very detailed and busy rota on Excel and building
the rota on a weekly bases is using too much valuable departmental time. I
therefore would like to use a drop down list to select the entries thus
saving time. My problem is not with building the list it is viewving the list
due to the fact we work with the document at a 25% Zoom level and it seems
only possible to view the contents of the list at 100%.

Is there anyway that I will be able to view the list zoomed at 25%?

Excel Validation list brick wall!
 

Thanks for the reply however it is not practical to keep zooming in and out
as we need to view an overview of the spreadsheet whilst populating the week.

This will not help as i have to train a number of staff who have low
competency levels on excel.

Is there no way of enlarging the drop down box?

"Satyendra_Haldaur" wrote:

Just goto view zoom

"Alex Garner" wrote:

I may have hit a brick wall - none the less here is my issue.

My department works with a very detailed and busy rota on Excel and building
the rota on a weekly bases is using too much valuable departmental time. I
therefore would like to use a drop down list to select the entries thus
saving time. My problem is not with building the list it is viewving the list
due to the fact we work with the document at a 25% Zoom level and it seems
only possible to view the contents of the list at 100%.

Is there anyway that I will be able to view the list zoomed at 25%?