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. Formatting text. Formatted text can emphasize important information and help organize your document. In Word, you have several options for adjusting the font of your text, including size, color, and inserting special symbols. You can also adjust the alignment of the text to change how it is displayed on the page. (Note: This answer is long because it contains two sets of instructions: One for Word 2007 and one for previous versions.) In Word versions prior to Word 2007: 1. Click in an affected paragraph. Click on the Format-Styles and Formatting menu item. Step 1 − Select a portion of the text using any of the text selection methods. Step 2 − Now take your mouse pointer over the selected text and hold the left button of the mouse and keep holding it while moving around the document. If you're creating a brochure or cover page for a business document, you might want to use Microsoft Word 2010 to align your text vertically. In Word 2010, you can vertically align text at the top.
- How To Center Text On A Page In Word 2010 Pdf
- How To Center Text On A Page In Word 2010 Document
- Center Text On Page In Word 2016
This resource is designed to be printed as a one page PDF file. An HTML version is also available below.
Headings
Create a uniform heading structure through use of styles in Word. This allows screen readers to navigate a document, and improves accessibility for everyone.
Adding and Editing Headings
Headings can be created using the Styles toolbar.
- Select the text and click on the appropriate style (e.g. “Heading 1”).
- Headings 1, 2, or 3 can also be assigned using Ctrl + Alt + 1, 2, or 3, respectively.
Alternative Text for Images
Images can be given appropriate alternative text in Word. This Alt text is read by a screen reader in a Word file and should remain intact when exporting to HTML or PDF.
Word 2007
- Right-click on the image and select Size. A dialog box will appear.
- Select the Alt Text tab, and replace the filename with appropriate alternative text.
Word 2010
- Right-click on the image and select Format Picture. A dialog box will appear.
- Select the Alt Text tab on the sidebar. Enter appropriate Alt text to the Description field, not the Title field.
Columns
When creating columns, always use true columns, not columns created by hand with the Tab key.
Creating Columns
- Select Page Layout on the Ribbon.
- Select Columns in the Page Setup group.
Data Tables
- Use the Insert Table command to create tables, not by hand with spaces or the Tab key.
- There is no way to easily create table headers in Word.
- The first row can be identified as table headers in PDF (but not in HTML). To do this, Right click on the first row in the table and select Table Properties > Row > Repeat as header row at the top of each page.
Links
Word automatically creates a hyperlink when a user pastes a full URL onto a page. These may not make sense to screen reader users, so more information is needed.
Editing Hyperlinks
- Select a hyperlink, right click, and select Edit Hyperlink or Ctrl + k.
- Change the text in the Text to Display field to a more meaningful description.
Lists
Use true numbered and bulleted lists to emphasize a point or a sequence of steps.
Creating Lists
- Select Page Layout on the Ribbon.
- Select Bullets and Numbering.
Word 2010 Accessibility Checker
How To Center Text On A Page In Word 2010 Pdf
Word 2010 includes an accessibility resource that identifies and repairs accessibility issues.
Running the Accessibility Checker
How To Center Text On A Page In Word 2010 Document
- Select File > Info > Check for Issues > Check Accessibility.
- The checker presents accessibility errors, warnings, and tips on how to repair the errors.
Other Principles
- Ensure that font size is sufficient, around 12 points.
- Provide sufficient contrast.
- Don’t use color as the only way to convey content.
- Provide a table of contents, especially for long documents.
- Use simple language.
Center Text On Page In Word 2016
Made possible by a grant from the Fund for the Improvement of Postsecondary Education (FIPSE), US Department of Education. No official endorsement implied.
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 -CPL@discussions.microsoft.com> 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' <Muechel@gmx.at> skrev i en meddelelsenews:OoiTIMa6DHA.2524@TK2MSFTNGP11.phx.gbl...> 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' <wjsmatt@discussions.microsoft.com> wrote in message news:739E7094-EB92-4B15-BC2C-7B640A7FD108@microsoft.com...> ...
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' <jessica.w@zimshipping.com> wrote in messagenews:1E804A58-662A-47BA-B264-9EEE8A20994F@microsoft.com...> 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 -CPL@discussions.microsoft.com> 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' <Muechel@gmx.at> skrev i en meddelelsenews:OoiTIMa6DHA.2524@TK2MSFTNGP11.phx.gbl...> 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' <wjsmatt@discussions.microsoft.com> wrote in message news:739E7094-EB92-4B15-BC2C-7B640A7FD108@microsoft.com...> ...
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' <jessica.w@zimshipping.com> wrote in messagenews:1E804A58-662A-47BA-B264-9EEE8A20994F@microsoft.com...> 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 ...