ICON Home Page ICON Members' Forums Home Page
Members' Forums
Username:
Password:
Save Password Forgot your Password?

Home | Profile | Register | Active Topics | Members | Search | FAQ
 
 All ICON Forums
 Help Forums
 Office Applications
 Excel 2007 number sequence
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Mary
Operating Member

368 Posts

Posted - 09/14/2010 :  23:39:49  Show Profile  Reply with Quote
I remember that there was a way to complete a number sequence or months, days of the week, etc but now I can't recall how to do it.
Help please.
Mary

Win 7, 2.211 GHz and Vista

D.Oliver
Moderator

868 Posts

Posted - 09/15/2010 :  06:42:23  Show Profile  Reply with Quote
Type in 2 or three numbers, months, whatever the sequence is. Highlight the items (you know, select them both as normal) and (easy way) hover your mouse over the lower-right corner of the last cell you typed in. When the pointer changes to a small "Plus sign", hold the left mouse button down and drag until you fill the required cells remaining in your sequence.

You can learn more by searching "Autofill" in the Help section.

I hope this helps.

David
"One of the greatest things about the Internet is that you can quote something and totally make up the source."
--- Thomas Jefferson



Velocity Micro, Vista Ultimate 32-bit/SP2, Intel Core 2 Duo 2.66Ghz, 4GBRam, 400GB HDD, 320MB nVidia 8800GTS, Networked, 2-Way Satellite, 250 GB External Network HDD
Go to Top of Page

Mick
Administrator

1496 Posts

Posted - 09/15/2010 :  13:47:09  Show Profile  Visit Mick's Homepage  Reply with Quote
Or you could come to my class next Tuesday at the Library Center, 10am-3pm, on Spreadsheets.

(cheap plug)
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
ICON Computer Users Group © Interactive Computer Owners' Network Go To Top Of Page
Snitz Forums 2000