Share via

Multiple Template in Single Worksheet

Anonymous
2017-03-09T03:45:57+00:00

Hello Sir / Mam,

I am using office 2013, and I am using this since Office 2000. I have to know something, I know office provided thousands of template for all, my question is for Excel. 

How to select multiple template in a single worksheet rather than create different different excel file for each template? For example, Academic Calendar and Student Calendar at the same excel (Sheet 1, Sheet 2, .....).

Thank you. :)

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

3 answers

Sort by: Most helpful
  1. Anonymous
    2017-03-10T12:04:31+00:00

    Calendar is only for example, I asked for use multiple template in single file. If you are not understand me then I asked direct full question.

    I need to use personal expenses, to do list, Academic calendar and home inventory templates in one single excel file so I do not need to create own design start to end. Thank you.

    10+ people found this answer helpful.
    0 comments No comments
  2. Anonymous
    2017-03-10T15:31:03+00:00

    I did understand your question. Look at the first line of my previous reply ....

    <snip>

    Sorry, you cannot associate more than one template with a single file.

    </snip>

    how can I make that clearer?

    1 person found this answer helpful.
    0 comments No comments
  3. Anonymous
    2017-03-09T05:30:15+00:00

    Sorry, you cannot associate more than one template with a single file.

    What is the difference between a "student" calendar, and an "academic" one?

    You would have to build the various calendars on separate sheets in the same workbook.  Make sure if there are any macros in the background that you copy them over too.

    There are many free calendars available on the web. Search to see if you can find one that has all the attributes you are looking for.

    Here are a FEW of the calendar sites I've come across:

    13 Free, Printable Calendarshttp://freebies.about.com/od/free-calenders-to-print/ss/printable-calendar.htm

    These free, printable calendars for 2016 won't just keep you organized, they'll also add a splash of color and style to your office, kitchen, or just about any room in your home. They truly meld style and function, and you'll be amazed at the calendars you can get for free. There's a variety of printable calendars for 2016 here that include monthly calendars as well as complete planners to help you plan every week and even every day. The styles vary too, you'll find very simple black and white calendars and colorful calendars that are meant to inspire. You really can't go wrong with all the choices here. If you're looking for a different way to keep organized this year, I also have a list of my favorite online calendar systems and some free calendar templates for your favorite word processor.

    Calendar Chart!http://www.powerpivotpro.com/2012/08/introducing-the-calendar-chart/

    It’s formulas.  In the normal Excel grid. The really nifty thing is that I did NOT manually enter calendar months into the grid.  This is all driven off of a PowerPivot date table. In other words, this visualization responds to slicers!  I can change the measure displayed… In fact, I could change my calendar table to span the years of, say, World War Two and it would just work.  There is nothing special about the years and months displayed above.

    Calendar Maker Add-In (Word)http://gregmaxey.mvps.org/word_tip_pages/calendar_maker_addin.html****The purpose of this Microsoft Word Tips & Microsoft Word Help page is to provide and publish a simple Word template add-in for creating perpetual calendars.

    You can use the add-in to create a calendar for this year, next year, last year or any year between 1900 and 2100).

    When loaded, the add-in propagates a custom group "Perpetual Calendar" to the Word 2007/2010 Ribbon Add-Ins tab

    Calendars at Office.com Templates- https://templates.office.com/en-us/Calendars

    Create a perpetual year or month calendar (Word)http://www.gmayor.com/CalendarMacro.htm****The function began life as a solution to a user query about changing the dates on a Microsoft template, but quickly changed direction to become the following.

    Create interactive calendar to highlight events & appointments [Tutorial]**http://chandoo.org/wp/2013/04/09/how-to-create-interactive-calendar-to-highlight-events-appointments-tutorial/******One of the popular uses of Excel is to maintain a list of events, appointments or other calendar related stuff. While Excel shines easily when you want to log this data, it has no quick way to visualize this information. But we can use little creativity, conditional formatting, few formulas & 3 lines of VBA code to create a slick, interactive calendar in Excel. Today, lets understand how to do this.

    free calendar templates for your favorite word processor.

    Free Online Calendarshttp://freebies.about.com/od/online-calendars/tp/free-online-calendars.htm****Free online calendars are a great way to manage your life from home, work, and on the go. Not only do these free online calendars allow you to keep track of events and special dates, they also let you set reminders, send invitations, share and organize with your family members, friends, or co-workers, and generally manage your whole life. There are a lot of other features to these free online calendars as well. Some of them have address books, lets you manage photos, allow you to uplo

    Interactive Pivot Table Calendar & Chart in Excel!http://chandoo.org/wp/2012/09/12/interactive-pivot-calendar/

    ***Can we make a calendar using Pivot Tables?!?***Of course we can. Today let us learn a simple technique to create calendar style reports using Pivot tables.

    Monthly Planner Template [downloads]http://chandoo.org/wp/2015/08/28/monthly-planner-template/Here is an awesome planner template to help you manage activities over a month. It is useful for charity drives, activity planning, school schedules, marketing initiatives, project planning etc.

    PocketMod applethttp://pocketmod.com/index.html -create & Print 8:1 page folding booklets using the online applet. Many predefined templates ie: Music Staff sheet, various calendars, lined pages, Storey Board, conversions, math formulas, tip table (15%, 20%), Emergency Contacts.  Ofline download version PDF-to-Pocketmod

    1 person found this answer helpful.
    0 comments No comments