How to Make Planner Inserts Using Microsoft Excel

Тәжірибелік нұсқаулар және стиль

Finally! A tutorial on how I make my inserts! I usually use Microsoft Excel for my weekly pages. Stay tuned for a Microsoft Word and daily pages tutorial soon!
Find premade inserts for your planners at my blog:
www.wendaful.com
www.etsy.com/shop/wendafuldes...
Learn how to create planners in Adobe Indesign here: www.sprucerd.com/automating-calendars-wenda
~-~~-~~~-~~-~
Watch my updated planner setup: "A5 Filofax Osterley Planner Flip Through & Setup"
• A5 Filofax Osterley Pl...
~-~~-~~~-~~-~
0:00 Introduction
0:34 Setting up your paper size
1:33 Adjust margins
3:03 Adjust the columns
3:14 Use the cells as sections on your inserts
3:34 Don't forget to leave some room for hole punching!
4:02 Use borders to make your lines
6:03 Align everything the way you like
6:31 Blank columns for hole punching
7:52 Change fonts to make it pretty!
9:23 Customize your inserts the way you want
10:37 Middle Title

Пікірлер: 120

  • @sherryshell55
    @sherryshell558 жыл бұрын

    Soooo glad I found this video! No more searching for the right pages for me and NEVER finding them! Thank you so much for this video.

  • @daniellewarner4214
    @daniellewarner42148 жыл бұрын

    This was extremely helpful! I was able to make some wo2p printables for my personal sized Filofax in like 20 minutes! THANK YOU!

  • @coffeechatgirl
    @coffeechatgirl7 жыл бұрын

    Wenda, Hi, I am so happy I found your channel. This excel video on how to make planner inserts was extremely helpful and easy to follow. Thanks so much. Have a great day!! Robyn

  • @claud1able
    @claud1able2 күн бұрын

    I am going to try this, as I need a less complicated planner layout

  • @jwilder13450
    @jwilder134506 жыл бұрын

    @Wendaful you’re literally the gift that keeps giving! Stumbled across your blog on Pinterest & my Filofax has never looked better! Thanks girl!!!

  • @JJandJPublishing
    @JJandJPublishing8 жыл бұрын

    Thank you, Wenda! I grew out of the DIY Planner I made on my Channel and when I got my new Apple computer, I wanted to take it a step further and customize my own pages, but I did not know how to use Microsoft Excel. You're a "Wendaful" instructor! I can do it now, and I'll share your video on my Channel! God Bless - you are detailed and patient! I also Subscribed!

  • @maritamgt
    @maritamgt6 жыл бұрын

    Thank you sooo much for sharing this! It's detailed and you don't rush through the tutorial 💖 I'm looking forward to the other tutorials 🤗🤗🤗

  • @PlumeDeSuccess
    @PlumeDeSuccess9 жыл бұрын

    This video is a real money saver!!! Thank you so much for taking the time to share your tips. I am (probably) almost done with my planner pages and they look great. :)

  • @rebeccamesa4892
    @rebeccamesa48927 жыл бұрын

    Thanks for making this video. Took me awhile to get through this since I kept pausing while I worked on my own inserts. Very helpful

  • @seoulologyy
    @seoulologyy9 жыл бұрын

    Just bought a planner w/o any inserts because the planner I wanted w/ inserts was sold out, so this is super awesome! Thanks for sharing~^^

  • @angelamoore5903
    @angelamoore59037 жыл бұрын

    Thank you! I knew there had to be a way too do this. Wonderful tutorial!

  • @AnnaMongatti
    @AnnaMongatti9 жыл бұрын

    -Thank you! I've searched for a tutorial like this for month! Thank you very much again! :D

  • @MsBonniBee
    @MsBonniBee6 жыл бұрын

    Thank you SO much for sharing this money saving tip!! I'm going to design mine now, to the size I want & with pretty fonts

  • @nanmckee54
    @nanmckee543 жыл бұрын

    Just saw your video. I just started the planner adventure and this was exactly what I was looking for. Thanks for sharing!

  • @mckenna8663
    @mckenna86638 жыл бұрын

    WOWEEEE!!!!! THANK YOU!! Really needed that help!! Now - on to planning!!

  • @bridgettetullos842
    @bridgettetullos8426 жыл бұрын

    Love the video! Very explanatory and easy to understand. Will save so if I need to go back I can

  • @SoloImpressions
    @SoloImpressions7 жыл бұрын

    Great video! I was looking to customize to my liking and this video is the BEST! Thanks for sharing...

  • @heyprettykeepsmiling
    @heyprettykeepsmiling9 жыл бұрын

    One of the best tutorials I've seen :) It's super helpful for me and now I can make my planner for my own taste :) Thank you!!

  • @nicoledickerson9662
    @nicoledickerson96625 жыл бұрын

    Wow I can’t wait to try this out so that I can customize on my need to my planner thank you so much

  • @sharonwhite1619
    @sharonwhite16199 жыл бұрын

    Excellent video! You take the intimidation out of using Excel! Thanks for sharing!

  • @ivett.e
    @ivett.e9 жыл бұрын

    OMG YES!!! Thank you for sharing this 😆😆

  • @JustRaiya16
    @JustRaiya164 жыл бұрын

    You’re amazing for this 🙌🏿 my next project!

  • @Lisa_Zapata
    @Lisa_Zapata9 жыл бұрын

    Omg this was sooooo helpful. I needed this so bad. Thank you.. I appreciate it!

  • @cameronheinz3659
    @cameronheinz36594 жыл бұрын

    Awesome. I’m gonna give it a try.

  • @shyspanisheyes
    @shyspanisheyes9 жыл бұрын

    This was super duper helpful!!!! Thank you soooo much!!!

  • @opaldenja80
    @opaldenja806 жыл бұрын

    So helpful!!!! Thank you so much for the tutorial🌷🌹🌸

  • @annamarieh333
    @annamarieh3338 жыл бұрын

    I did it! Excellent instructions!

  • @jacquelinesbasketarrangeme4914
    @jacquelinesbasketarrangeme49143 жыл бұрын

    I love this. It makes it so much easier for me.

  • @sameenaarr9595
    @sameenaarr95958 жыл бұрын

    Yessssss!! Thank youuuuuu after searching for so long 😭😭

  • @NikitaBx2
    @NikitaBx29 жыл бұрын

    Thank you for this video!

  • @IbelSe
    @IbelSe5 жыл бұрын

    Thanks! This was really helpful!

  • @veganhomeschoolmom
    @veganhomeschoolmom4 жыл бұрын

    Thank you for sharing this information.

  • @noormansour6311
    @noormansour63117 жыл бұрын

    very simple and useful . thanks : )

  • @NolaGB
    @NolaGB8 жыл бұрын

    Well done!!! Thank you.

  • @Kyrusa
    @Kyrusa9 жыл бұрын

    Nice done!! thank you very much!! was very helpfull to me

  • @freluv34
    @freluv349 жыл бұрын

    Awesome, thank you

  • @sophieyancey4774
    @sophieyancey47748 жыл бұрын

    Thank you!!!

  • @dianejoseph7464
    @dianejoseph74647 жыл бұрын

    Thank you for share!!!

  • @Jenna1814
    @Jenna18149 жыл бұрын

    I Love this, thank you thank you thank you. this is sweet. i am trying to find a less extensive way of doing this. I am getting a filofax (they are the only ones that have the color i want.) would there be a way i could get the pages to fit that?

  • @dudswoo
    @dudswoo9 жыл бұрын

    Thank you.

  • @yolandahenry7791
    @yolandahenry77914 жыл бұрын

    So grateful for you and I appreciate what you do for the planner community, but this is just too complicated for me!

  • @katrinagallegos3785
    @katrinagallegos37855 жыл бұрын

    This might help for those using PC & not MAC for page set up : Page Set Up>Options>Detailed Setting>Custom Paper Size>enter width & height>OK>OK I was not able to name is,it just defaults to Custom Paper

  • @amarierayne
    @amarierayne9 жыл бұрын

    Hoping you can point me in the direction of how to print the inserts you have on your site for the personal planner? Thanks.

  • @prana76
    @prana768 жыл бұрын

    Thanks a lot

  • @donnaprice524
    @donnaprice5249 жыл бұрын

    love your video!! I do have a question how do you print this for a personal size planner. would you print on a 8.5 x 11 sheet and cut down to the personal size?

  • @rondab3376
    @rondab33766 жыл бұрын

    This was most helpful, especially the one tip at the end to save as a .pdf. I have been struggling to print what I make, and I think that may solve the problem. One request: I would really like to make a dated version without having to enter all the dates by hand. Are there tricks for that?

  • @lillyc6527
    @lillyc65276 жыл бұрын

    For someone with vision problems this is hard to follow but thank you for sharing.

  • @featherspy
    @featherspy3 жыл бұрын

    I can do all things through Excel, which strengthens me

  • @ruthd7756
    @ruthd77569 жыл бұрын

    Does anyone know how to get the calendar to print double sided?

  • @tammydoll7740
    @tammydoll77405 жыл бұрын

    What weight paper do you print these out with? Thanks so helpful!

  • @MrsA2801
    @MrsA28018 жыл бұрын

    I guess I have an old version of Excel. I can't see the Page Layout option in there and my sheet doesn't look like yours when I try to adjust things.

  • @eirinibarmpati3532
    @eirinibarmpati35325 жыл бұрын

    Could you do an updated version? Now that you have been using it for some time? :)

  • @apurvahegde7761
    @apurvahegde77617 жыл бұрын

    Could you please make a tutorial on how you print them and use them as your planner? Thanks!

  • @kathy6783
    @kathy67839 жыл бұрын

    This is wonderful! What excel program are you using?

  • @ashleyyoe1336
    @ashleyyoe13367 жыл бұрын

    This tutorial really helped me out! Ive bought two planners for this year now only to be disappointed that both had weekly layouts that started on Monday, not Sunday like I wanted! My only question for you (or anyone reading this) how does this work on printing normal sized paper (8.5x11). I plan on purchasing a little bit of thicker printer paper (24 lb to 30 lb) but I wasn't sure how it worked out for others!

  • @BiancaMH

    @BiancaMH

    7 жыл бұрын

    Ashley Palmer I would have looked at the layout first before I bought them. Then returned them if I still wasn't happy

  • @meerasoress1772
    @meerasoress17726 жыл бұрын

    Smart and easy. How didn’t I think of that 😑

  • @PintaseSarapintas
    @PintaseSarapintas9 жыл бұрын

    Thank you so much for sharing! Loved it!! But I also loved your wallpaper. May I ask where can I get it?

  • @mrsfuzzypinkpajamaz

    @mrsfuzzypinkpajamaz

    9 жыл бұрын

    PintaseSarapintas I'm not positive, but this looks similar - you make it yourself following instructions on this site iheartplanners.com/2015/03/13/organize-computer-desktop/

  • @webkitten

    @webkitten

    8 жыл бұрын

    +PintaseSarapintas I found it on etsy s-media-cache-ak0.pinimg.com/736x/86/fe/4e/86fe4e9eb8a40b7b2ac733b140221247.jpg

  • @SunshineLeclair
    @SunshineLeclair7 жыл бұрын

    do you know how to do this in the newer version of excel?

  • @pinkprincess7161
    @pinkprincess71615 жыл бұрын

    Hi, I want to make a vertical weekly layout for my B6, would you mind helping me?

  • @dostagirl9551
    @dostagirl95519 жыл бұрын

    I must have a different version of Excel b/c when I go to page setup (not listed under file but instead under page layout), it won't let me customize the page size.

  • @bitterrberry

    @bitterrberry

    8 жыл бұрын

    +Sandy Prater Same here :(

  • @webkitten

    @webkitten

    8 жыл бұрын

    +Sandy Prater Found it! Go to the "View" tab and then click the "Page layout" on the top left. (Mine was in "normal" and then looks similar to Wendaful's when I clicked "page layout"). Confusing since there is a "page layout" tab!

  • @OurSimpleLyfe

    @OurSimpleLyfe

    4 жыл бұрын

    @@webkitten but how do we get to customise the size

  • @heatherr5196
    @heatherr51968 жыл бұрын

    What version of Excel is this? Because I have a newer version I believe and when I go into "page setup" it doesn't offer an "options" button like yours. Any recommendations?

  • @DerrickCrystalMitchell

    @DerrickCrystalMitchell

    8 жыл бұрын

    +Heather R i have the same problem. Also i believe the Apple computer makes a difference idk

  • @grmarose

    @grmarose

    6 жыл бұрын

    I have the newer version of Excel, as well. I don't have the option you speak of.

  • @MammaDoulas
    @MammaDoulas5 жыл бұрын

    How do I resize the pages and margins for HP micro notes paper size?

  • @WenSaiPanther
    @WenSaiPanther6 жыл бұрын

    Cute for just a print planner. Was hoping for something more interactive with data.

  • @brianneboltinghouse1121
    @brianneboltinghouse11217 жыл бұрын

    Could you do one of these making a month calendar??

  • @JasminPlans
    @JasminPlans9 жыл бұрын

    I'm having trouble printing front and back.. the boxes don't watch up on the other side

  • @brianneboltinghouse1121
    @brianneboltinghouse11217 жыл бұрын

    What paper do you use to print? Do you cut them yourself??

  • @CheyenneJerkFacePena
    @CheyenneJerkFacePena8 жыл бұрын

    make this video with your midori printables!!! :D

  • @JB-wv4oh
    @JB-wv4oh2 жыл бұрын

    How do you make a layout wherein there is four inserts in one page for pocket size? The usual paid inserts in etsy.

  • @dcrunicycles
    @dcrunicycles6 жыл бұрын

    Thank you. Save as PDF : )

  • @LearnWithSNR
    @LearnWithSNR4 жыл бұрын

    Hey hai, how to make Page setup in ms 2016?

  • @robinspear7895
    @robinspear78952 жыл бұрын

    Will the steps be the same for PC?

  • @anchy15ful
    @anchy15ful8 жыл бұрын

    What version of excel are you using?

  • @MsLadyMuslima
    @MsLadyMuslima9 жыл бұрын

    that was SUPER helpful thanx a million wish u all the blessings dear :)

  • @alexisbrad4248
    @alexisbrad42486 жыл бұрын

    How do I set my page to mulberry?I don't have that

  • @rocioportocarrero180
    @rocioportocarrero1807 жыл бұрын

    Hi! WENDAFUL ! can you give me the size of the pages please ? the inches ?the first part please , or anyone pleasee

  • @happymeonabudget9246
    @happymeonabudget92468 жыл бұрын

    Hi Wendaful, I've tried printing your PDF A5 printables from your website but they are coming out too big...can you help? Thanks

  • @ketaminajolie9501
    @ketaminajolie95015 жыл бұрын

    Guys who couldnt get past paper size setup... you can just print to the size of paper that you have after clicking print>change paper size to custom and you should be ok

  • @Hockeyhoney87
    @Hockeyhoney874 жыл бұрын

    Can this be done in google sheets? I don't have excel. ☹️

  • @katiericks6529
    @katiericks65297 жыл бұрын

    This is so long ago-but do you have any printing tips?!? Appreciate this tutorial but now I'm stuck on printing!

  • @Wendaful

    @Wendaful

    7 жыл бұрын

    Hi! I have a blog where I update more frequently. Here is a blog post on how to print: www.wendaful.com/2016/04/print-wendaful-planner-inserts/ and another one here: www.wendaful.com/2014/08/how-to-print-filofax-inserts-on-mac/

  • @christinabergman-independe3257
    @christinabergman-independe32576 жыл бұрын

    When I go to print and prints opposite side.

  • @iamsunflower2011
    @iamsunflower20114 жыл бұрын

    I'm going to try this because I can't do it in word, publisher or affinity publisher lol. I can use excel

  • @Serenityafterall
    @Serenityafterall5 жыл бұрын

    No print out to see the results ? Okay I'll take it !! 🙋

  • @pinkprincess7161
    @pinkprincess71615 жыл бұрын

    What if I want to make a B6 TN insert?

  • @LovelyTrueRed

    @LovelyTrueRed

    5 жыл бұрын

    Hello, did you ever find out how to create inserts for the TN? If yes, do you have a link to the how to?

  • @WenSaiPanther
    @WenSaiPanther6 жыл бұрын

    Besides inserts, which are easy, how about making one that works with data.

  • @SoulfulXprssion
    @SoulfulXprssion8 жыл бұрын

    Hey....I just ran across your blogspot on Pinerest--I was excited to see your planners done in excel. However I am having difficulty following your method. I opened a workbook and attempted to follow the same steps in your video but could not find where you were working to set page size and etc. I see that you have a background behind the workbook where i discovered there is another command bar area with an additional excel, file, edit, view, and etc seperate from the one on the actual workbook itself. This is where my problem lies. Can you help me. :)

  • @SoulfulXprssion

    @SoulfulXprssion

    8 жыл бұрын

    +Lisa Gordon I was thinking it might be the version of excel used?

  • @RunwayCats
    @RunwayCats6 жыл бұрын

    My margins dont let me play with the margin on my page. There's header and footer and it's uneven I hate this so much spent 3 hours trying to fix i

  • @cassideethornhill8796
    @cassideethornhill87969 жыл бұрын

    How do you print these pages out?

  • @shirleytaylor3661

    @shirleytaylor3661

    9 жыл бұрын

    Press print

  • @marym5037

    @marym5037

    6 жыл бұрын

    How do you print both tables on the same page? I do not want to print one page at a time

  • @BE-More1111
    @BE-More11114 жыл бұрын

    Can't figure out how to change the page size. :(

  • @martinamilesi3843
    @martinamilesi38439 жыл бұрын

    ma 0,35° quanti centimetri sarebbero?

  • @MamaKat3
    @MamaKat39 жыл бұрын

    what version of excel are you using? I also see you are using an apple computer... so I wonder if that also makes a difference, because in office 2010, I'm not seeing an A5 size, and when I do what I would normally do and make the page size 1/2 of the page, it still doesn't look how your screen does.

  • @MamaKat3

    @MamaKat3

    9 жыл бұрын

    btw, I figured out a way that works for my version... I put it in landscape, set the paper size to A4, and then use the 5" mark to divide them in half to make 5x8 sheets... now if you want erin condren size sheets, you'd want to copy her measurements and not necessarily use landscape, but I wanted to be able to print 2 to a page, so that's how I did it... I don't need these kind of inserts at this time, but if I go to a ring binder planner, I'll be ready :D

  • @ORLYKimmi

    @ORLYKimmi

    9 жыл бұрын

    MamaKat I actually dont have an A5 size too and was wondering if I follow your directions would it be a perfect A5 fit? c:

  • @panikkk1
    @panikkk16 жыл бұрын

    This is easier to do in word

  • @bev692
    @bev6927 жыл бұрын

    I have to say I could not follow this tutorial. I notice lots of ppl asked what version Excel you were using. as well as other questions. I don't ever see a reply to their questions. It would have helped others with the same question. Sad!!!!!!!!!!!!!!!!!!!!!!!!

  • @ontodaysepisode7425
    @ontodaysepisode74257 жыл бұрын

    you really should slow down so we can kind of follow you a little bit more

  • @QuieroCake
    @QuieroCake3 жыл бұрын

    Really not even 5 min into the video n you set a commercial. Next

  • @ivyicy8518
    @ivyicy85187 жыл бұрын

    i hate it because it makes a download then virus use your own brain

  • @danabynum8625

    @danabynum8625

    7 жыл бұрын

    Ivy Icy n

  • @confidential303
    @confidential3037 жыл бұрын

    this is so amature? and what does Wendaful suppose to mean? I hope not that over 5 years is talking about wendaful istead of wonderfull, where is this world going??

  • @melissabologna3389
    @melissabologna33894 жыл бұрын

    I was able to make my own inserts! Thank you!!!

  • @cheryladamson3665
    @cheryladamson36656 жыл бұрын

    Thank You!!

Келесі