Forum Widgets
Latest Discussions
Text Form Field Expression - Calculate Average but Ignore '0' or 'N/A'
Good Day All, I am making a Job Review Word form that is based off a numerical ratings system. I would like to take the average of all the numerical ratings, currently =Average(ADP,Fit,TimeAway,Calendar) is working great. (see pic) What I would like to do is calculate the average of the ratings but ignore any values that say 0 or N/A. In excel I would be using the AVERAGEIF function, but I cannot get that to work here. Does anyone have a solution that I am missing?GasDetectJan 12, 2025Copper Contributor16Views0likes1CommentHow to create 'sub-headings' after a dash
I apologise but I cannot really determine what this issue should be called. I will show you what I am referring to. - So here I have started a sentence with a dash and then a space, - Which usually would create a gap before the sentence begins in a word document. - and here you can see I have added a larger gap between the left margin and the dash - how can you do this within a word doc. - i know in a google doc you press tab after starting a new line but I don't know how to do it in word. This is definitely a sketchy explanation of my issue but I am hoping someone will be able to understand and help me with my issue. Thank you. Looking forward to a response. :)SolvedMattyF4ttyJan 11, 2025Copper Contributor42Views0likes3CommentsWord replaces document images with images from other documents when executing a print function
I create a document with images/photos placed throughout the document (the pictures have been copy/pasted from a non-Word source, ie., websites, etc.); some are located "in line" with text; some are located "tight"; and some may be "in front" or "behind" text. Everything looks just as I want. So then I execute a print either to a PDF or to my default laser printer (the problem occurs either way; the problem occurs simply when an executing a print). The images in the origin document (and therefore the printed result) change to an image I used in another document, sometimes from a previous day. The images swapped in are placed in the exact same position with the same formatting and size as the original image. If the original image was 2"x3" and the swapped in image was 4x2, Word distorts the 4x2 image into the 2x3 space.Word just randomly (I have not determined how it decides) swaps out my chosen image with another (the image swapped in is always from another Word document always from the same PC (I use MS Word on other PCs on the same local/home network). This is MS Word 2010.Otto_GustafsonJan 09, 2025Copper Contributor1.7KViews0likes2CommentsFiles opening in Read Mode
For the past day or so, all the files I'm working on are opening in Read Mode instead of Print Layout, the only View I use. I've searched every option for a solution to this but found nothing. I know I can click on View in Read Mode and select Print Layout, but 1) I shouldn't have to take this extra step, especially since I've never ever ever used Read Mode and my files have always opened in Print Layout until now, and 2) the program freezes for several minutes when I try to enable Print Layout mode. I'm using Microsoft Office 365 and Windows 10. I edit book manuscripts and need to streamline the process any way I can. I have not changed any settings in Word.marcia4dJan 09, 2025Copper Contributor8.6KViews0likes2CommentsHow to remove the underline from specific words
In Word, I have many instances of "X people 12%" where the whole text is underlined, but I want to remove the underline from the word "people" while keeping the rest underlined. How can I do that in bulk?ironman1965Jan 09, 2025Copper Contributor8Views0likes0CommentsMultiple shortcuts suddenly stopped working.
Normal keyboard shortcuts such as ctrl+C, ctrl+V, ctrl+Z, ctrl+Y, and ctrl+S suddenly stopped working for me. Some shortcuts still work, for example, ctrl+B or ctrl+U. I have no idea what caused it, and when I click 'Reset All' in the Ribbon Customization menu it doesn't get them back. Furthermore, I then readded some of these shortcuts manually and reseted the list, and it did delete the new additions, but didn't return the old hotkeys. It oddly looks like the original list was somehow hardwired not to include some of these shortcuts anymore. I tried reopening Word and restarting my computer, but it didn't work. What options do I have to my avail? Thanks a lot to whomever can helpShir_SagiJan 09, 2025Copper Contributor3.7KViews0likes3CommentsWord to PDF, issue with gradient colors
Hello all, I've got a simple shape in Word filled with a gradient color. As I "Print" or "Save As" the Word document in PDF, the color gradient is not showing properly in the PDF file. In Word, I've already been in Options / Display / and selected "Print background colors and images", but it doesn't change anything. Please can somebody help? This is how it looks like while I'm in Microsoft Word And this is the PDF result as I do Print in PDF or Save As in PDF from the Word document.PepinoJan 08, 2025Copper Contributor9Views0likes0CommentsSimply cannot delete a section break. It is impossible. Cannot be done. Please prove me wrong.
So I was introduced to section breaks as a means of getting page numbering up-to-spec for book I've written (roman. numerals in the front material, arabic numerals in the book itself). I'm using the latest version of Word (16.8?) on Mac. To my horror, I've found that it is impossible to delete section breaks once they're in my document. I have spend an entire day in Google on this subject, and every single suggestion fails. So I have enabled showing markup, so I can see page breaks, section breaks, paragraphs I cannot select a section break. Word will not allow that. So I can't select and delete it. I cannot put the cursor after a section break and then hit the delete button as many suggest. Word will not allow the cursor to be placed after a section break. Putting the cursor before the section break, as other articles recommend, is just wrong. All you're doing there is deleting text before the section break. Why is this so hard? I've lost a whole day on something that should be simple. In the screenshot from my document below, The section break simply cannot be touched.markaaronky1390Jan 07, 2025Copper Contributor173KViews1like20CommentsCreating 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.Mat4141Jan 07, 2025Copper Contributor30Views0likes1CommentVBA to set logo in the header as Decorative
I have macro code to set Alt Text for small images in a document to Decorative. Sub alttext() Dim shp As InlineShape Dim doc As Document Set doc = ActiveDocument For Each shp In doc.InlineShapes If shp.Width >= InchesToPoints(2) And shp.Height >= InchesToPoints(1) Then shp.AlternativeText = "Figure. Caption." Else shp.Decorative = True End If Next shp End Sub Works great. However, it overlooks the image in the Header for some reason. I need to set Alt Text for my logo in the Header to Decorative. I cannot seem to figure this one out. Please help.HowardPitchonJan 07, 2025Copper Contributor190Views0likes2Comments
Resources
Tags
- word770 Topics
- office 365290 Topics
- Word Online122 Topics
- Office Apps109 Topics
- 201678 Topics
- Apps36 Topics
- Online28 Topics
- admin24 Topics
- 201322 Topics
- Mobile10 Topics