ICON Home Page ICON Members' Forums Home Page
Members' Forums
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  

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.

Win 7, 2.211 GHz and Vista


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.

"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


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