How does Excel sort data?

A simple sorting method

  1. Here, the editor takes the student grade table as an example. First, open the Excel table, select a cell in the column to be sorted, and then select ascending or descending order in the data.
  2. Since this is the total score of the arrangement, generally choose to arrange in descending order, then the data in the table will be sorted in descending order from the highest to the lowest.

Second, multi-keyword sorting

  1. If the simple ascending and descending sorting is not enough for you, and you want to sort the total score and also sort the biological scores at the same time, then you need to use multiple keywords to sort. First look at this table, there are many with a total score of 610.
  2. Click Sort directly, and the following dialog box will pop up.
  3. In the sorting dialog box, you can select the main keyword and the order method.
  4. After clicking Add Condition, secondary keywords will appear, select the corresponding keywords and sorting method, and then click OK. (multiple secondary keywords can be added here)
  5. At this time, you can find that the data are arranged in descending order of total score, and at the same time, they are also arranged in descending order of chemical score. This is how Excel sorts, how to be detailed and simple.

How can I delete blank pages in word?

  1. First, click and select the icon under the Start menu to display the edit mark.
  2. Click to enter the word option in the word icon in the upper left corner.
  3. In the word options, select the Display menu, and check all the tags under the column “Always show these formatting tags on the screen”, especially “Show all formatting tags”. After saving, the document will display these special characters. Out.
  4. Delete the page break that cannot be deleted on the blank page of word. The first thing to delete is the page break. If you find the page break mark on the blank page, you can delete it.
  5. Adjust the top-to-bottom table in word. You must know that the table cannot be deleted directly using the backspace key, because there must be a carriage return after the table, and this carriage return cannot be deleted, causing the previous table to be deleted. No, so the blank pages cannot be deleted. In this case, you can adjust the row height of the table slightly.
  6. Select all the tables and press the keyboard shortcut (Shift+Delete) to delete them.
  7. Finally, use the Clear Formatting tool to clear the document format and return to normal use.

How to set a single page to landscape in word document?

  1. First, open the word document program, enter the main interface of the program, and select the page to be set to landscape.
  2. Then, in the main interface of the Word program, select “Page Setup” of “File” above.
  3. Select “Landscape” in the dialog box and click Save.
  4. Finally, you can see that the selected page becomes horizontal, and the problem is solved.

Related:Buy Microsoft Office 2021 Home and Business for PC Licence

Leave a Reply

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