![]() For this purpose, in the list of tool options, select «Custom Sort». The user can choose the order of the color sorting. From the proposed list, select «Put Selected Cell Color On Top».Select the column - the right mouse button - «Sort».We will make the column «Total» and "fill" the cells with values in different shades in the training table. Therefore, it is possible to operate in different formats. ![]() Data in the rows will be in accordance with the position of the values in the first column.Įxcel provides rich formatting capabilities to the user. If you select the entire table and sort it, the first column is sorted. Otherwise, only the selected column is sorted - the structure of the table is broken. To maintain the correspondence of the values in the lines, we select the action "Expand the selection". When the range contains more than one column, Excel opens a dialog box like: If you want to perform simple sorting in ascending / descending order (alphabet or vice versa), just click the corresponding button on the taskbar. ![]() ![]()
0 Comments
Leave a Reply. |