![]() ![]() This will highlight the data considered to be part of the selected table. TIP: If you are unsure as to what Excel “sees” as the data range, click anywhere in the table and press CTRL-A. Excel is also smart enough to understand that the first row of the data is a header row and should not be moved with the other rows. If we want to determine which Apps have the highest revenue, we can click ANYWHERE in the Revenue column’s data (no need to highlight the entire column or entire table like we did in the “old days”) and then right-click and choose Sort and then choose Sort Largest to Smallest.Įxcel is smart enough to recognize that all the data on the same row as a Revenue value is associated with that value and should move wherever the Revenue moves. In the below example, we have data recorded by Division, Region, Apps, and Revenue. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |