4 Effective Methods to Exclude Header Rows while Sorting the Contents of a Word Table

In today’s post, we will provide you with 4 effective methods to exclude header rows while sorting the contents of a Word table.

In Word, we prefer to use table to hold all kinds of data. Most of time, we are dealing with numbers. Then inevitably, sorting data will be one of our daily tasks. However, when doing this, you must aware that if your table contains one or more header rows. If it does, you need to pay a bit more attention.Exclude Header Rows while Sorting the Contents of a Word Table

Here are 4 ways to sort in a table.

Method 1: Sort the Contents of a Table with One Header Row

  1. If your table contains just one header row, then put cursor inside it.
  2. Then click “Layout” tab.
  3. Next click “Sort” in “Data” group to open the same name dialog box.
  4. In “Sort” box, select the “Header row” at the left-down corner.
  5. Then select a sorting rule, be it ascending or descending.
  6. Finally, click “OK”.Click "Layout"->Click "Sort"->Select "Header row"->Choose a Sorting Rule->Click "OK"

Now, if your table contains 2 or more header rows, you will need the following methods, because Word recognizes only one header row.

Method 2: Specify Header Rows

  1. First of all, select rows that you want to set as header rows.
  2. Next, click “Layout” tab, too.
  3. And click on the “Repeat Header Rows”.Select Rows->Select "Layout"->Click "Repeat Header Rows"
  4. Then deselect the rows, but make sure the cursor is in the table whose contents are to be sorted.
  5. Next click “Sort” and specify a sorting rule.
  6. Click “OK” at last.

Method 3: Select Rows to Be Sorted

  1. This time select rows that contain contents to be sorted.
  2. Then click “Sort” command.
  3. In “Sort” box, click on the combo box of “Sort by” and choose a column.
  4. And you can also set a column to sort in the “Then by” combo box.
  5. Next choose a sorting rule and click “OK”.Select Rows->Choose a Column to Sort by->Choose a Sorting Rule->Click "OK"

You may notice that you can choose a column to be sort in method 3. But you are unable to do so with the proceeding 2. So, here is the macro way, which not only allows you to specify the start of a sorting range but also a specific column to sort by.

Method 4: Run Word Macro

  1. To begin with, place cursor inside a table and press “Alt+ F11” to open VBA editor.
  2. Then click Normal” on the left column.
  3. And click “Insert” on menu bar.
  4. Select “Module” on that drop-down menu.Click "Normal"->Click "Insert"->Click "Module"
  5. Open it by double click.
  6. On the module, paste following codes:
Sub SortCurrentTable()
  Dim strRowNum As String
  Dim strSortRule As String
  Dim strField As String
 
  Application.ScreenUpdating = False
 
  strRowNum = InputBox("Enter the row number of the row which you want to start sort:", "Row Number")
  strSortRule = InputBox("Enter one of the following values:" & vbNewLine _
                & "0 for ascending" & vbNewLine & "1 for descending", "Sorting Rule")
  strField = InputBox("Enter the number of field by which you want to sort:", "Field Number")
 
  With Selection.Tables(1).Range
    .Start = .Rows(Int(strRowNum)).Range.Start
    .Sort SortOrder:=Int(strSortRule), FieldNumber:=Int(strField)
  End With
 
  Application.ScreenUpdating = True
End Sub
  1. Next click “Run” button to execute codes.Paste Codes->Click "Run"
  2. Then in the first input box prompting up, enter a row number.
  3. Click “OK” to proceed.Enter Row Number->Click "OK"
  4. And in the “Sorting Rule” box, enter a value representing sorting rule and click “OK”.Specify Sorting Rule->Click "OK"
  5. Next in “Field Number” box, enter a column number and click “OK”.Enter a Column Number ->Click "OK"

Address Document Issues

In use of Word, we are easily to encounter with different kinds of errors. Some can be fixed with a simple restart. Others, however, are more dreadful. This is extremely true when you inherit a damaged doc.Then you best shot is to get a tool to repair it.

