Related Articles
- How To Sort Excel Worksheets
- How To Sort Excel Sheet
- How To Sort Excel Spreadsheet
- How To Sort Excel Data
- 1 Add a Hyphen on Excel
- 2 Automatically Put in the Months of the Year in Columns in Excel
- 3 Inserting the Next Consecutive Integer in Excel
- 4 Duplicate Words in Excel
The Mac version of Excel contains the same features as its Windows counterpart, including the standard filtering tools and preformatted formulas. Calculations and sorting may be performed with ease using tools such as AutoSum and Filter. You may also use the tools in Excel for Mac to create lists.
The Mac version of Excel contains the same features as its Windows counterpart, including the standard filtering tools and preformatted formulas. Office for Mac, which includes Word, Excel, PowerPoint and other productivity tools, is available in various different forms. Here, we help dispel the confusion with our complete guide to Office. The Filter drop-down menus (formerly known as Auto Filters in Excel 2003) are an extremely useful tool for sorting and filtering your data. When the Filters are applied you will see small drop-down icon images in the header (top) row of your data range.
How To Sort Excel Worksheets
1.Launch Excel and open the spreadsheet in which you want to create a list. Select the cell where you want to begin.
2.Type the name of the first item in the list into the cell. For example, if you are making a list of days in the week, type “Sunday.” If your list is a common set of data, such as days, months or consecutive numbers, Excel for Mac can automatically complete your list. To automatically fill the remaining days of the week, select the “Sunday” cell and hover the cursor in the lower right corner. Click and drag the cursor down the column of cells while holding down the mouse button.
3.Create your own custom lists for Excel to automatically fill. Click the “Excel” button and select the “Preferences” option, which will open a separate dialogue window. Click the “Custom Lists” option under the “Formulas and Lists” section.
4.Fill in the remainder of your list manually. When you have finished typing the initial entry in the top cell, press the 'Enter' key to go to the next cell in the column. You may also use the down arrow to go to the next cell, or simply click on it, to continue typing items that need to be on your list.
References (1)
About the Author
How To Sort Excel Sheet
Cooper Temple has over 15 years of experience writing procedural and training material for a Fortune 500 company. His articles specialize in productivity programs and other business-related software.
Cite this Article