Highlight the entire area from E4 through the end of your list. It is critical that they are spelled the exact same way in Outlook and Excel. Enter the categories into Excel and sort them alphabetically once you are finished entering them. You can add as many categories as you like, although, there are only 25 different colors in Outlook. I would highly recommend renaming them something useful. The default categories are based on color. Click on the “Categorize” icon and a list of all of the categories that have been set up will appear. They can be found in Outlook by going to the calendar section and opening up a new appointment. In cell E3, enter “Categories." Starting in E4, enter all of the categories that you use in Outlook.Highlight B4:B5, and in the “Name Box” in the upper left-hand corner of the screen and name that section “ADE." In cell B3, enter “All Day Event." In cells B4 and B5, enter “Yes” and “No” respectively.Rename one of the tabs “Control” by right-clicking on a tab and selecting “Rename.". Open a new workbook in Excel and save it as “Calendar Upload.xls." It is vitally important to save it as an “Excel 1997 – 2003 Workbook” because Outlook can only update the.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |