Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-19-2024, 12:48 PM
Thomas Colbert Thomas Colbert is offline How to do sequential numbers going down the column and then to right. Mac OS X How to do sequential numbers going down the column and then to right. Office 2011 for Mac
Novice
How to do sequential numbers going down the column and then to right.
 
Join Date: Feb 2024
Posts: 3
Thomas Colbert is on a distinguished road
Default How to do sequential numbers going down the column and then to right.

Hi Guys,

I'm new here. I'm not sure how to even search this. I make serial numbers using Brady LAT-11-747-5 labels. The are 20 down with 5 rows. I have the setup in word but other then changing each one individually, how do we have it start with lets say PHA-1000 and then count all the way to PHA-1100. There are 100 spots on this sticker sheet. What is the fastest way to do this going down the rows.



I want them going down the columns sequential order. Sorry for spelling errors.

Thanks,
Tommy
Reply With Quote
  #2  
Old 02-19-2024, 01:40 PM
Charles Kenyon Charles Kenyon is offline How to do sequential numbers going down the column and then to right. Windows 11 How to do sequential numbers going down the column and then to right. Office 2021
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,140
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

Hi Tommy,

Labels in Word are Tables.
The order, normally is across and then down. There is no simple way to change this.

You could use set up the label page, manually, as a five-column page, not table columns but section columns. Have a single-column table in the five-column page. The order will then go down the column to the end and then to the next column.

You could use a SEQ field for your numbering an simply set the first number.
SEQuence Field

You could use Mail Merge with that as your primary letter-type merge document and an Excel spreadsheet as your data source. The numbers are in Excel.
Mail merge using an Excel spreadsheet - Word
Note, you are not using a label merge if you want your numbering vertically rather than across the page.

Here is my chapter on Numbering in Microsoft Word. Here is my chapter on Tables.
Reply With Quote
  #3  
Old 02-19-2024, 02:23 PM
Thomas Colbert Thomas Colbert is offline How to do sequential numbers going down the column and then to right. Mac OS X How to do sequential numbers going down the column and then to right. Office 2011 for Mac
Novice
How to do sequential numbers going down the column and then to right.
 
Join Date: Feb 2024
Posts: 3
Thomas Colbert is on a distinguished road
Default

Hi Charles,

I will look into what you wrote. I appreciate it a lot. I did not think it was complicated like this. I use these programs often , but not often enough to learn all this stuff.

Thanks,
Tommy
Reply With Quote
  #4  
Old 02-19-2024, 08:02 PM
Charles Kenyon Charles Kenyon is offline How to do sequential numbers going down the column and then to right. Windows 11 How to do sequential numbers going down the column and then to right. Office 2021
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,140
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

The simplest thing to do would be to accept the numbering going across the page and then down.
Reply With Quote
  #5  
Old 02-20-2024, 12:25 PM
Thomas Colbert Thomas Colbert is offline How to do sequential numbers going down the column and then to right. Mac OS X How to do sequential numbers going down the column and then to right. Office 2011 for Mac
Novice
How to do sequential numbers going down the column and then to right.
 
Join Date: Feb 2024
Posts: 3
Thomas Colbert is on a distinguished road
Default

Quote:
Originally Posted by Charles Kenyon View Post
The simplest thing to do would be to accept the numbering going across the page and then down.
You are probably right. I wonder why this is tho. People don't like going down, only to the right? You know what I mean lol.

Thanks,
Tommy
Reply With Quote
  #6  
Old 02-20-2024, 02:22 PM
Guessed's Avatar
Guessed Guessed is offline How to do sequential numbers going down the column and then to right. Windows 10 How to do sequential numbers going down the column and then to right. Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,977
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

Merge the rows so your table has 1 row and multiple columns (on each page). It is harder to work out the spacing of the paragraphs but you will get the numbers running down and wrapping to the next column
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #7  
Old 02-25-2024, 03:43 PM
macropod's Avatar
macropod macropod is offline How to do sequential numbers going down the column and then to right. Windows 10 How to do sequential numbers going down the column and then to right. Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

See Merge Labels Using a Down-Then-Across Output in the Mailmerge Tips & Tricks thread: https://www.msofficeforums.com/mail-...ps-tricks.html.

The numbering automation can be done via either a SEQ field or applying automatic paragraph numbering.

If you're not using mailmerge, simply add however many rows you need by pressing the TAB key repeatedly within the table you've created.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
How to do sequential numbers going down the column and then to right. Generate sequential numbers (preferably in thousands) Alberto5501 Word 4 11-09-2018 07:20 AM
How do I Update Caption Numbers appear in Sequential Order TechDiva95 Word 10 02-24-2018 10:06 AM
How to do sequential numbers going down the column and then to right. Flyers with sequential numbers trebor58 Mail Merge 2 10-25-2017 12:53 PM
How to do sequential numbers going down the column and then to right. How to have sequential numbers appear in word header woodyear99 Word 1 07-18-2016 08:28 PM
How to do sequential numbers going down the column and then to right. I would like a function to add sequential numbers to a class number/name Highlander01 Excel 5 01-22-2016 02:29 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:48 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft