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!

	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
===============