Pinned Posts
Forum Widgets
Latest Discussions
Excel font rendering blurry when zoomed out (Windows 11, Microsoft 365)
Hello Community, I’m experiencing an issue with Excel (Microsoft 365) on my new Windows 11 ASUS touchscreen laptop. The text in Excel becomes noticeably blurry when zooming out, but looks fine when zoomed in. This problem does not occur in other applications (like browsers) and did not happen on my older Windows 10 laptop running the same version of Excel. What I’ve tried so far (with Microsoft Support): • Tested in Safe Mode → still blurry • Checked ClearType text and confirmed scaling at 100% • Verified “Optimize for best appearance” is already set • Installed Office updates and restarted device • Disabled all add-ins • Disabled hardware acceleration in Excel • Updated graphics drivers and adjusted GPU scheduling • Removed second monitor → no change • Compared display settings and Excel files between devices • Checked Excel Options for missing settings (e.g., Hardware Graphics Acceleration toggle not visible) • Remote session with support agent confirmed the issue persists Observations: • Only affects Excel (not other apps) • Text looks fine when zoomed in, but blurry when zoomed out • Blurriness persists even after updates, safe mode, and driver changes • Same Excel version works fine on Windows 10 • Touchscreen and scaling differences were considered but ruled out Has anyone else experienced this issue with Excel on Windows 11 (especially on ASUS touchscreen devices)? Is this a known rendering limitation, or are there any reliable workarounds/fixes to improve text clarity when zooming out? Thanks in advance for any insights! See the attached below for your reference: with blurry: without blurry issue:
Python in Excel - not in toolbar
I have MS Excel (Current Channel) via an M365 - Business Premium license I have Python in Excel; I know this because if I type '=py' in a cell and hit tab I get a python cell with the green [py] box. However, I do not get the Python group in the Formula toolbar... why?? This grouping is supposed to have the 'Insert Python', 'Initialization', and 'Reset' controls in a grouping named Python. Subsequently, I have had to create a custom grouping with the relevant python controls added manually... What is the cause of the python controls missing from the Formula toolbar?Excel desktop application crashes when trying to share or copy link
For the last couple of weeks when I've attempted to share an Excel file from the desktop app (multiple different files) the application crashed and closes out. The file are all saved to my personal OneDrive. It only seems to affect the files from my SharePoint, and only when trying to share through the desktop app. I can open it on the web version and share. I tried sharing a file that was opened through a SharePoint site and it seemed to work.
Excel: Count cells with specific value + colour
Hi there, I would like to be able to count the number of cells that contain a specific value and are shaded a specific colour. This is for a rota spreadsheet that will be tallying the total number of shifts which have been agreed. The cells that contain "Yes" as a value from a drop down list and are shaded green, should be counted as part of the quarterly total. I'm assuming that a VBA custom function would be needed for this. I've tried a few but cannot figure out a way to get this to work with both a specific value and colour. I would be very grateful for anyone that is able crack this challenge. In the example screenshots, it is the cells shaded in green that would need to be counted and the totals appear in column GJ. Best regards, DanielSame XMATCH formula stopped working when I updated data.
A month ago, I used the following formula to find an exact match in a column on a different tab with 259,999 rows and it worked. =XMATCH (A3,'EPC - 09-4-25'!B$1:B$250000) I copied over the list of 250,000 with updated information. The formula does not work and returns #NA. =XMATCH (A3,'EPC - 09-4-25'!B$1:B$250000) Any suggestions for what could be wrong?
