Drop down list font size

sbuege

New Member
Joined
Aug 19, 2023
Messages
3
Office Version
  1. 365
Platform
  1. Windows
Wondering if anyone has encountered this and if there is a solution. If I increase the zoom on the worksheet, the drop down list font size should also increase. This was working until earlier today. Now the font stays the same small size. This happens on both new and existing workbooks. I'm using 365.

Thanks

Steve
 

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop
Drop-Down List is ActiveX component, or Validation list?
 
Upvote 0
Validation list. The look of the drop down has changed too. I have uninstalled and reinstalled office 365. This did not correct it. I'm thinking it was an Excel update perhaps.

Steve
 
Upvote 0
I don't think that there is a way to increase font size in a Validation list.
 
Upvote 0
You can't change the actual font size, but it used to be that if you changed the sheet zoom level the displayed size increases or decreases accordingly. The OP is saying that zoom no longer affects the displayed size. I have confirmed this in my version, which is Home 365 build 2307.

So, yeah, I think there has been an update that affects this.
 
Upvote 0
I've got build 2308 & see the same thing. It also now removes duplicates if you use range for list & is searchable
 
Last edited:
Upvote 0
There are pros and cons to having a subscription product that is subject to being updated without giving you an opportunity to read the release notes first.
 
Upvote 0
Agreed, it would also be nice if they actually said what had changed.
 
Upvote 1
Thanks everyone for the replies. It does appear to be the result of an Excel update since others are experiencing the same 'problem' I am. Not a fan of this but time to make the best of it. Again, thanks.

Steve
 
Upvote 1

Forum statistics

Threads
1,224,820
Messages
6,181,161
Members
453,021
Latest member
Justyna P

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top