Applicability the Category service in Excel to Category lists of facts by dates.
It's nearly impossible to adapt lists and counsel without sorting it into some affectionate of cast. The most regular road to Category counsel is alphabetically, nevertheless there are countless other ways. For instance, you may bear a information of friends and family and their birthdays. To stay on top of birthday greetings and gifts you can input your string into Microsoft Excel and Category by age. This groove you Testament be able to trial the dossier periodically and glare whose birthday is forthcoming up. There are differing other lists that can be sorted by age, such as cost payments or Physician appointments.
Instructions
3. Select a column of dates. To do this Click on the first date in the top most row and drag your cursor down over remainder of the dates, so they are all selected. You can also click on the topmost cell and hold down the Shift button while clicking the down arrow key until all the dates in your column are highlighted.
Open Excel. Type in the information in your list into Excel, making sure that all dates are relegated to the cells in one column. For the birthday example, your columns can be Name, Relationship, Birthday. You can even add a column for gift ideas for each particular person. Fill in the rows corresponding to the names of your columns:
Name Relationship Birthday
Dad Father 09/23
1. Dash off down an organised string of the information you want to put into Excel and the corresponding dates.2.
4. Click on the data tab at the top of the screen. View the "Sort & Filter Group."
5. Click on the button that has a Z on top of an A with a downward pointing arrow. This is the "sort from newest to oldest" button. If you want to sort from oldest to newest, click on the button with an A on top of a Z that has a downward pointing arrow. (Ref. 1)
6. Save your list to your computer's desktop to open and view at your convenience.
