- How To Remove Blank Page In Word
- How To Center Text On A Page In Word 2010
- How To Delete Multiple Pages In Word
Home > Sample chapters > Microsoft Office > Word
- By Joan Lambert and Joyce Cox
- 6/2/2010
For emphasis, you may wish to raise or lower certain text inside your Microsoft Word 2003 documents. While you can raise whole blocks of text, it may make sense to raise or lower certain words or phrases inside a paragraph. Highight the word(s) you want to raise or lower. I recently bought a new computer and also bought a new version of Word (MS Word 2010). I installed Word 2010 on my new computer last week and immediately noticed that the page was distractingly lopsided, with the white page all the way to the left of the screen, filling about 30% of my monitor, and blank gray space filling the other 70% to the. Align text left or right in Microsoft Word. In Word, if you want to align some text, first select it. First you center it horizontally by selecting the test you want. Then on the HOME tab, Paragraph group, click Center. The second step is to select the text. On the Page Layout tab, click the Page Setup Dialog Box Launcher, and click the Layout tab. In the Vertical alaignment box, click Center. In the Apply to box, click Selected text and then.
×How To Remove Blank Page In Word
- Creating Diagrams
In this chapter from Microsoft Word 2010 Step by Step, you’ll insert a diagram into a document and specify its size and position. Then you’ll change the diagram’s layout, visual style, and color theme. Finally, you’ll see how to use a diagram to arrange pictures in a document.
Chapter at a Glance
Diagrams are graphics that convey information. Business documents often include diagrams to clarify concepts, describe processes, and show hierarchical relationships. Microsoft Word 2010 comes with a powerful diagramming tool called SmartArt that you can use to create diagrams directly in your documents. By using ready-made diagram templates, you can produce sophisticated results tailored to your needs.
In this chapter, you’ll insert a diagram into a document and specify its size and position. Then you’ll change the diagram’s layout, visual style, and color theme. Finally, you’ll see how to use a diagram to arrange pictures in a document.
Creating Diagrams
When you need your document to clearly illustrate a concept such as a process, cycle, hierarchy, or relationship, the powerful SmartArt Graphics tool is available to help you create a dynamic, visually appealing diagram. By using predefined sets of sophisticated formatting, you can almost effortlessly put together any of the following diagrams:
- List. These diagrams visually represent lists of related or independent information—for example, a list of items needed to complete a task, including pictures of the items.
- Process. These diagrams visually describe the ordered set of steps required to complete a task—for example, the steps for getting a project approved.
- Cycle. These diagrams represent a circular sequence of steps, tasks, or events, or the relationship of a set of steps, tasks, or events to a central, core element—for example, the looping process for continually improving a product based on customer feedback.
- Hierarchy. These diagrams illustrate the structure of an organization or entity—for example, the top-level management structure of a company.
- Relationship. These diagrams show convergent, divergent, overlapping, merging, or containment elements—for example, how using similar methods to organize your e-mail, calendar, and contacts can improve your productivity.
- Matrix. These diagrams show the relationship of components to a whole—for example, the product teams in a department.
- Pyramid. These diagrams illustrate proportional or interconnected relationships—for example, the amount of time that should ideally be spent on different phases of a project.
- Picture. These diagrams rely on pictures instead of text to create one of the other types of diagrams—for example, a process picture diagram with photographs showing the recession of glaciers in Glacier National Park.
You select the type of diagram you want to create from the Choose A SmartArt Graphic dialog box. The categories are not mutually exclusive, meaning that some diagrams appear in more than one category.
After creating the diagram, you insert text by typing either directly in its shapes or in the associated Text pane. Depending on the diagram type, the text appears in or adjacent to its shapes.
In this exercise, you’ll create a diagram, add text, adjust its size, and specify its position in relation to the document text and page margins.
- Click to the left of the Gather information heading, and then on the Insert tab, in the Illustrations group, click the SmartArt button.The Choose A SmartArt Graphic dialog box opens, displaying all the available graphics.
- In the left pane, click each diagram category in turn to display only the available layouts of that type in the center pane.
- In the left pane, click Process. Then in the center pane, click each process diagram layout in turn to view an example, along with a description of what the diagram best conveys, in the right pane.
- When you finish exploring, click the third thumbnail in the sixth row (Vertical Process), and then click OK.The process diagram is inserted at the cursor, and the Design and Format contextual tabs are displayed on the ribbon.Three text placeholders appear in the diagram shapes and in the adjacent Text pane, where the text placeholders are formatted as a bulleted list.Depending on your screen resolution, you might see a description of the Vertical Process diagram at the bottom of the Text pane. If your Text pane looks like the one in our graphic, you can click Vertical Process to display the description.
- With the first bullet selected in the Text pane, type Gather information, and then press the Down Arrow key to move the cursor to the next placeholder.As you type in the Text pane, the words also appear in the corresponding shape in the diagram.
- Repeat step 5 for the remaining two placeholders, entering Set up team and Plan project.
- With the cursor at the end of the third bulleted item in the Text pane, press Enter to extend the bulleted list and add a new shape to the diagram. Then type Meet with department.The widths of the shapes in the diagram adjust to accommodate the length of the bullet point you just typed.You can add as many shapes as you need.
- In the Text pane, click the Close button.
- On the left side of the diagram frame, point to the sizing handle (the four dots), and when the pointer changes to a double-headed arrow, drag to the right past the diagram and into the white space, until the frame is approximately as wide as the shapes within the diagram.
- If you can’t see the diagram after you release the mouse button, scroll up in the document.The diagram now sits at the left margin of the document, with the Gather information heading to its right.The diagram is anchored to the Gather information heading and moves with it.
- On the Format contextual tab, in the Arrange group, click the Wrap Text button, and then in the gallery, click Square.
- In the Arrange group, click the Position button, and then at the bottom of the gallery, click More Layout Options.The Layout dialog box opens with the Position page displayed. On this page are options for controlling where the diagram appears relative to other elements of the document.
- In the Horizontal area, click Alignment. Then click the Alignment arrow, and in the list, click Right.
- In the Vertical area, click Alignment. Leave the Alignment setting as Top, and then change the relative to setting to Line.
- Click OK.Instead of sitting at the left margin with text before and after it, the diagram now sits to the right of the text, without interrupting its flow.
- In the lower-left corner of the diagram frame, point to the sizing handle. When the pointer changes to a diagonal double-headed arrow, drag up and to the right until the bottom of the diagram frame sits level with the last line of text in the Community Service Committee paragraph.
- Click a blank area of the document.The diagram now sits neatly to the right of the introductory text.You can align and size the diagram to fit your text.
Page 1 of 4Next
This chapter is from the book
![How How](/uploads/1/3/4/4/134409289/737851749.jpg)
Related resources
How To Center Text On A Page In Word 2010
- By Joan Lambert
- Book $24.99
- By Joan Lambert
- eBook (Watermarked) $19.99
- By Paul McFedries
- Book $24.99
How To Delete Multiple Pages In Word
logging to text file and opening at end of program
Hi, I'm using a utility class to provide debugging notes during program run to see where things are happening. ....in class Util.vb..... Public Sub Logentry(ByVal strMsg As String) If m_Debug Then File.AppendAllText(m_DebugFileName, strMsg + Environment.NewLine) End If End Sub Sub OpenDebugLog() Process.Start(m_DebugFileName) End Sub .............................. then in program call logentry at points of interest... at end of program call OpenDebugLog ....in file program.vb... Protected Overrides Sub Finalize() m_util.OpenDebugLog() m_u...
How do I save multiple messages as text file?
When I select multiple messages -> file -> save as text file.Only the headers of the messages are saved and not the bodies.In Outlook 2003, how do I save the bodies also?Thanks....
Text over a picture
I am trying to put text over a picture. The picture is in place, then I put a text frame over it. The ' fill' covers up the picture and I can't figure out how to make the text over the picture, but still see all the picture . It is a black and white picture and the letters are going over a black part so I was the text white so it shows up, but I can't figure out how to do it. Basically in the end I am trying to make the picture look like a watermark behind the text. Help! What format is the picture?The text box can be made transparent, select the box, ctrl + t....
Multiple Numbers on ONE Label
I have several thousand labels I need to print. I would like to put up to 4 part numbers on each label (Avery 5164). These labels will placed on boxes that hold product. Some labels may only get 2 or 3 part numbers per label depending on size of the part. My part numbers are classified as S,M,L. Can this be done? Example... ABC123 - small ABC234 - large (max 2 numbers per label) ABC345 - small ABC456 - med (max 3 numbers per label) BCD123 - small BCD234 See: Print a Quantity of a Label at: http://allenbrowne.com/ser-39.html The article assumes you have a Q...
Auto fill text columns based on rows
I'm trying to fill in Column A based on the info. listed in the first row for a section. For example, column A would list Store 1 until it hit Store 2 and then repeat until the next section. Any ideas on how to do this?? Thanks!!! Column A Column B Store Detail Competitors Store 1 Store 1 Detail Comp 1 Store 1 Detail Comp 2 Store 1 Detail Comp 3 Store 1 Detail Comp 4 Store 4 Store 4 Detail Comp 1 Store 4 Detail Comp 2 Store 4 Detail C...
widows media centers tv
I have installed a tv card that actually came with the computer. Some german name haupp something. It used to work, now it doesn't. The media center tells me that it is a hardware failure, but I doubt that. How can I reinstall media center? ...
Outlook & Word XP: How do I print labels for Christmas cards?!
I get some incredibly frustrated with MS Word & Outlook sometimes!Especially when it comes to trying and make it print a bunch of labels forme, for addressing Christmas cards. According to the online help I canstart in Outlook's Contacts and select those I want to send messages to.Fine. I've done that.Now what?! The instructions don't say, and I just can't lay my head on thekeyboard and hope to learn what I'm supposed to do next. I suppose theonline help could help, but I don't know what the 'correct' key words wouldbe, so I cannot enter the k...
Printing labels for an Assembly item
RMS 2.0 - We've created and Assembly item that includes two separate pieces to be sold together. We want to be able to sell these items as one piece, but need to order them as separate pieces.When we sell the one piece, we need the inventory to detract from each item quantity separately.We've set up an Assembly item to do this.But, now we cannot figure out how to print a barcode label for the Assembly item set up. Is there a way to do this? Nope. RMS cannot print a label for an assembly item.I wish I had better news, but that's the facts.Pathetic, but true.You...
vlookup multiple text rows
I am using the vlookup function to auto populate a template. The area that i have a problem with is i have multiple rows of text that belong to the same lookup reference. I need all those rows of text to populate the field and currently it is only taking the last line. I am not sure if I can do some sort of formula to concatenate those rows based on the lookup value. Saved from a previous post:How about a UserDefined Function?Option ExplicitFunction mvlookup2(lookupValue, tableArray As Range, colIndexNum As Long, _ Optional NotUsed As Variant) As Variant Dim in...
Exchange Server 2003 SP1
I am getting them in the MDB Data directory, in the old ver of exchange server I used to delete these when I ran eseutil.Now I don't need to run eseutil for maintenance so can I still delete these text files?Names are : E00047A0 all 5,120kb, look like old outputs but are all modified today.Any advice would be welcome as they are taking up 17Gb at this stage? Run a full, online Exch aware backup to clear your trans logs.Never delete them manually.On Mon, 8 Nov 2004 12:23:02 -0800, Ciaran Magee - CPL <Ciaran Magee [email protected]> wrote:>I am getting t...
Finding text within text
Hello again,I've gotten the formula for finding occurrences of a word in onecolumn based on whether it's in another column; now what I need is tofind out whether a word in column A (for instance) appears in a stringof text in column B. As in, a SKU in A, and a description in B, withthe descriptions having several SKUs in each one. I need to be ableto delete from a sheet any description that doesn't have the SKUs I'mlooking for, and it would be really nice to color the correspondingcells the same, but even having the row number in the third row wouldbe nice. Say I...
Text on a Circle Tool
Hello Newsgroup!Over the years, I've seen numerouse requests for adding text to curved paths. While this isn't part of Visio's core features, it can be simulated with some automation code and ShapeSheet wizardry. I've posted the first version of a tool that helps you to put text on a circular path. Have a look and enjoy!Circular Text Generator (version 1):http://www.visguy.com/2007/10/18/circular-text-generator-version-1/Note 'version 1'. We'll be updating this over the coming months to add more features, so check back once in awhile!-- Hope this hel...
How do I set Excel cell format to 'Text' from VB.NET?
I am creating an Excel workbook using VB.NET, and have run into aproblem. Excel at times insists on reformatting data that I enterinto cells, e.g., converting '01234' to '1234', and this screws meup when I need to read the data back. When I run into this problemusing Excel interactively I simply change the cell Number formatfrom 'General' to 'Text', but I haven't been able to figure outhow to do this using VB.NET. Here is a code sample: Dim wb as Microsoft.Office.Interop.Excel.Workbook [...workbook is created...] Dim style as Microsoft...
center-center text in a table
In microsoft word I can format the text center-center, or center-left, or center-right, ... in a table. But can publisher do so? If Yes, how am I going to accomplish this. Sure can!Right Click > Format Table-- 'If you don't know where you are going,any road will take you there!'...
Replace text for selected cells only
Is it possible to select specific cells and then have the Replace feature only apply to those cells, particularly if I use the Replace-All button? That's the way it works.Are you experiencing something different?(one tip. Don't hit the Find all button. If you notice, your selection is lostwhen you do that.)Hall wrote:> > Is it possible to select specific cells and then have the Replace feature> only apply to those cells, particularly if I use the Replace-All button?-- Dave Peterson Selecting only one cell, and Excel will try to Replace throughout the whole...
Excel 07 3D Column data label alignment
Hello,I have a 3-D Column graph made in Excel 2007. I turn on the data labels and try to place them in the middle of the column but the only way I can do this is manualy one data label at a time. If Right-Click on a data label > Format Data Labels > Alignment and change Vertical alignment nothing happens. Text direction and Angle work fine just not Vertical Alignment. How do I place all data labels to be in the middle of the columns without having to drag each and every one to the middle of it's column?Cheers, Hi,Only way to get the data labels in the center of the c...
Dynamic Text Fields
Can publisher be linked to a database?Let's say I have some research article that needs to be constantly updated (weekly). 90% remains the same for the text, but numbers change. I need it to link to some sort of data source where my data & % changes updates automatically.The only text change would be something like Decrease/Increase, stronger/weaker, better/worse, etc.What software do you recommend for this? Do you think a reporting tool would be more appropriate?Please advise.Derik...
Selecting cells that contain text in a specific format
Hi all,I have a list of clients who are extracted from access but I need tochange the saluation from the clients initials to Sir/Madam.For ExampleSurname Firstname Salutation-------------------------------------------Smith G Sir/MadamAndrews A B Sir/MadamGreen R C L Sir/MadamJones Mary MaryInitially, I was just going to highlight any entries in the firstnamecolumn that contained a space give the a value of true which wouldchange the saluation to Sir/Madam. However this does not take into...
File Folder Labels
Using Windows XP and Office 2007 Using Avery Label template 5167. When I type the label information in anything larger than 9 point, a blank line is inserted above the first line of the label which makes the second line of text print off the bottom of the label. I have made sure there is 'no space before or after' in the paragraph dialog box. The file folder label always has 2 lines of text and will only fit on the label in a 9 point font. Any ideas what's going on?? Make sure that Line Spacing is set to single. If that's OK, try using a different ...
grayed text
does anybody know how to draw a grayed 3d text like disabling acontrol?-- kind regards, muechel 'M�chel' <[email protected]> skrev i en meddelelsenews:[email protected]...> does anybody know how to draw a grayed 3d text like disabling a> control?> -- > kind regards, muechel>You will have to owner draw it, but of course you knew that :-)The way I have seen it done, is to first write the text with the light graycolor. Then select the dark gray color and write the text again, but offsetone pixel to the left and one pixel up. Rememb...
text in metafiles
My text on-screen and printed looks fine, but if I save a metafile picture and import it into Microsoft Word, then Word will scale the picture. So my 10 point fonts become 5 point (say). When printed from MSWord, the picture has text with poor horizontal spacing between individual characters. This seems to be particularly noticeable with bold fonts.Sometimes I'm using CDC:DrawText and sometimes CDC:ExtTextOut. Both cases have this problem.What issues am I unaware of? What steps (if any) can I take to avoid this?many thanksSteve...
Gathering open-ended question text into one sheet
I have an Excel file with data from 60 or so respondents to a questionaire. I have all my raw data on one worksheet. On another worksheet I have totals for the various questions broken out in various ways. I would like to create another worksheet that lists the answers to an open-ended question at the end of the questionaire. Less than half of the people responding wrote comments so I don't want to include blanks. I'd like to have a consolidated list of the comments in a tidy, separate sheet.As yet, I've been unable to figure out how to do this. Any help would be app...
Want to use left and center footer in same page
Enter the left footer text in the left footer box, and the center footer text in the center footer box (and use the right footer too, if you want).- Jon-------Jon Peltier, Microsoft Excel MVPPeltier Technical ServicesTutorials and Custom Solutionshttp://PeltierTech.com/_______'wjs-matt' <[email protected]> wrote in message news:[email protected]...> ...
Counting text cells #3
I have a range of cells A25:A256 that contain text entries of various types (doesn't matter). How do I get it in cell A258 to give me a total of cells that have text in them within that range 25:256Thanks, GurusJessica =SUMPRODUCT(--(ISTEXT(A25:A256)))-- Regards,Peo Sjoblom'Jessica Walton' <[email protected]> wrote in messagenews:[email protected]...> I have a range of cells A25:A256 that contain text entries of varioustypes (doesn't matter). How do I get it in cell A258 to give me a total ofcells that have ...
Outlook 2007 Autocorrect with formatted text
I need to know how to enable Outlook to replace autocorrect entries with formatted text. In Word 2007, its as simple as clicking the radio button to enable it. In Outlook however, not so much. Here is what I am trying to accomplish -- this worked two weeks ago before my hard drive died, however, I can't remember how to recreate it. I enter my initials and autocorrect formats a signature with contact information. The path, Tools, Options, Spelling, Spelling, Spelling and Autocorrect Options, Autocorrect Options --- however, the 'Formatted text' radio button is ...
Hi, I'm using a utility class to provide debugging notes during program run to see where things are happening. ....in class Util.vb..... Public Sub Logentry(ByVal strMsg As String) If m_Debug Then File.AppendAllText(m_DebugFileName, strMsg + Environment.NewLine) End If End Sub Sub OpenDebugLog() Process.Start(m_DebugFileName) End Sub .............................. then in program call logentry at points of interest... at end of program call OpenDebugLog ....in file program.vb... Protected Overrides Sub Finalize() m_util.OpenDebugLog() m_u...
How do I save multiple messages as text file?
When I select multiple messages -> file -> save as text file.Only the headers of the messages are saved and not the bodies.In Outlook 2003, how do I save the bodies also?Thanks....
Text over a picture
I am trying to put text over a picture. The picture is in place, then I put a text frame over it. The ' fill' covers up the picture and I can't figure out how to make the text over the picture, but still see all the picture . It is a black and white picture and the letters are going over a black part so I was the text white so it shows up, but I can't figure out how to do it. Basically in the end I am trying to make the picture look like a watermark behind the text. Help! What format is the picture?The text box can be made transparent, select the box, ctrl + t....
Multiple Numbers on ONE Label
I have several thousand labels I need to print. I would like to put up to 4 part numbers on each label (Avery 5164). These labels will placed on boxes that hold product. Some labels may only get 2 or 3 part numbers per label depending on size of the part. My part numbers are classified as S,M,L. Can this be done? Example... ABC123 - small ABC234 - large (max 2 numbers per label) ABC345 - small ABC456 - med (max 3 numbers per label) BCD123 - small BCD234 See: Print a Quantity of a Label at: http://allenbrowne.com/ser-39.html The article assumes you have a Q...
Auto fill text columns based on rows
I'm trying to fill in Column A based on the info. listed in the first row for a section. For example, column A would list Store 1 until it hit Store 2 and then repeat until the next section. Any ideas on how to do this?? Thanks!!! Column A Column B Store Detail Competitors Store 1 Store 1 Detail Comp 1 Store 1 Detail Comp 2 Store 1 Detail Comp 3 Store 1 Detail Comp 4 Store 4 Store 4 Detail Comp 1 Store 4 Detail Comp 2 Store 4 Detail C...
widows media centers tv
I have installed a tv card that actually came with the computer. Some german name haupp something. It used to work, now it doesn't. The media center tells me that it is a hardware failure, but I doubt that. How can I reinstall media center? ...
Outlook & Word XP: How do I print labels for Christmas cards?!
I get some incredibly frustrated with MS Word & Outlook sometimes!Especially when it comes to trying and make it print a bunch of labels forme, for addressing Christmas cards. According to the online help I canstart in Outlook's Contacts and select those I want to send messages to.Fine. I've done that.Now what?! The instructions don't say, and I just can't lay my head on thekeyboard and hope to learn what I'm supposed to do next. I suppose theonline help could help, but I don't know what the 'correct' key words wouldbe, so I cannot enter the k...
Printing labels for an Assembly item
RMS 2.0 - We've created and Assembly item that includes two separate pieces to be sold together. We want to be able to sell these items as one piece, but need to order them as separate pieces.When we sell the one piece, we need the inventory to detract from each item quantity separately.We've set up an Assembly item to do this.But, now we cannot figure out how to print a barcode label for the Assembly item set up. Is there a way to do this? Nope. RMS cannot print a label for an assembly item.I wish I had better news, but that's the facts.Pathetic, but true.You...
vlookup multiple text rows
I am using the vlookup function to auto populate a template. The area that i have a problem with is i have multiple rows of text that belong to the same lookup reference. I need all those rows of text to populate the field and currently it is only taking the last line. I am not sure if I can do some sort of formula to concatenate those rows based on the lookup value. Saved from a previous post:How about a UserDefined Function?Option ExplicitFunction mvlookup2(lookupValue, tableArray As Range, colIndexNum As Long, _ Optional NotUsed As Variant) As Variant Dim in...
Exchange Server 2003 SP1
I am getting them in the MDB Data directory, in the old ver of exchange server I used to delete these when I ran eseutil.Now I don't need to run eseutil for maintenance so can I still delete these text files?Names are : E00047A0 all 5,120kb, look like old outputs but are all modified today.Any advice would be welcome as they are taking up 17Gb at this stage? Run a full, online Exch aware backup to clear your trans logs.Never delete them manually.On Mon, 8 Nov 2004 12:23:02 -0800, Ciaran Magee - CPL <Ciaran Magee [email protected]> wrote:>I am getting t...
Finding text within text
Hello again,I've gotten the formula for finding occurrences of a word in onecolumn based on whether it's in another column; now what I need is tofind out whether a word in column A (for instance) appears in a stringof text in column B. As in, a SKU in A, and a description in B, withthe descriptions having several SKUs in each one. I need to be ableto delete from a sheet any description that doesn't have the SKUs I'mlooking for, and it would be really nice to color the correspondingcells the same, but even having the row number in the third row wouldbe nice. Say I...
Text on a Circle Tool
Hello Newsgroup!Over the years, I've seen numerouse requests for adding text to curved paths. While this isn't part of Visio's core features, it can be simulated with some automation code and ShapeSheet wizardry. I've posted the first version of a tool that helps you to put text on a circular path. Have a look and enjoy!Circular Text Generator (version 1):http://www.visguy.com/2007/10/18/circular-text-generator-version-1/Note 'version 1'. We'll be updating this over the coming months to add more features, so check back once in awhile!-- Hope this hel...
How do I set Excel cell format to 'Text' from VB.NET?
I am creating an Excel workbook using VB.NET, and have run into aproblem. Excel at times insists on reformatting data that I enterinto cells, e.g., converting '01234' to '1234', and this screws meup when I need to read the data back. When I run into this problemusing Excel interactively I simply change the cell Number formatfrom 'General' to 'Text', but I haven't been able to figure outhow to do this using VB.NET. Here is a code sample: Dim wb as Microsoft.Office.Interop.Excel.Workbook [...workbook is created...] Dim style as Microsoft...
center-center text in a table
In microsoft word I can format the text center-center, or center-left, or center-right, ... in a table. But can publisher do so? If Yes, how am I going to accomplish this. Sure can!Right Click > Format Table-- 'If you don't know where you are going,any road will take you there!'...
Replace text for selected cells only
Is it possible to select specific cells and then have the Replace feature only apply to those cells, particularly if I use the Replace-All button? That's the way it works.Are you experiencing something different?(one tip. Don't hit the Find all button. If you notice, your selection is lostwhen you do that.)Hall wrote:> > Is it possible to select specific cells and then have the Replace feature> only apply to those cells, particularly if I use the Replace-All button?-- Dave Peterson Selecting only one cell, and Excel will try to Replace throughout the whole...
Excel 07 3D Column data label alignment
Hello,I have a 3-D Column graph made in Excel 2007. I turn on the data labels and try to place them in the middle of the column but the only way I can do this is manualy one data label at a time. If Right-Click on a data label > Format Data Labels > Alignment and change Vertical alignment nothing happens. Text direction and Angle work fine just not Vertical Alignment. How do I place all data labels to be in the middle of the columns without having to drag each and every one to the middle of it's column?Cheers, Hi,Only way to get the data labels in the center of the c...
Dynamic Text Fields
Can publisher be linked to a database?Let's say I have some research article that needs to be constantly updated (weekly). 90% remains the same for the text, but numbers change. I need it to link to some sort of data source where my data & % changes updates automatically.The only text change would be something like Decrease/Increase, stronger/weaker, better/worse, etc.What software do you recommend for this? Do you think a reporting tool would be more appropriate?Please advise.Derik...
Selecting cells that contain text in a specific format
Hi all,I have a list of clients who are extracted from access but I need tochange the saluation from the clients initials to Sir/Madam.For ExampleSurname Firstname Salutation-------------------------------------------Smith G Sir/MadamAndrews A B Sir/MadamGreen R C L Sir/MadamJones Mary MaryInitially, I was just going to highlight any entries in the firstnamecolumn that contained a space give the a value of true which wouldchange the saluation to Sir/Madam. However this does not take into...
File Folder Labels
Using Windows XP and Office 2007 Using Avery Label template 5167. When I type the label information in anything larger than 9 point, a blank line is inserted above the first line of the label which makes the second line of text print off the bottom of the label. I have made sure there is 'no space before or after' in the paragraph dialog box. The file folder label always has 2 lines of text and will only fit on the label in a 9 point font. Any ideas what's going on?? Make sure that Line Spacing is set to single. If that's OK, try using a different ...
grayed text
does anybody know how to draw a grayed 3d text like disabling acontrol?-- kind regards, muechel 'M�chel' <[email protected]> skrev i en meddelelsenews:[email protected]...> does anybody know how to draw a grayed 3d text like disabling a> control?> -- > kind regards, muechel>You will have to owner draw it, but of course you knew that :-)The way I have seen it done, is to first write the text with the light graycolor. Then select the dark gray color and write the text again, but offsetone pixel to the left and one pixel up. Rememb...
text in metafiles
My text on-screen and printed looks fine, but if I save a metafile picture and import it into Microsoft Word, then Word will scale the picture. So my 10 point fonts become 5 point (say). When printed from MSWord, the picture has text with poor horizontal spacing between individual characters. This seems to be particularly noticeable with bold fonts.Sometimes I'm using CDC:DrawText and sometimes CDC:ExtTextOut. Both cases have this problem.What issues am I unaware of? What steps (if any) can I take to avoid this?many thanksSteve...
Gathering open-ended question text into one sheet
I have an Excel file with data from 60 or so respondents to a questionaire. I have all my raw data on one worksheet. On another worksheet I have totals for the various questions broken out in various ways. I would like to create another worksheet that lists the answers to an open-ended question at the end of the questionaire. Less than half of the people responding wrote comments so I don't want to include blanks. I'd like to have a consolidated list of the comments in a tidy, separate sheet.As yet, I've been unable to figure out how to do this. Any help would be app...
Want to use left and center footer in same page
Enter the left footer text in the left footer box, and the center footer text in the center footer box (and use the right footer too, if you want).- Jon-------Jon Peltier, Microsoft Excel MVPPeltier Technical ServicesTutorials and Custom Solutionshttp://PeltierTech.com/_______'wjs-matt' <[email protected]> wrote in message news:[email protected]...> ...
Counting text cells #3
I have a range of cells A25:A256 that contain text entries of various types (doesn't matter). How do I get it in cell A258 to give me a total of cells that have text in them within that range 25:256Thanks, GurusJessica =SUMPRODUCT(--(ISTEXT(A25:A256)))-- Regards,Peo Sjoblom'Jessica Walton' <[email protected]> wrote in messagenews:[email protected]...> I have a range of cells A25:A256 that contain text entries of varioustypes (doesn't matter). How do I get it in cell A258 to give me a total ofcells that have ...
Outlook 2007 Autocorrect with formatted text
I need to know how to enable Outlook to replace autocorrect entries with formatted text. In Word 2007, its as simple as clicking the radio button to enable it. In Outlook however, not so much. Here is what I am trying to accomplish -- this worked two weeks ago before my hard drive died, however, I can't remember how to recreate it. I enter my initials and autocorrect formats a signature with contact information. The path, Tools, Options, Spelling, Spelling, Spelling and Autocorrect Options, Autocorrect Options --- however, the 'Formatted text' radio button is ...