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?
Word 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.
Files 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.Multiple 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 help
Word 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.
Simply 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.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.
VBA 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.
