The Wiert Corner – irregular stream of stuff

Jeroen W. Pluimers on .NET, C#, Delphi, databases, and personal interests

  • My badges

  • Twitter Updates

  • My Flickr Stream

  • Pages

  • All categories

  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 2,466 other followers

Archive for the ‘Office 2013’ Category

Winword: parts of the document with numbered, but other parts (Table of Contents, Summary) without numbering

Posted by jpluimers on 2021/06/11

Steps to have only the body parts of your Winword document Heading 1 numbered, but parts like Summary and Table of Contents without numbering.

Related:

Steps:

  1. Create a document with
    • some paragraphs of body text, intertwined with:
      • some paragraphs that should become numbered headings,
      • some paragraphs that should become non-numbered headings
      • room for a table of context
  2. Go to the “Styles” popup (keyboard shortcut Ctrl+Shift+Alt+S, or ribbon “Home” -> section “Styles” -> small button on the lower right of the ribbon section
  3. For each paragraph that should become a heading, apply style “Heading 1” (you can also use keyboard shortcut Ctrl+Alt+1 for this)
  4. Modify the various heading levels so they become numbered: see [WayBack] How to create numbered headings or outline numbering in Word 2007 and Word 2010 | ShaunaKelly.com. I prefer the hierarchical numbered multilevel list without the numbers being indented for the body text, but with indented numbers in the Table of Contents, so lets go.
    1. Start with the stock multi-leveled list definition:
      1. Change from “None” to the multi-level one:
      2. Now create a new one based on it:
        1. “Define New List Style…”:
        2. Rename from “Style1” to “Heading
    2. This involves creating a new list style called “Headings”, based on the numbered list style you like
      • ).
    3. Since by default, these bind to all levels, your document styles “Heading 1”..”Heading 9″ are covered. If for one or more styles, you do not want numbering, see below how to fix that (I do that for a “Heading 1 – no-numbering” style used for the “Summary” heading, and for the “TOC Heading” style.
  5. Mark the “Summary” heading as a new style “Heading 1 – non-numbered”:
    1. Press Ctrl+Shift+S to get to the “Apply Styles” 
    2. Enter the new name “Heading 1 – non-numbered” and press the “New” button: 
    3. Press the “Modify” button 
    4. to view the current style
    5. Press “Format” ->     
    6. Change it from “None” to “None” and press “OK”
    7.  Observe the numbering is gone:
    8. Unlike the “Heading 1” style, the “Style for following paragraphs” is wrong: it needs to be
    9. Now we are done, so press the “OK” button:
    10. Then observe the first numbered “Heading 1” now has got the number “1” instead of the “Summary”:
  6. Insert a “Table of Contents”, for instance after the “Summary”
    1. You might think it will start with a heading “Table of Contents”:
    2. Im some localisations of office, it is prepended with a “1.” and becomes “1. Table of Contents”. If it does, then you have to change style “TOC Heading” and undo the numbering as done with “Heading 1 – non-numbering” by pressing Ctrl+Shift+S when you are in the “Table of Contents” heading:
    3. From there, press the “Modify” button and continue as done with “Heading 1 – non-numbering”:

–jeroen

Posted in Office, Office 2007, Office 2010, Office 2013, Office 2016, Power User, Word | Leave a Comment »

Random, Quick Brown Fox and Lorem Ipsum – How to Add Filler Text in Microsoft Word Documents

Posted by jpluimers on 2021/06/07

Choices:

  • =lorem(...): Ramdom Lorem Ipsum text paragraphs.
    • The sentences are roughly between 0.25 and 1.0 document widths in length.
  • =rand(...): Random English help text like paragraphs.
    • The sentences are roughly between 0.5 and 1.5 document width in length.
  • =rand.old(...): “The quick brown fox jumps over the lazy dog.” paragraphs (up until Word 2003, this was what rand(...) returned).
    • The sentences are always the same length.

(...) parameters:

  • (x,y): x paragraphs of y sentences of text
  • (y): y paragraphs of 3 sentences of text (lorem more towards 1, rand more towards 3)
  • (): depends on the function:
    • =lorem(): 5 paragraphs of 3 sentences of text
    • =rand(): 5 paragraphs of 3 sentences of text
    • =rand.old(): 3 paragraphs of 3 sentences of text

Note:

  • There is no way to specify x paragraphs of random number lines of text.
  • They need to have “Replace text as you type” enabled (see menu option “File” -> “Options” -> “Proofing” -> “Autocorrect Options”)
  • Word 2003 and lower only have =rand(...)

Based on:

Related: [WayBack] 10 awesome Lorem Ipsum alternatives – Justinmind via [WayBack] rand () in word – Microsoft Tech Community – 325554

For a random document demo, I usually do this:

  1. =lorem(100,1) to get 100 paragraphs of 1 line of text
  2. About every 10 paragraphs, I mark a paragraph with a relevant Heading style
  3. Inside the remaining text, I combine some paragraphs to get longer ones

–jeroen

Posted in Office, Office 2003, Office 2007, Office 2010, Office 2013, Office 2016, Power User, Word | Leave a Comment »

Office 2013 Proofing tools downloads

Posted by jpluimers on 2021/03/05

For my link archive:

Via:

Posted in Office, Office 2013, Power User, Word | Leave a Comment »

Excel formula: SUMIFS with multiple criteria and OR logic | Exceljet

Posted by jpluimers on 2020/03/31

As I need this one day:

To sum based on multiple criteria using OR logic, you can use the SUMIFS function with an array constant. In the example shown, the formula in H6 is:

=SUM(SUMIFS(E4:E11,D4:D11,{"complete","pending"}))

Source: [WayBackExcel formula: SUMIFS with multiple criteria and OR logic | Exceljet

–jeroen

Posted in Development, Excel, Office, Office 2011 for Mac, Office 2013, Office 2016, Power User, Software Development | Leave a Comment »

Excel: printing top row on every page, and including grid

Posted by jpluimers on 2019/06/28

I hardly print with Excel, so I always forget these two:

–jeroen

Posted in Excel, Office, Office 2011 for Mac, Office 2013, Power User | Leave a Comment »

 
%d bloggers like this: