Can anyone tell me what the maximum no. of worksheets is in Excel? Ton From Help...Limited by available memory (default is 3) -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS "Ton" wrote in message news:EB5EE739-9250-4D83-AA7C-EE82C02C0AA3@microsoft.com... > Can anyone tell me what the maximum no. of worksheets is in Excel? The maximum number only depends on the amount of memory available. -- Best Regards Leo Heuser Followup to newsgroup only please. "Ton"

Word includes a special sequencing field that you can use to do all sorts of numbering. You can even use the SEQ field to help create broken numbered lists. (A broken numbered list is one in which the flow of the list is interrupted by paragraphs of a different format.) This approach to creating numbered lists is particularly helpful and much less prone to the problems inherent in Word's built-in list numbering. For the purposes of this tip, the format of the sequence field is as follows:


If you are thinking of using sequential numbering, please give our printing experts a call for helpful advice on how to best set up your artwork. We offer ready to use templates for the most common types of forms including invoice templates, statement templates, work order templates and purchase order templates. Just upload your logo and contact information and let us know how you would like to number your forms.
You can change the numbers in the list by restarting the sequence or by specifying a new start number. You can change the list's style. You can do anything to this list that you can do to a normal numbered list because it is a numbered list, with one exception: the list, while easy to format, is fixed. If you delete an item, the list updates accordingly, but I haven't found a way to add numbers.
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.
Perhaps your explanation already addresses this, but I can’t see it. Is there any way this script can be used for printing multiple-up in numeric sequence? For example, if I’m running 1000 postcards 4-up (on 250 sheets). I need the 4 cards on page 1 to be numbered 1, 251, 501, 751; then the 4 cards on page 2 numbered 2, 252, 502, 752; etc., so that when the sheets come out of the printer and are cut into 4, I have a stack of 1-250, a stack of 251-500, a stack of 501-750 and a stack of 751-1000.
If you want numbered headings to be underlined, but do not want a line under the number, it can be difficult if you don't know how it works. This is because by default, the format of the number follows the format of the text that follows it. For example, let's say you want to underline a paragraph in a Heading 2 style. Chances are it will look like this:
It will ask for the number of copies that you want to make and sequentially number each copy.The first time this macro runs, the first copy will be numbered 1 and when it finishes running, it will store in aSettings.Txt file the number that is one more that the number on the last copy.The next time the macro is run, it will start numbering the copies from that number. If when you first start, you want the numbers to start at some number other than 1, run the macro, entering 1 as the number of copies and then open Settings.Txt file and replace the number in the file with the number that you want as the first in the series.At any time thereafter, if you want the series to start at a particular number, you can open that file and replace the number in it with the number that you want to be the first in the series.

Hi Maria, there is a way for your endnote numbering to restart at 1 for each chapter when all your chapters are in a single document. You’re right that they revert to Continuous when imported into InDesign, but you can change your Endnote Options to restart the numbering at the beginning of each Story (a story is a set of linked text frames) and then divide your chapters into stories. Here’s what to do:
Developing Document Control and Image Numbering Systems. The document and imaging numbering or coding system for your application gives you control over the documents. If you are going to image documents, the document database record number and the image record or file number may be the same number. A document and imaging numbering or coding system can be very simple or sophisticated, depending upon your desires and the needs of a particular case. Below are three possible methods of coding your documents and images:
Another fan of Fusion Pro Desktop here. This is exactly what you need. We have sold both PrintShop Mail and Fusion Pro Desktop for this very application (numbering) and other VDP applications. Fusion Pro Desktop easily beats PrintShop Mail from both a price and performance viewpoint. You could also try Printer's Bench http://www.elkriversystems.com/ProductsList.aspx for a good entry level package
The first number in this identifier is the date, followed by the customer number, and the unique sequence number. The last number is important if you have multiple invoices for the same customer on the same date – in that case, the next invoice would be numbered 05232017-4602-01. The date format can be selected from a variety of options as well. The example above uses the DDMMYYYY format, but alternate options include MMDDYYYY, DDMMYY, YYYYDDMM, or YYDDMM, among others.

