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

 
Technology Tip Number 60
Excel in 1, 2, 3 Order

The 60th technology tip!  You have successfully completed 1/3rd of the total number of tips?  That means that if you started at the beginning, and you've been reading every tech tip and doing every activity you have completed 5 hours of free computer training!  Congratulations, but you're not done yet!

In celebration of the 1/3rd mark, today's technology tip will be a real easy one.  Today we will simply show you how to automatically number a column in Excel.

Did you ever want to number a column but you didn't want to type all the numbers in?  Here's the easy way to do it:

Open up a blank Excel worksheet and type in the numbers 1 and 2 the cells where you want to start numbering a column.  Next, highlight the cells with the numbers 1 and 2 in them and grab the bottom right hand corner of the highlighted box.  When your pointer turns into a small black cross left click and hold the button down while you drag the highlighted area down the column.  Drag down until you have covered the area where you'd like the ordered numbers to appear then let go of the button.  The numbers 1 and 2 established the pattern that you want the computer to follow down the row.  When you let go you should see the pattern has been repeated through all the cells you have selected automatically:

Featured YouTube Video
Sorting Data

 

PRACTICE ACTIVITY In the example above you established the pattern for the numbering in the column by putting numbers in the top two cells.  Try using the same method to create these patterns in Excel:

TO KEEP ON LEARNING:  To learn more shortcuts to common tasks in Excel try searching the internet for:

Excel tips and tricks
Creating Sequences in Excel
Numbering in Excel

 

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

 

==============

Free Quotes Slides

===============

    2006 180TechTips.com