![]() In the Order list, select the order that you want to apply to the sort operation - alphabetically or numerically ascending or descending (that is, A to Z or Z to A for text or lower to higher or higher to lower for numbers).įor more information about how to sort data, see Sort data in a range or table . In the Sort On list, select either Values, Cell Color, Font Color, or Cell Icon. In the Sort by list, select the first column on which you want to sort. You can find a wide range of free Excel training tutorials online to master your skills with the widely-used spreadsheet software in the Microsoft Office Suite. On the Data tab, in the Sort & Filter group, choose Sort. Select a single cell anywhere in the range that you want to sort. Spreadsheet features, navigations and terminology are explained. ![]() Get started with Sheets Switch from Microsoft Excel to Sheets. How-to/tutorial video demonstrating how to create a basic Excel spreadsheet. Select a single cell in the column on which you want to sort.Ĭlick to perform an ascending sort (A to Z or smallest number to largest).Ĭlick to perform a descending sort (Z to A or largest number to smallest). Learn the basics of using Microsoft Excel, including the anatomy of a spreadsheet, how to enter data, how to make your data look good so its easier to read. Quickly learn how to create and edit a spreadsheet, move to Sheets from another online spreadsheet app, and more. The range can include titles that you created to identify columns or rows. This enables you to click on the Start button, and then click on the Excel icon to launch the Excel spreadsheet. ![]() Note +: After Excel has been launched for the first time, the Excel icon will be located on the Quick Launch pane. How-to/tutorial video demonstrating how to create a basic Excel spreadsheet. Select a range of data, such as A1:L5 (multiple rows and columns) or C1:C80 (a single column). Select Microsoft Office from the menu options, and then click on Microsoft Excel 2019.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |