SayPro Sort Table Data

Email: info@saypro.online Call/WhatsApp: + 27 84 313 7407


SayPro Sort Table Data

Word can sort a table’s data numerically, alphabetically or chronologically in an ascending or descending order.Sort the contents of a table

  1. In Print Layout view, move the pointer over the table until the table move handle appears.
  2. Click the table move handle to select the table that you want to sort.
  3. Under Table Tools, on the Layout tab, in the Data group, click Sort.
  1. In the Sort dialog box, select the options that you want.
  2. Click OK

You can apply up to three sorts on a tableSort a single column in a table

  1. Select the column that you want to sort.

Under Table Tools, on the

  1. Layout tab, in the Data group, click Sort.
  2. Under My list has, click Header row or No header row.
  3. Click Options.
  4. Under Sort options, select the Sort column only check box.
  5. Click OK.

Sort by more than one word or field inside a table columnTo sort the data in a table that is based on the contents of a column that includes more than one word, you must first use characters to separate the data-including data in the header row. For example, if the cells in a column contain both last and first names, you can use commas to separate the names.

  1. Select the column that you want to sort.
  2. Under Table Tools, on the Layout tab, in the Data group, click Sort.
  1. Under My list has, click Header row or No header row.
  2. Click Options.
  3. Under Separate fields at, click the type of character that separates the words or fields that you want to sort, and then click OK.
  4. Under Sort by, in the Using list, select which word or field you want to sort by.
  5. In the first Then by list, enter the column that contains the data that you want to sort by, and then in the Using list, select which word or field you want to sort by.

If you want to sort by an additional column, repeat this step in the second Then by list.

  1. Click OK.
Tsakani Stella Rikhotso | Monitoring & Evaluation OfficerSayProWebsite: www.saypro.onlineCell: 27 (0) 713 221 522Email: tsakaniStudy and Qualifications www.saypro.onlineOur Company www.saypro.online

SayPro is a group of brands leading in Africa’s development, building innovative online solutions and a strategic institution on child growth, youth empowerment and adult support programmes, applications in Africa.SayPro Core Skills and Expertise:

  • SayPro Artificial Intelligence, Graphics, Online Design and Web Development
  • SayPro Higher Education, Certification, eLearning Development, Qualification Design and Online Training.
  • SayPro Community Development in Youth Unemployment, HIV/AIDS, Human Rights and Gender-Based Violence
  • SayPro Company Registrations, Tax, VAT and Website Designs.
  • SayPro Research, Opportunity Sharing in Tenders, Funding and Contact Directories.
  • SayPro Monitoring, Evaluation, Knowledge Management, Learning and Sharing.

SayPro is providing international and global opportunities for African youth. Partner with SayPro now by sending an email to info or give us a call at + 27 11 071 1903Please visit our website at www.saypro.online Email: info@saypro.online Email: info@saypro.online Call: + 27 11 071 1903 WhatsApp: + 27 84 313 7407. Comment below for any questions and feedback. For SayPro Courses, SayPro Jobs, SayPro Community Development, SayPro Products, SayPro Services, SayPro Consulting, and SayPro Advisory visit our website to www.saypro.online