The auto-indenting feature of bullets and lists has always frustrated me. EVERY time you apply a numbered or bulleted list, you've got to set the indents. I want my lists to be indented at the very left of the page, flush with the rest of the paragraphs. But no, Microsoft insists that you want them indented by 0.63cm and hanging at 1.27cm (WHY 0.63? Why not 0.7? Or 1.0cm? But that's a question for a different session.) (I know, it's because MS is American and still uses inches etc...)
You probably know about Word's mail merge feature, and you might even use it to print labels or other documents, where some of the information changes (such as form letters). You can use the same feature with Publisher. Although you might not think of Publisher as an Office app, it comes with several different versions of Office. In this article, I'll show you how to print sequentially numbered tickets using Publisher and Excel. This article provides instructions for Publisher 2007, 2010, and 2013.

* The solution assumes that there is only one stack to cut, but really there could be dozens of stacks. Take a run of the numbers 1-10000 for example. Let’s say you get 4-up on a sheet and the biggest stack that will fit in the guillotine is 500 sheets. A true cut and stack solution will print on the first stack 1-500, 501-1000, 1001-1500, 1501-2000. Ideal because the numbers can be guillotined and placed back onto a pallet for its next process. It also means I can provide these numbers first to the client and then they can wait for the other numbers (in case they had run out of stock and were in a hurry for replenishment stock). The solution doesn’t do that – instead, the first 500 stack will have the numbers 1-500, 2501-3000, 5001-5500, 7501-8000. That means not only is placement back onto the pallet confusing, but the customer has to wait for the artwork to be completely printed before even getting the first half of numbers. True, I could run the script several times to get the appropriate stacks, but why should I if the script did what I wanted? Especially if there are hundreds of stacks to print?


It's easy to enter a SEQ field manually. Begin by pressing [Ctrl]+[F9]. When Word displays the blank field, enter seq list1, as shown in Figure A. List1 is a required argument; you can use any descriptive name you like as long as it begins with an alpha character. The parentheses distinguish the numbers within the text. They're not part of the field code. Highlight the field code and press [F9] to display the field's value. As you can see in Figure B, the first field returns (1).
GREAT tip with lots of uses! Thank you. This will save me hours of work on some tickets I’m designing. However, I also need to set up table tents that have numbers on them. They’re 2-up, and are folded, so each number needs to appear twice on the same page. In short, I want a page with 1/1 and 2/2, and I’m getting 1/2 and 3/4. Am I missing an obvious fix? Thank you.
Warning  Making even minor changes to an outline numbering scheme won't necessarily change the initial position you've selected in the gallery, but rather may create a new gallery position, overwriting an existing one. Because of this problem, attaching numbering to styles is strongly recommended. This is covered in greater detail later in this chapter and in the chapter on Styles.
The next step is to create the simple Excel workbook that contains the ticket numbers. Open a blank Excel sheet. Using Figure B as a guide, create the ticket numbering sheet and save it, making sure to note the new workbook's name and location. As we discussed earlier, the Excel workbook stores the ticket numbers. In this example, we'll create 11 tickets numbered 100 through 110. You'll need to update the ticket values for each merge.

The next step is to create the simple Excel workbook that contains the ticket numbers. Open a blank Excel sheet. Using Figure B as a guide, create the ticket numbering sheet and save it, making sure to note the new workbook's name and location. As we discussed earlier, the Excel workbook stores the ticket numbers. In this example, we'll create 11 tickets numbered 100 through 110. You'll need to update the ticket values for each merge.
Drag the number, which Publisher defaults to “1,” into place on the ticket. To change the sequence, such as to start with “100” instead of “1,” click the “Page Number” button again and choose “Format Page Numbers.” Click the “Start this section with” radio button and type the new number into the field. Click the “OK” button to have Publisher update the ticket number.
Understanding outline numbering and how outline numbering interacts with styles is crucial to your success in using Word with legal documents. Basic outline numbering can be handled much the same way as bullets and numbering. Seven default outline numbered lists come with Word. Three of the lists format the paragraphs with outline numbers. These lists are in the top row of the dialog box. The remaining four format the paragraphs with outline numbers and apply heading styles to the paragraphs and can be found in the bottom row.

I want to a sequential number to fill in automatically each time the form is filled out. Malissa, A simple way would be to use something like this, you could assign it to a button, an open or before print event. Sheets("Sheet1").Range("A1").Value = _ Sheets("Sheet1").Range("A1").Value + 1 For other ways to do this or if this is going to be used in a temple have a look here http://www.mcgimpsey.com/excel/udfs/sequentialnums.html -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others...
I have a file that displays the text "Page 1" in the center of the worksheet. I have not been able to find a way to stop the page number from displaying. There is no header/footer, no "background", no other special items that I could find that would force the display of this. It does not appear during the printing so it's not a "watermark". It merely displays in my view when I'm working in the worksheet. Help... Hi you're in page break preview view ... choose view / normal from the menu Cheers JulieD "whalenohana"
I have done this twice now, getting flustered. The ticket part the person keeps has the correct sequential number on it, but the side that we keep has the same number on it for the whole page. What part am I missing, at first I did not uncheck the box, but this time I did but have the same number on the stub side that we keep with the person's name, etc
If you start to type in what appears to be a numbered list, Word formats your manually typed "numbers" to an automatic numbered list. The main benefit of this option is that you do not need to click any button to start numbering and you can choose your numbering style as well. For example, if you type "(a) some text" and press Enter, it starts numbering using the "(a)" format.
Hello, I'm looking for a way to quickly find what numbers are missing in column B. I can sort them ascending, but how do I find if there are missing numbers? 1 2 3 5 6 7 9 I need to know 4 and 8 are missing. Thank you. One way: select B2:Bx. Choose Format/Conditional Formatting... CF1: Formula is =(B2-B1)>1 Format1: / or, without sorting, select column B (with B1 active): CF1: Formula is =AND(B1>MIN(B:B),COUNTIF(B:B,B1-1)=0) Both CF's will activate if there are missing numbers before them. In article <28706E9E-2624...
Select the Text Tool (T) and start dragging a text box that will wrap around the whole ticket including the crop marks. This is very important since the Data Merge will automatically calculate the duplication. Then open up the Text Frame Option (Command + B) and set the Inset spacing to 1p4 for the top and 1p8 for the left. Of course, you can place the text for the numbers anywhere you like. I set the numbers to a small text.
×