Author Introduction:

Vera Chen is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including damaged Excel and pdf repair software products. For more information visit www.datanumen.com

One response to “4 Effective Methods to Exclude Header Rows while Sorting the Contents of a Word Table”

  1. Everything you might require for an effective messaging session with your prospective new bride is offered at CharmDate. With a totally free account, you might likewise speak and surf women profiles with one girl for a few minutes. Nonetheless, we can discuss the few that there are. The number of marital relationships in between Czech people as well as foreigners has been on the rise over the previous few years, according to brand-new numbers released by the Czech stats workplace. CharmDate is one of the most preferred online communication platforms worldwide that has been aiding solitary individuals considering that 1998. For more than twenty years, this system has actually helped Western men find real love and also joy with females from Europe, Asia, Latin America, as well as various other areas. For even more than 22 years, CharmDate has a myriad of success stories to its credit. The expenses subscription variant of CharmDate is using getting credit history, which you’ll utilize to do essentially anything as you make interior purchases for one-of-a-kind features making use of the credit report rankings. Nevertheless, it’s primarily a cam site that intends to entice you into spending for a premium membership. So unless you desire that, this website is a waste of time. CharmDate’s messaging is fairly sensible, so if you get on a tight budget plan but still want to fulfill your destiny, you must offer it a shot.

    Given that a lot of females in the Czech republic work full-time, they will remain to add to your family members budget. The Czech republic is heavily influenced by nations such as Germany, Hungary, Austria, and so on. The women of the Czech republic likewise blend some physical features of western European countries, that makes them constantly be discovered in the group with amazing appeal. The internet site is commonly used by men from different Western nations to locate as well as begin relationships with Russian, Ukrainian, and also other Slavic women. Czech females, by comparison, like guys from countries such as Germany, USA as well as United Kingdom. When it pertains to international dating, Czech men often tend to link Ukrainian women, Polish females and russian ladies. If you’re trying to find laid-back dating, have a look at the very best hookup apps and also internet sites we have actually attempted recently. Any type of obscene content will certainly be strained from your discussions. All novices are greater than welcome to inspect out the Tips & Suggestions Block at the base of the site. They have accessibility to talk with newbies.

    Nonetheless, when these discount coupons run out, you will certainly have to purchase even more debt units. You have to acquire Qpid credit scores which will certainly enable you to get or send out messages. This web site is a platform based on credit rating just as most of the communication services call for credit histories. Consequently, the entire structure of dating websites is arranged to offer two primary tasks: search and also communication. When looking at the major web page of the website is very favorable, the very first perception. Since of the comfort, ease of access, and performance of the devices that fix these troubles, the website is great for customers. New members do not recognize whether the customers on this dating system are 100% actual. Its practical interface, minimalistic layout, a big pool of energetic and real participants, as well as varied communication tools, make CharmDate a distinct website. It’s taken a look at as an interaction you get using people who are suggesting you actually their very own passion. Per our observation, online interaction is full of unclear elements, there may be threats for one to move right into the next stage.

    There are strict guidelines and policies, which have been carried out to resolve illegal problems. However, all these modes are available to those who have actually selected paid memberships or have Qpid credit scores. If you are searching for methods to interact with others, then rest guaranteed, CharmDate gives you enough modes to do so. There are multiple settings of payment that the website approves. You can likewise read some participant remarks there. What a free participant can utilize after Charmdate login? The application is available to download and install free. You can quickly download it free both on Android as well as iphone gadgets. Throughout our CharmDate review, we evaluated how long a free individual can take place the system. Free individuals can watch just some images. Customers need to take an email confirmation examination to open an account, which makes sure that just genuine customers can obtain in. We welcome you to take a more detailed consider the standard one. For our part, we can only confirm that a lot of the individuals’ profiles look very expert.

Leave a Reply

Your email address will not be published. Required fields are marked *