how can i make a calender in MS excel?

Answer 1

Try this link for a download of a calender template from microsoft. http://office.microsoft.com/en-us/templates/CT101043131033.aspx There is some for MS Word and MS Excel

Answer 2

Well
If the calendar templates in Microsoft.com are not enough for you
You can download the Excel file I made to obtain the calendar fro every year you specify and/or month
it is here
http://shiekhali.com/anmar
then go to My Projects and in the Free Applications part, you will see the Calendar excel file, download it and enjoy

Enjoy my profile, I am the VBAXLMan

Answer 3

highlight the columns and rows and set the height and width then highlight the the rows and columns your gonna use and right click and format go to the alignment tab and set it to where you want the numbers to show up then go to the borders tab to make a outline border and inside border of the calendar. Any more questions just pm me.

Answer 4

Select

File -
new -
general templates-
calender wizard
from menu

Answer 5

Make a calendar in Excel:

=IF(MONTH(DATE(YEAR(NOW()),MONTH(NOW()),1))
<>MONTH(DATE(YEAR(NOW()),MONTH(NOW()),1)-
(WEEKDAY(DATE(YEAR(NOW()),MONTH(NOW()),1))-1)+
{0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}-1),"",DATE(YEAR(NOW()),
MONTH(NOW()),1)-(WEEKDAY(DATE(YEAR(NOW()),
MONTH(NOW()),1))-1)+{0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}-1)

To use it:

1. Copy the formula text to the clipboard
2. Activate an Excel sheet and select a 7-col by 6-row range
3. Press F2
4. Press Ctrl+V to paste the formula into the active cell
5. Press Ctrl+Shift+Enter (to make it a multicell array formula)
6. Format the cells using the "Date" number format.

Voila! You have a calendar for the current month. For a template, go to http://www.vertex42.com/ExcelTemplates/excel-calendar-template.html

I would still prefer to use the Outlook calendar if I were you.

PS: If you can't see the code properly, go to this link http://slackermanager.com/2005/04/make_a_calendar.html

Answer 6

You can download calendars from Microsoft.
http://office.microsoft.com/en-us/clipart/default.aspx

Answer 7

I would suggest you use Outlook, since Excel is for spreadsheets.

Answer 8

I don't have any idea, but if you are looking for a free 2007 calendar, use this link.
http://www.incompetech.com/
Select calendars on the left - monthly or yearly.

Answer 9

you can go to microsoft.com and go to the template page, there you can download all kinds of templates for calendars.