Excel for Office 365 Word for Office 365 Outlook for Office 365 PowerPoint for Office 365 Excel 2019 Word 2019 Outlook 2019 PowerPoint 2019 Project Professional 2019 Excel 2016 Word 2016 Outlook 2016 PowerPoint 2016 Project Professional 2016 Excel 2013 Word 2013 Outlook 2013 PowerPoint 2013 Word 2010 Project Online Desktop Client Project Professional 2013 Project Standard 2013 Project Standard 2016 Project Standard 2019 In a text box or shape, you can quickly change the color of text, the inside (fill) color, or the color of the border. Let's select the shape—the Drawing Tools appear in the ribbon, with the Format tab active.
Word 2007 or later: On the ribbon menu above your document, click the Insert tab, then Text Box, then Draw Text Box. Click and drag in the document. Word for Mac 2011 or later: Select Home on the ribbon menu, then click Text Box on the right hand side. Click and drag in the document. Word 2003 / Word for Mac 2008 or earlier: Select Insert → Text Box from the top menu. Click and drag in the document. Layout Guides in Publisher- Tutorial and Instructions: A picture of the “Layout Guides” dialog box in Publisher. Baseline guides are layout guides in Publisher that allow you to align text lines across multiple columns.
Here's the same shape after we changed the border to orange, the fill to a light green, and the text to black. We used the Shape Outline, Shape Fill, and Text Fill commands, available on the Format tab under Drawing Tools. Although the changes we'll make below are shown in Microsoft PowerPoint, they work the same way in Excel, Word, Outlook, and Project.
Change the text color. Select the shape or text box border. When you do that, the Drawing Tools appear. To change multiple shapes or text boxes, click the first shape or text box, and then press and hold Ctrl while you click the other shapes or text boxes. On the Drawing Tools Format tab, click Text Fill and, under Theme Colors, pick the color you want. Note: The Text Fill and Text Outline menus might not be active until you start typing in your shape. To change the text to a color that isn't in the theme colors.
Select the shape or text box. On the Drawing Tools Format tab, click Text Fill More Fill Colors. In the Colors box, either click the color you want on the Standard tab, or mix your own color on the Custom tab. Custom colors and colors on the Standard tab aren't updated if you later change the document theme. Change the inside (fill) color. Select the shape or text box to change.
When you do that, the Drawing Tools appear. To change multiple shapes or text boxes, click the first shape or text box, and then press and hold Ctrl while you click the other shapes or text boxes. Click Shape Fill, and under Theme Colors, pick the color you want.
To change the fill color to a color that isn't in the theme colors. Select the shape or text box.
On the Drawing Tools Format tab, click Shape Fill More Fill Colors. In the Colors box, either click the color you want on the Standard tab, or mix your own color on the Custom tab. Custom colors and colors on the Standard tab aren't updated if you later change the document theme. Change the border color. Select the shape or text box border. When you do that, the Drawing Tools appear.
If you want to change multiple shapes or text boxes, click the first shape or text box, and then press and hold Ctrl while you click the other shapes or text boxes. On the Drawing Tools Format tab, click Shape Outline and, under Theme Colors, pick the color you want. To change the border to a color that isn't in the theme colors. Select the shape or text box.
On the Drawing Tools Format tab, click Shape Outline, and then click More Outline Colors. In the Colors box, either click the color that you want on the Standard tab, or mix your own color on the Custom tab. Custom colors and colors on the Standard tab aren't updated if you later change the document theme.
What version Publisher? You can create an rounded corner autoshape, right-click, add text. The text will not follow the contour of the rounded corners. There are workarounds, takes a bit of doing. Try this: In autoshapes, basic shapes, create the crescent. Using the rotate handle and wrap tools adjust the shape to fit into your rounded corner. Copy, paste, flip for each corner.
Give the shapes no color, no line. Bring the shapes to the front. Your text will follow this contour.
Mary Sauer MS MVP news://msnews.microsoft.com 'nukie' wrote in message news:[email protected]. I want a rounded corner rectangle that has been infilled then a text box put inside that which will be white, but this text box also needs to have rounded corners to follow the rounded corner coloured border I have created.
Can't have a rounded text box. Publisher doesn't have that option. Mary Sauer MS MVP news://msnews.microsoft.com 'nukie' wrote in message news:[email protected]. version Publisher 2003, cant' see for looking to find this option on text boxes Hi many thanks but I don't want the text to follow the contour, I just want the text box not to have square corners, rounded ones to match the filled in rectangle border behind.?? Many thanks. But you can type text into some of the autoshapes, i.e. A box with rounded corners!
Br Terje 'Mary Sauer' skrev i melding news:[email protected]. Can't have a rounded text box. Publisher doesn't have that option. - Mary Sauer MS MVP news://msnews.microsoft.com 'nukie' wrote in message news:[email protected]. version Publisher 2003, cant' see for looking to find this option on text boxes Hi many thanks but I don't want the text to follow the contour, I just want the text box not to have square corners, rounded ones to match the filled in rectangle border behind.??
Many thanks. Doesn't matter if the autoshape has rounded corners, the text inside remains square. Mary Sauer MS MVP news://msnews.microsoft.com 'Terje Martinsen' wrote in message news:%23Sxk%[email protected].
But you can type text into some of the autoshapes, i.e. A box with rounded corners! br Terje 'Mary Sauer' skrev i melding news:[email protected]. Can't have a rounded text box. Publisher doesn't have that option. - Mary Sauer MS MVP news://msnews.microsoft.com 'nukie' wrote in message news:[email protected]. version Publisher 2003, cant' see for looking to find this option on text boxes Hi many thanks but I don't want the text to follow the contour, I just want the text box not to have square corners, rounded ones to match the filled in rectangle border behind.??
Many thanks. Many thanks, it was worth a try. 'Mary Sauer' wrote: Doesn't matter if the autoshape has rounded corners, the text inside remains square. - Mary Sauer MS MVP news://msnews.microsoft.com 'Terje Martinsen' wrote in message news:%23Sxk%[email protected].
But you can type text into some of the autoshapes, i.e. A box with rounded corners! br Terje 'Mary Sauer' skrev i melding news:[email protected]. Can't have a rounded text box. Publisher doesn't have that option.
- Mary Sauer MS MVP news://msnews.microsoft.com 'nukie' wrote in message news:[email protected]. version Publisher 2003, cant' see for looking to find this option on text boxes Hi many thanks but I don't want the text to follow the contour, I just want the text box not to have square corners, rounded ones to match the filled in rectangle border behind.?? Many thanks. I have some data in an Excel table which uses case sensitive codes. Does anyone know of a way to perform case sensitive VLookups. A1 contains 'TEXT', A2 contains 'One'. B1 contains 'text', B2 contains 'Two' If I enter 'text' in cell A4 and the following VLookup in B4: =VLOOKUP(A4;A1:B2;2;FALSE) I get the answer 'One', but I would like to see 'Two'.
I have found a work around by converting a number of characters to their ASCII codes, but this is very messy. I know that the FIND function is case sensitive whe. Hi, I have a macro which finds a certain piece of text in the document and then moves down a line and then selects all the text between that and the end of the document and the selected text is later sent out in an email. This has been working for some time but I have recently had some problems because the text is not being selected as before (extendmode on?) and I am sending out blank emails. The code fragment that I use to select the text is as follows Selection.HomeKey wdStory Selection.Find.Execute 'Issued at' Selection.MoveDo. What is the Max File Size a User Form can be?
I have Windows 7 with Office 2007. Does it have like a 64K limit?
The file size as far as kb. My entire Program is 1,203 Kb. When I ran it I got a 'compile Error out of memory', so I exported my User Form. Then I looked at the file size of just the User Form in a blank Workbook 34 KB =.frm 219 KB = frx My user Form is a Multi Page with 4 Pages on it. There are alot of text boxes and labels on the 4 sheets. Is there a limit to the number of text boxes & labels you can have in a user Form?
I have 12 GB of. What function formulation is required to round up calculated dollar amounts in half dollar increments? Hi, Try this =CEILING(A1,0.5) Where a1 is your calculated dollar amount.
Or you can wrap your formula with the ceiling formula =CEILING(your formula,0.5) - Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. 'DC' wrote: What function formulation is required to round up calculated dollar amounts in half dollar increments? I have some VLOOKUPs which sometimes return 50 or 60 characters (they're in merged cells). I want the text to wrap, and the cell to enlarge to fit the text - Just like it does whan you type it in, but somehow, because it is being returned from a formula it just displays the bottom line of the wrapped text, and doesn't resize the row. Anyone know how I cam make it fit? I'm happy to use a VBA solution if there's no built in way to make it happen automatically. Thanks M Would you mind to limit your request to ONE newsgroup?
Joerg 'Michelle' 0,(RIGHT(E3,5).1),999999) to RANK by the last 5 =RANK(D3,D$3:D$102,1)+COUNTIF(D$3:D3,D3)-1, but then LOOKUP. Can anyone see what might be wrong withthis procedure?
Private Sub JobNumberBeforeUpdate(Cancel As Integer) If IsNull(Me.JobNumber) = True Then MsgBox 'No Job Number Entered' Cancel = True End If End Sub - Message posted via AccessMonster.com 'Haggr1 via AccessMonster.com' wrote in news:74fa8171f7137@uwe: Can anyone see what might be wrong withthis procedure? Private Sub JobNumberBeforeUpdate(Cancel As Integer) If IsNull(Me.Job.
How do I convert text case in the same colum or row. At the moment I use UPPER, but have to create a new column/row. You may find this to be handy Sub ChangeCase 'Don Guillett Application.ScreenUpdating = False Dim r As Range nCase = UCase(InputBox('Enter U for UPPER' & Chr$(13) & ' L for lower' & Chr$(13) & ' Or ' & Chr$(13) & ' P for Proper', 'Select Case Desired')) Select Case nCase Case 'L' For Each r In Selection.Cells If r.HasFormula Then r.Formula = LCase(r.Formul.
Does anyone know how to fix this? Shari wrote: Does anyone know how to fix this? Are you editing text on the Master page? - John Inzer MS Picture It!
- Digital Image MVP Digital Image Highlights and FAQs Notice This is not tech support I am a volunteer Solutions that work for me may not work for you Proceed at your own risk Yes, I thinnk so.:-) I'm not on the background. It's an 8 pg brochure I'm creating and it didn't do it before I added page 8. Front page will not have a Next Edition.
AFAIK it is dead. Ed Bennett wrote: Ron Hagley wrote: I have a document with Headings on one line followed by a linespace then on a new line a subheading followed by (on the same line ) a description I wish to use TEXT STYLES as this pattern repeats many times, I have no problem seting up the styles for the headings, but when I do the same for the SUBHEADINGS the text style is applied to the WHOLE line including the description. Peo + Julie Many thanks for your answer with the last query. I Have a similar question, please advise: This method INDIRECT does work with values form a different spreadsheet. I type the link (as text) from a different spreadsheet in a cell in the current spreadsheet and use this method to call a value in a cell. Would appreciate a detailed answer (if complicated) - I'm a novice user!
Many thanks in advance. Can anyone provide insight into how Excel treats this type of test? For example, why does Excel return TRUE when we have ='a'2 but FALSE when ='a' Can anyone provide insight into how Excel treats this type of test? For example, why does Excel return TRUE when we have ='a'2 but FALSE when ='a'Protection didn't work) it told me to go to ToolsOptionsGeneral, and click on the box that said to password protect the workbook. As usual, this version has nothing of the sort on the General tab under Options. Why don't you get a full version if you expect full version capability? I'm at a loss.
Anne Troy www.OfficeArticles.com 'MS' wrote in message news:%[email protected]. Office(publisher) 2K.
Is there anyway to rotate a specific word in a sentence? Thanks for the info. 'JoAnn Paules MSFT MVP' wrote in message news:U46dnd7PfZ5CTBHenZ2dnUVZsidnZ2d@suscom. Whenever I add a CRecordset derived class, I get an error telling me the password for the DB is sent in 'plain text' and is not secure etc. I comment that line out, but how much of a security risk is this? What can I do with my Access database to avoid this? VC 6.0 never gave this error.
Tia b If you are on any kind of network that anyone can look at, you are wide open for attack. Example, a University network; potentially, ever student can be running a packet sniffer and see your password. Anything that passes acros the Internet outside your local intranet is also vuln. Hi All, I have a combo box that will not let me select the items using my mouse. I can use the Arrow Down Key and then hit TAB to select the item.
The only thing that I think may be causing this is the ROW source. I have this change depending on the company location.
See Code that fires when the user select the Customer ID. The 3rd line from the bottom sets the ROW source for the item. The combo box is bound to a feild called ITEM. Maybe this should be unbound. Can anyone help?
Thanks Private Sub CustIDAfterUpdate Dim stFilter As String Dim stEmp As String Dim stCoNum A. I would like to place white text within a box of gray shading. When I use the 'background' function, it shades the entire document. How do I limit the background to a line of text? Thanks Ken Depending on your preference I can think of at least 3 ways, but they all may not be available to you. Or instructions may vary. It depends on what version of Word you're using & you haven't even indicated whether it's Windows or Mac.
Since you posted to the Mac Word group I'll assume you're using a Mac version & further that it is the most current (2008). Hi, Dear All We can use Ctrl key and mouse to multi-select range in a document, but if somebody could tell me how to get the text of each selection? Osen Sorry, it is not really possible. See The closest you can come is to use Selection.Copy, then open a new blank document and paste. The individual pieces will be separated by paragraph marks, but you can't distinguish between those and any paragraph marks that might have been in the middle of some pieces.
Regards, Jay Freedman Microsoft Word MVP FA. Hi, I would like to know how can i change the default icon of my dialog box? I don't find anywhere a setting for that. Tia, Maileen 'Maileen' wrote in message news:%[email protected]. HiI would like to know how can i change the default icon of my dialog box? I don't find anywhere a setting for that.
tia, See if using WMSETICON or CWnd::SetIcon is the solution. Jeff Partch VC MVP. Hello, Here is my VBA, but does not work for text search in my textbox search. Private Sub TxtcariAfterUpdate Dim strSQL As String strFilter = '(Nota LIKE ' & '.'
& Me.Txtcari & '.' & ')' Me.Filter = strFilter Me.FilterOn = True CurrentDb.Execute strSQL, dbFailOnError End Sub Thanks in advance for your help. Frank Situmorang You've declared strSQL, and you attempt to use its content with the Execute method, but you haven't assigned anything to it. Doug Steele, Microsoft Access M.
I have a workbook that charts the progress of my clients. One of m cells automatically determines their age, and when they become olde than six, I need another cell's text to automatically change to 'AO (standing for 'Aged Out' of my program).
I cannot us the functio =IF(A16,'AO',' ') because I already have the clients status imputed i that cell. I need it to be a type of conditional formatting or VB cod so that it will automatically change once the reach 6. I have attache an example of my workbook.
It has a VB code that changes the row colo based on. Hi I am doing a staight comparisions of two numbers in two different cells (a percentage increase) However one of the numbers I am using has an asterisk on the left hand end of the number.
Obviously excel cannot calculate the increase given it is not redaing the cell as a number. How can I right a formula so that excell does not read the asterisk rather only the number any help would be appreciated Hi Matt! You could set up an extra column to the right of the offending numbers and use: Data Text to Columns Or you could set up and extra column and parse the offending numbers.