Use the following steps:
Type Sunday in cell a1 (as per your requirement)
Select a1:a7
Press alt + f + I and then s
Select auto fill
Select column
hit on ok
Done.
Regards
Mukesh Baviskar
Mobile: 9403161157
--------------------------------------------------
From: "Ashik" <[email protected]>
Sent: Wednesday, July 24, 2013 6:30 AM
To: "Access India" <[email protected]>
Subject: [AI] How to create series in Excel 2007?
Dear Friends,
In Excel 2003, I could easily create series by going to Fill option in the
edit menu. But in Excel 2007, I have some problems. In the Home Ribbon, I
find the option Series, but I can't create the series of days. Yes, I can
create the series of numbers easily. Please describe the steps as to how I
can create the series of days--say, Sunday to Saturday.
Thanking you in advance.
Ashik Hirani
Register at the dedicated AccessIndia list for discussing accessibility of
mobile phones / Tabs on:
http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in
Search for old postings at:
http://www.mail-archive.com/[email protected]/
To unsubscribe send a message to
[email protected]
with the subject unsubscribe.
To change your subscription to digest mode or make any other changes,
please visit the list home page at
http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
Disclaimer:
1. Contents of the mails, factual, or otherwise, reflect the thinking of
the person sending the mail and AI in no way relates itself to its
veracity;
2. AI cannot be held liable for any commission/omission based on the mails
sent through this mailing list..
Register at the dedicated AccessIndia list for discussing accessibility of
mobile phones / Tabs on:
http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in
Search for old postings at:
http://www.mail-archive.com/[email protected]/
To unsubscribe send a message to
[email protected]
with the subject unsubscribe.
To change your subscription to digest mode or make any other changes, please
visit the list home page at
http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
Disclaimer:
1. Contents of the mails, factual, or otherwise, reflect the thinking of the
person sending the mail and AI in no way relates itself to its veracity;
2. AI cannot be held liable for any commission/omission based on the mails sent
through this mailing list..