Upgrading Your Skills with Excel by Lentzner Rémy;

Upgrading Your Skills with Excel by Lentzner Rémy;

Author:Lentzner, Rémy;
Language: fra
Format: epub
Publisher: Editions Remylent
Published: 2021-03-22T16:14:52+00:00


It means rearranging the rows of a table according to a criterion. For example, you want to sort out wages from largest to smallest or some dates from most recent to oldest. Excel allows you to sort out rows according to the color of a cell.

To sort out a table without any risk of mismatching information, place the pointer in the column to be sorted, right-click then choose the Sort option in the pop-up menu. Do not select the data, you might forget a column and Excel will then ask you if you want to apply the sort to other columns, that can be confusing. Remember that the table should not contain empty rows or columns and that each column should be named in the header.

Figure 3.9 shows the context menu that appears after a right-click in a date column.



Download



Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.