Usually this is done by selecting the whole sheet (using the key combination Ctrl+A) or if some of the sheet contents should be left as is, selecting all of the relevant columns (e.g., when a summary table is positioned to the right of the data). The key action in this second step is to highlight all of the data that needs to be kept together during the sort. The cells in each row in a spreadsheet typically go together (e.g., different pieces of information about an individual participant) so when sorting it's important that all of the data in a particular row be re-ordered the same way (e.g., a person's last name in A2 stays with their first name in B2 and birthdate in C2). For example, a sort might be specified to re-order first by "class number", second by "last name", and third by "first name", creating data sorted alphabetically within class.Īction 2: Identify and highlight the range of cells to be re-ordered In Calc, you can sort by up to three criteria, with each criterion applied one after the other. It is used for storing, organizing, and manipulating data. In choosing one column by which to re-order the data, you are specifying a sort criterion: the data will be re-ordered, in ascending or descending order, according to the contents of the cells in this column. An electronic spreadsheet is a computer program that is equivalent to a paper ledger sheet. The ability to sort alphabetic and numeric data by one or more criteria, in ascending or descending order, is a key feature. The default is to sort by columns unless the selected cells are in a single column.The power of spreadsheets comes from the ease with which we can manipulate data.
Select the box, then choose from the drop-down list one of the sort orders defined in Tools > Options > Calc > Sort Lists. If a range contains cells that already have content, then the sort fails. If a range is specified that does not have the necessary number of cells, then cells are added.
Sets a spreadsheet address to which to copy the sort results. If formatting is used to distinguish different types of cells, then use this option.
If two entries are otherwise identical, one with an upper case letter is placed before one with a lower case letter in the same position if the sort is descending if the sort is ascending, then the entry with an upper case letter is placed after one with a lower case letter in the same position.ĭoes not include the column heading in the sort.Ī cell's formatting is moved with its contents. On the Options tab of the Sort dialog, you can choose the following options: Choosing the criteria and order of sorting
0 kommentar(er)