Word includes a special sequencing field that you can use to do all sorts of numbering. You can even use the SEQ field to help create broken numbered lists. (A broken numbered list is one in which the flow of the list is interrupted by paragraphs of a different format.) This approach to creating numbered lists is particularly helpful and much less prone to the problems inherent in Word's built-in list numbering. For the purposes of this tip, the format of the sequence field is as follows:
I have a large job for a client who uses antique computers. They are so old that he can't run Lightroom. As a workaround, I posted the images I wanted him to look at on SmugMug and we had a disaster. Their sequencing on screen does not match my "as shot" sorting on my Lightroom (4). Is there a way I can print sequential serial numbers/ids on my images before I upload them to SmugMug so we are always talking about the same image?
If you’re producing any kind of numbered items in-house that are multiple-up on a sheet where you need to control all the variables to meet your production needs, the autonumbering feature through numbered lists is the way to go! Just step and repeat away & InDesign will do all the work. No need to fool with a seperate “numbers” file or deal with a data merged document. I think it’s by far the best option for basic numbering.
If the second number on your raffle ticket is one higher than the first number, you must have accidentally put the <> tag after the first number (causing the next number, on the same ticket, to increase by one). You only need the <> after the second number on each ticket, so the next ticket gets a new number. (But you don’t need it on the final ticket on the **page**, because the next **page** automatically gets a new number)
One of the easiest ways to begin applying numbers is by starting to type a numbered list. Word recognizes that you are creating a list and responds accordingly by converting text that you type into numbered items. The number scheme, delimiter characters that mark the beginning or end of a unit of data and formatting are all based on what you have typed.
With the numbered paragraphs shown above, there is no extra spacing between the paragraphs. That’s easy to fix. Go ahead and type out at least part of your first numbered paragraph, then go to the Page Layout tab and adjust the value of Spacing After in the Paragraph section. Still no extra space? There’s one more setting to check. Click the launcher arrow in the lower right-hand corner to go to the Paragraph dialog box, uncheck the box next to “Don’t add space between paragraphs of the same style.” Click OK. That paragraph and all the remaining numbered ones will have more breathing room.

I need 2 copies to be printed each time I print from a certain file. Is there any way to save this command so I don't have to change the number of copies each time I print? Hi you could record a macro while doing this manually and assign a shortcut or button to this recorded macro -- Regards Frank Kabel Frankfurt, Germany Hebert45 wrote: > I need 2 copies to be printed each time I print from a certain file. > Is there any way to save this command so I don't have to change the > number of copies each time I print? ...
Brand New Replacement Parts, Equipment And Supplies For: AB Dick, Ryobi, Multilith, Chief, Davidson, Hamada, Heidelberg,  T-51, Varn Kompac , Crestline, Baumfolder,  Astro envelope feeders  And Thompson envelope feeder, at below regular manufactures prices. We Also Stock, Prodeco “NO-MARK” Anti-Tracking devices,  Syntac rollers,  blankets,  wash-up blades / bottles, wash-up units / blades,  Rapid 106 staplers,  Airtech spray units,  Kompac Units,  Kompac Seals, Cutting blades, cutting sticks, dampening covers, hollow drill bits, numbering  units,  business card slitters, padding presses, disposable latex gloves, envelope backstops, press lamps, Align-mate , quick change blanket bars, Tilt and Turn  For T-51,  Litho Perf, Litho Score , electric switchs, counters, motors, vacuum pumps, spray powder, press dollies, pad counters, vacuum pump repair kits, gripper bar repair kits, hardware kits, metric hardware kits, V-belts, sucker feet / tubes,  etc.     
Great article. I’m working on a book project with both footnotes and endnotes. Long story, but I had to insert the endnotes manually into each Indesign chapter/file, so they weren’t imported using your method. Nevertheless, InDesign created the nifty text file for my references at the end of each chapter. I found though, when I cut and pasted each text to a single Appendix page in a separate document in the book, the reference numbers disappear from the originating chapter. Can you clarify what I’m doing wrong?
You won’t use any of the standard List Number styles for SEQ field numbering. You need to create your own style if you want correct indentation and alignment with the tab position of the first word after the number. In this example, I’ll create a new style called Step Number, but you can call it whatever you want. In this example, I’ve also used the default settings for tab and hanging indent positions — you can change these later if you want.
I'm producing gift certificates for a restaurant and they need to be numbered sequentially from 0001 to 0250. Is there any way to do this easily as opposed to numbering each manually? I'm sure I could probably work it out with a print shop, but the job was thrust on me last minute and my options are limited by the short turn around time. Any help would be appreciated. Thanks!...
Hi! I hope you help me with this. I have the almost same problem as #2. I have PassengerTable as table name, then I have the following fields: sequence (to follow what you have in your post), transaction_date, and transaction_ID. Basically I want the to have sequential numbering in the transaction_ID where month and date from transaction_date is shown. i also have a generate (Command27)button as trigger.Tried the code with few modifications, but it sequence doesnt populate, and doesnt show any, except for what i have in control for transaction_ID which is the “Format(transaction_date,”yyyy-mm”) & “-” & Format(sequence,”000″)” and this only shows the year and date, so instead of 2015-08-001 it shows 2015-08-.

When generating invoice numbers based on the customer number, you can choose whether or not to include any date information. Either way, the number will begin with the customer number and then be followed by the date (if desired) and the sequence number. No matter how you decide to structure your invoice number, the sequence number always needs to come at the end. This makes it easiest to find and to differentiate from the others in its sequence.
I would like to number a voucher book, i have place 4 vouchers on a page, the thing is that i want each of these vouchers to start with different number, 100, 200, 300, 400, and then i want to number them 99 times. The problem is that they have to be numbered only 1 per page, so that when i have printed them all i can easily crop them and staple them right up with having to go through it all.
×