15 hours of free training in just 5 minutes a day
Sign up here to get
Free Daily Technology Tips
Email:
  Home              Index Mission Statement Links                  Articles

Sign Up Now

Google
Web 180techtips.com

articles about technology

 
Technology Tip Number 164
Sorting Through the List

Have you ever wanted to sort a list of data into different categories.  For example, sort a grocery list by the location of each item in the store, or a budget by largest to smallest expenses, or a list of students alphabetically.  This Technology Tip will help you sort lists of information in Excel: 

1)     Open the excel file you wish to sort. 

2)     Highlight all of the data you want to sort

3)     Select “Data” and then “Sort” from the menu bar:

4)     Choose what you’d like to sort by, then click “OK”.  For example, you could sort the list by “HR” to see what "home room" the students on this list are in.  Or, you could sort the list in ascending or descending alphabetical order by last names.

 

PRACTICE ACTIVITY Try sorting a list in excel today.


TO KEEP ON LEARNING:  To learn more about sorting lists in Excel try searching the internet for:

Sorting in excel
Ascending and descending order in excel
Sorting Lists

Have a nice day!

Google
 
Web www.180techtips.com

 

 

Technology Tips Index:
 
 

 Microsoft Windows

 

 Internet

   Computer Hardware
   MS Outlook
   MS PowerPoint
   MS Excel
   MS Word
         
1 2 3 4 5
6 7 8 9 10
11 12 13 14 15
16 17 18 19 20
21 22 23 24 25
26 27 28 29 30
31 32 33 34 35
36 37 38 39 40
41 42 43 44 45
46 47 48 49 50
51 52 53 54 55
56 57 58 59 60
61 62 63 64 65
66 67 68 69 70
71 72 73 74 75
76 77 78 79 80
81 82 83 84 85
86 87 88 89 90
91 92 93 94 95
96 97 98 99 100
101 102 103 104 105
106 107 108 109 110
111 112 113 114 115
116 117 118 119 120
121 122 123 124 125
126 127 128 129 130
131 132 133 134 135
136 137 138 139 140
141 142 143 144 145
146 147 148 149 150
151 152 153 154 155
156 157 158 159 160
161 162 163 164 165
166 167 168 169 170
171 172 173 174 175
176 177 178 179 180
         
         

Home & Index
Mission Statement
Links

Sign Up Now!
to get
Free Daily Technology Tips

   

Copyright © 2006- 180TechTips.com