To sort a range of cells in Excel, first click and drag your cursor across your spreadsheet to highlight all of the cells you want to sort - even those rows and columns whose values you're not actually sorting by.įor example, if you want to sort column A, but there's data associated with column A in columns B and C, it's important to highlight all three columns to ensure the values in Columns B and C move along with the cells you're sorting in Column A. Highlight the rows and/or columns you want sorted. But don't worry - while the location of certain buttons might be different, the icons and selections you have to make are the same across most earlier versions of Excel.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |