Recent Discussions
Using Upper and or Proper Function - not working properly
I am trying to use the UPPER function on my Excel sheet. I was able to format my first column, but when I try the next column, it won't convert. I have tried several times, and it will not convert the function. I have included two screenshots to show the progression. I formatted the column to text, and have tried to troubleshoot any tips I have come across. I have tried both on my desktop and uploaded to my 365 and both have the same result. What am I missing?
How to add a new field to existing XML Mapping
Hi, everyone! Good day! I've made an XML file which I imported to my doc using XML Mapping Pane -> (Add new part...) and I used it to map some texts. How could I add new fields to this XML Mapping? What I tried: I tried editing the XML file and then importing it again. As a result, I have two XML Mappings with the same name that act as completely separate mappings. I couldn't even find a way to delete the older one.
Index and Match command is return results from the wrong column
Within Excel I'm using the Index and Match command to search an array. I've provided copy of the workbook. Here is the command =IFERROR(INDEX(D7:H11,MATCH($D$13,L7:L11,0),MATCH($E$13,M7:M11,0)),"") Here is an added twist on sheet 1 I use this formula and it works correctly. This formula is on sheet 2. The results for the Average column returns correctly. The other columns appear as if the were flipped. When the Marginal column is selected I get results from the Above Avg column. The opposite happens if I choose the Above Avg column I get the Marginal results. The same thing happens if I choose the columns on the ends. As shown in the image above the Extreme row is selected and the One column is chosen. The result should be "Caution", but instead the result is "None6". FYI, this is part of larger workbook where the results will be posted on a different worksheet, but to simplify everything I've placed it on its own page. RegardsHow do I correct heading numbering?
UPDATE: I couldn't remove this post, after I discovered the issue. Thanks! I need to update heading numbering within an old document. Custom headings were made (as pictured) but I need the heading levels 2 and 3 to include the parent heading number of each. When I attempt to update the level 2 heading for Section 2, it wants to continue with Section 1 (see pictured example). In the number format, I do not know how to tell Word to include the parent numbers? I included "1." thinking it was intelligent enough to know that was just a format designation of the parent heading, but I guess that isn't how. I realize I may be making some glaring mistakes, but just trying to get it right. So this is a learning moment. The caveat here is that I'm not creating the heading from scratch but rather, trying to update the existing document headings. I did follow some online suggestions but none of them addressed including the parent value in this scenario. Section 2 <Heading Level 1 text format> <-- Here I need the word "Section" to proceed the level 1 heading number 2.1 <Heading Level 2> <-- Here I need the level 2 heading to include the parent section level number 2.1.1 <Heading Level 3> <-- Here I need the level 3 heading to include level 1 and 2 numbers.How to eliminate any height beyond text height on textbox
Why? I need to make a special Quick Part where stacked text boxes are close enough to overlap each other before the actual texts start overlapping. This makes the text input afterwards a struggle. I can fine-adjust the space at the bottom by dragging a text box's resize handle, but the space at the top doesn't disappear. I've already removed margins, paragraph spaces and set line spaces to minimum. Setting vertical alignment from Top to Middle doesn't change this behavior. Is it possible to adjust the text box's size to fit the text size exactly?
Excel bug Data sorting largest to smallest
I have some problems by sorting data in excel. First sorting by column M Largest to Smallest, than by column L also Largest to Smallest. In one case sorting is not successfully (Marked font color RED). Can someone explain this to me? https://drive.google.com/file/d/1n_IWsw9YH6FDxXnFm_wWwJEVQIN9AxRu/view?usp=sharing
Recent Blogs
- This update to Microsoft OneNote on Windows gives you more flexibility over proofing languages in your notebook pages.Dec 16, 2025
- Confidently migrate user data across tenants. Automate cutover, keep teams connected, and stay secure.Dec 16, 2025
