show a due date using data from multiple columns
I have a spreadsheet in excel, such as the Table 1 below. For the 5 Due Date columns, I have conditional formatting set up to format the cells. See Image 1 for a list of rules applied to all Due Date columns. I'd like for another table to populate, showing only columns, Laboratory ID, Description, and any column that is highlighted per the conditional formatting rules. For example, I'd like the return table to look something like Table 2. Table 1. populated in cells G9:N12 ID Description Due Date 1 Due Date 2 Due Date 3 Due Date 4 Due Date 5 Out of Service? 1234 Instrument 1 11/17/2025 N/A 1/31/2027 3/11/2026 11/17/2027 FALSE 1235 Instrument 2 1/14/2026 2/17/2026 3/31/2027 1/23/2026 12/29/2027 TRUE Table 2. Conditional formatting rules applied to cells I9:M12 This Week = White font color, Red fill This Month = Red font color, Light Red fill Next Month = Dark Yellow font color, yellow fill Table 2. If today is 11/10/2025, the table will display columns ID, Description, and only column show for due dates within This Week: ID Description Due Date 1 1234 Instrument 1 11/17/2025
Excel Comments gone/unable to view
I've created a workbook to log information for my work. In this, I had a notes section that I could log all conversations I had when I had contacted a customer so when I hover over the purple indicator in the cell, it would show me the conversations/key notes i've had with customers. I have just opened my workbook today to try and view/add to these comments and all comments now have a red indicator in the cell and the text says the following ' [Threaded Comment] Your version of excel allows you to read this... How can I recover my notes as they are extremely important to my work.
Weird email "conversion" of a .xlsx attachment
I sent someone an Excel spreadsheet recently as an email attachment, and when he clicked on the attachment to open it, this is what came up on his end. I've never seen anything like this before, but it looks like he doesn't have Excel installed on his computer.
Hide Sheet after missusing shortcut Alt+H+W
I was working on an inventory and frequently using the shortcut mentioned above. Unfortunately, during one of those times, I must have misused it, and my sheet became hidden. Since then, I’ve tried multiple methods to unhide it, but none have worked. I would really appreciate your assistance in resolving this issue.
Custom Date format Excel 365 ddd/mm/yy
Hi all, I am working on creating to-do list in Excel 365. I am wanting to display the due date in the following format (ddd - mm - yy) which I know how to do, you go into custom and write your own date format. My date should read: Mon - 01 Jan - 25 I am using Office 365 excel online, when I go to custom it won't let me write the date format I want in, I can only pick from a pre-defined list. My question is does anyone know how to change it, please, thanks JoelRecording just a month and a year
Hello - Looking to refresh a spreadsheet I have for keeping track of all my books, games and when I complete them and what-not. One thing I'd like to properly set-up this time is a pivot table of some sort, so I can generate some charts based on what I've completed in a given month. My first thought is I need a way to make a note of what month I completed something in, alongside the year so I don't get mixed data with this going forward. Is there a way for Excel to record a month and a year specifically, without needing to specify a date? Or would it make more sense for me just to have a "Jan-2026" as a general entry? Seems simpler, but don't know if it'll auto-sort by month like would be ideal.Stockhistory returning #BLOCKED! error
I started getting this error a couple of days ago. Summary of the problem and what Excel Tech Support did but didn't fix the problem. 1. I get #BLOCKED! error with my stockhistory formula but stock data type formula is still working because I can still pull the stock price from Microsoft online repository (Bing) 2. In my local copy of Excel, the group data types has gone missing. I can retrieve it via customising ribbon but the icons for stock, currency, etc. is not there. 3. In the web version of Excel, the data types group is there but I still get the same error as (1) 4. Yesterday, the Microsoft support person reinstalled my copy of Office, checked the privacy settings in "Connected Experiences" but did not fix the problem. They said it was going to be escalated but I didn't get a call back at the agreed time. I went back to Tech Support via chat and the guy said that stockhistory function has been removed from Excel. Clearly clueless. 5. Is this a license problem?Trouble inserting rows
I am receiving an error message while right clicking and attempting to insert rows above and below. The error message reads, "This operation is not allowed. The operation is attempting to shift cels in a table on your worksheet." No other users are currently signed onto the worksheet. How can I resolve this?Agent Mode continuously loading
Hi all, I installed Excel Labs today and have tried to use https://www.microsoft.com/en-us/microsoft-365/blog/2025/09/29/vibe-working-introducing-agent-mode-and-office-agent-in-microsoft-365-copilot/ for Excel in the web. However, no matter which prompt I use, it just loads continuously, even when left for hours. Has anyone got this working? Or know how to resolve this? I appreciate it's a Preview feature, so happy to wait if it's a temporary glitch, but thought it'd be worth checking.Autocompletar em vez de trazer dados acima da célula, traz os que estão abaixo.
Olá Tenho especificamente uma planilha que no Excel web (Microsoft 365) em que o autocompletar não está funcionando da forma normal, isto é, trazendo os dados que estão na mesma coluna, acima da célula. Em vez disso, traz os dados que estão abaixo. Exemplo: Ao digitar "b" em A5, em vez de o autocompletar sugerir "beta", traz "ball". Alguém tem esse problema? Conseguiu corrigir? Como?
