0
What would happen if you sorted a column by choosing the column heading?
Wiki User
∙ 12y ago
it makes you pooop out nipples
Wiki User
∙ 12y ago
Add your answer:
Earn +20 pts
What happens if you sorted a column by choosing the column heading in Excel?
It would use the data in the column as the basis for the sorting and sort the rest of the data.
Can data be only sorted by a single column?
No, it is possible to sort on more than one column, which is used for sorting things within groups, like firstnames with surnames, or sales within months.
What happens to blank cells when a worksheet is sorted?
Blank cells are collected at the bottom of each related column.
Is it true that data can only be sorted by a single column (In Excel)?
If you only have a small amount of data, then it could be stored in a single column if appropriate.
Can data be sorted by a single column?
No, it is possible to sort on more than one column, which is used for sorting things within groups, like firstnames with surnames, or sales within months.
Can you alphabetize playlists in rhapsody?
Hold ctrl and shift and click on the title header of the column to be sorted. Repeat to reverse order.
How do you make your text in Microsoft Word alphabeticly form a-z?
Put each word or piece of text to be sorted onto a different line, or into different cells in column in a table. Select the text to be sorted. Then use the Sort option from the Table menu.
Which of the following columns can be sorted by clicking on the ascending and descending arrows on the column header row?
Effective Date
Which type of VLOOKUP is default in Excel 2010?
To have the column being searched sorted in ascending order and to find the nearest value equal to or below the search value.
How can you filter a report to include only transactions in a given wee?
It depends on what kind of program the data has been stored on. If on a spreadsheet, you would use a separate column for dates, and sort on this column. (Remembering to include the whole of the data, or only the date column would be sorted, leaving the rest of the data out of position.)
How do you sort columns in excel when some of the cells are blank?
Select the columns as normal and use the sort icon, or command on the Data menu to sort them. If you have more than one column selected, the column in which the active cell is will be used to sort. If you want to sort on a number of combinations, like surname and then firstname, that can be done through the data menu. Blank cells will be sorted to the end and the rest of the data will be sorted as usual.
How do you get sorted on harrypottercom?
You cannot get sorted on that website. However, you can be sorted on Pottermore.
