Unwanted automatic change of text number format to scientific
I have a simple spreadsheet in which I was trying to list "codes" for keeping track of data for a game I'm working on. (Table top dice game) I find that the codes 01P2 or 01G2 can be found and replaced with 02 or 03, etc. However, my code 01E2 etc. changes automatically to scientific format. Apparently something about the "E" triggers some sort of auto response. I looked around in options but found nothing that seems to apply to this. I tried chat but the techie wanted to take over the computer, which sounded to me like overkill. He transferred me to second techie who dumped me out of the chat. First time ever I gave feedback of one star. Anybody have a simple solution?
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, Daniel
How to make excel add or remove rows to fit data and prevent spill error?
Hello! My question is: When using the =FILTER formula to copy cell data from one sheet to another, how can I make excel add or remove rows as needed to prevent a spill error? I am using the =FILTER formula to copy cell data from one sheet to another if a checkbox is checked. My formula uses the cells containing the checkbox (column A) as the reference for columns B, C, D, etc. to the right. I did this by selecting the cell that has the formula on the destination sheet, highlighting this cell and those to the right I wanted to transfer, and then control + r. My formula is: =FILTER('Source Sheet'!B5:B13,'Source Sheet'!$A5:$A13=TRUE) (If there is a way to copy an entire row from the source sheet instead of having to control+r to apply the original formula across select cells please also let me know, thank you!). However, I want the sheet to be able to automatically add rows to fit the data if the selected number of rows is greater than what I have left available on the sheet. Currently, if I leave 3 rows for data to fill and I select three checkboxes, this will fill the space with no problem. However, if I select 4+, I get a spill error (as there are not enough empty rows to put the data). Is there any easy way to have excel add rows as needed? Similarly, is there a way for excel to remove rows as needed? I am going to use this sheet to detail all medications being taken by family members (with medication name, concentration, dose, time to take each in their own column as column B, column C, column D, column E). The names will be listed in column A with ~3 rows below each name which will fill when the checkbox on the source sheet is clicked. I want to ideally fit this on one page when printing without major "fit to page" problems that come up during printing. The layout of the sheet will ideally look like this: The goal for the 'destination sheet' is to pull only the selected data I want to use from my master list on the 'source' sheet.' I want to avoid having a big empty space under each family member where they don't take many medications, and to also not have to manually add rows for family members that take a greater number of medications. Please let me know and thank you!
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:
