Creating a dynamic line in a row
Hi I'm trying to figure out a way to make a line that covers the entire row and sits in the middle, until a text is typed, then it starts to get shorter until it should eventually disappear as the text fills the whole row. I've tested lot's of options but none of them provided a desired solution, such as inserting a text box which just get's pushed onto the next row, etc... Unless there is a setting directly in word that would allow this, it might have to be a job for VBA, which I've never tried before. if anybody knows how to achieve this I'd be most grateful. Visual representation of the desired effect in the picture bellow done with line shapes and manual adjustment.
Remove space after Chapter number in ToC and Navigation Headings
I define a "Multilevel list" for automatic chapter numbering that does not follow the number with a space, like this: That setting does apply to Heading 1 text, but it is not incorporated into the Table of Contents or Navigation Headings: As shown in the following screenshot (yellow highlighting), both of those still insert a space after the Chapter number: How can I get at least the ToC to not insert a space after the Chapter number? Ideally how can I get the Navigation pane to respect the setting also?
How to clear persistent "Normal" style, after exporting from Google Docs
All right, this is really bugging me. I started a document in Google Docs and worked on it for several weeks. Finally needing some more advanced formatting options, I exported it to a Microsoft Word .docx file and opened it in the desktop app Microsoft Word 365 for Enterprise (Version 2403, Build 17425.20176 Click-to-Run, for Windows). From the moment I first did the import, I noticed there was something "off". The text had a background color: It's barely noticeable, but it's enough to really niggle my OCD. Especially when I discovered I couldn't remove it. It seems to be "burned into" the "Normal" style. The background color is set as a "Pattern: Clear (Custom Color(RGB(250, 250, 250)))." Okay, well I know how to unset that. But in the border/shading settings for the "Normal" style, it already seems to be unset: So I tried setting a different shading pattern, hoping that would overwrite the offending setting and then I'd be able to remove it, but no. Now there are two shading patterns set on top of each other, and I can't get to the underlying one to unset it: Really vexed now, I decided to try to hack the file. In word/styles.xml inside the .docx, I found this: I deleted the whole <w:shd> element from the XML and saved the file. Then I zipped it back up and renamed it back to .docx. But when I opened the file, it was back to its old shenanigans. I saved the file again as a different filename and hacked into the file again. The <w:shd> element had re-set itself. And sure enough, there are now two <w:shd> elements in the "Normal" style. Where is this coming from? How do I get rid of it? Is there some other, Platonic ideal, "super-Normal" style that the "Normal" style depends on? I checked the Normal.dotm template and it wasn't set there. I already tried starting a new document and copying everything from the old one to the new one, using destination styles, but somehow this transferred with the text. I suppose next I'll have to do it again, copying only text, or passing it through a plain text editor. But then I'll lose 20 pages worth of formatting, ugh.
TOC formatting as hyperlinks
Hi, I am using version 16.78 of Word on Macbook Pro. I have a document where I have a TOC which is customised, it worked fine up until now. The formatting doesn't match the style anymore, and just shows up as regular text, but as a hyperlink (blue and underlined). Clicking on it does send me to the correct heading, but it doesn't match the format style. I have removed, updated and reset the TOC, i've tried remaking the headings, I have deinstalled Word and reinstalled it again, nothing works. On Onedrive live online it does work normally, but not on my native app, even after reinstalling. My documents are saved one Onedrive, but it happens when I save Word documents that I stored locally. Does anyone know what to do to solve this?
Table Of Contents Formatting Not Matching Heading Style Formatting
In my word document (Microsoft Office Professional 2019 / .docx) all of the headings are setup using the Heading 1 style which is set for font= Arial, Size= 12, and BOLD is turned on. My table of contents is setup to use the Heading 1 style as shown: {TOC \h \z \t "Heading 1,1,Heading 2,2,Heading 3,3" } The table of contents works to capture all of the correct pages, however, where all of the headings in the document are done in all caps, the entries in the table of contents vary from all caps, all caps for the first word or two, to all lowercase as shown below. I've tried to update the Heading 1 style and then doing the "Update Field / Update Entire Table", but the text in the TOC stays the same.Cell Validation - Drop Down Lists and Text Formatting
Hi, I have a form in Excel that has a couple of drop down list options. I have my lists saved on a separate tab and i would like the options within one of the lists to repeat the specific text/cell formatting i have in place (each option has a different colour of text and cell fill applied, with mixed font sizes within the same cell). Is there a away o can do this without also adding conditional formatting to the cell that contains the drop down? CF doesn't quite give the result i am looking for as it doesn't mirror the mixed font sizing i have in place for the actual list. Would appreciate any help you can offer with this. Thank you J
Relative conditional formatting
Hello, I have multiple worksheets in Excel 365 that present data from one month to another. I am trying to make the data turn green if it's gone up since the previous month or red if it's gone down. I would like to know the quickest way to copy-paste the conditional formatting so it is relative to the previous month and not reference the original cell in the formula. ex: I have sales in column A2 to A50 in worksheet february and would like to format it n relation to column A2 to A50 in worksheet january while matching A2 feb with A2 jan, A3 feb with A3 jan... I hope I'm being clear. If it's easier with Icons, I can do that instead. Thanks!
