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
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.
This was extremely helpful! I was able to make some wo2p printables for my personal sized Filofax in like 20 minutes! THANK YOU!
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
I am going to try this, as I need a less complicated planner layout
@Wendaful you’re literally the gift that keeps giving! Stumbled across your blog on Pinterest & my Filofax has never looked better! Thanks girl!!!
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!
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 🤗🤗🤗
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. :)
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
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~^^
Thank you! I knew there had to be a way too do this. Wonderful tutorial!
-Thank you! I've searched for a tutorial like this for month! Thank you very much again! :D
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
Just saw your video. I just started the planner adventure and this was exactly what I was looking for. Thanks for sharing!
WOWEEEE!!!!! THANK YOU!! Really needed that help!! Now - on to planning!!
Love the video! Very explanatory and easy to understand. Will save so if I need to go back I can
Great video! I was looking to customize to my liking and this video is the BEST! Thanks for sharing...
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!!
Wow I can’t wait to try this out so that I can customize on my need to my planner thank you so much
Excellent video! You take the intimidation out of using Excel! Thanks for sharing!
OMG YES!!! Thank you for sharing this 😆😆
You’re amazing for this 🙌🏿 my next project!
Omg this was sooooo helpful. I needed this so bad. Thank you.. I appreciate it!
Awesome. I’m gonna give it a try.
This was super duper helpful!!!! Thank you soooo much!!!
So helpful!!!! Thank you so much for the tutorial🌷🌹🌸
I did it! Excellent instructions!
I love this. It makes it so much easier for me.
Yessssss!! Thank youuuuuu after searching for so long 😭😭
Thank you for this video!
Thanks! This was really helpful!
Thank you for sharing this information.
very simple and useful . thanks : )
Well done!!! Thank you.
Nice done!! thank you very much!! was very helpfull to me
Awesome, thank you
Thank you!!!
Thank you for share!!!
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?
Thank you.
So grateful for you and I appreciate what you do for the planner community, but this is just too complicated for me!
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
Hoping you can point me in the direction of how to print the inserts you have on your site for the personal planner? Thanks.
Thanks a lot
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?
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?
For someone with vision problems this is hard to follow but thank you for sharing.
I can do all things through Excel, which strengthens me
Does anyone know how to get the calendar to print double sided?
What weight paper do you print these out with? Thanks so helpful!
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.
Could you do an updated version? Now that you have been using it for some time? :)
Could you please make a tutorial on how you print them and use them as your planner? Thanks!
This is wonderful! What excel program are you using?
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
7 жыл бұрын
Ashley Palmer I would have looked at the layout first before I bought them. Then returned them if I still wasn't happy
Smart and easy. How didn’t I think of that 😑
Thank you so much for sharing! Loved it!! But I also loved your wallpaper. May I ask where can I get it?
@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
8 жыл бұрын
+PintaseSarapintas I found it on etsy s-media-cache-ak0.pinimg.com/736x/86/fe/4e/86fe4e9eb8a40b7b2ac733b140221247.jpg
do you know how to do this in the newer version of excel?
Hi, I want to make a vertical weekly layout for my B6, would you mind helping me?
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
8 жыл бұрын
+Sandy Prater Same here :(
@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
4 жыл бұрын
@@webkitten but how do we get to customise the size
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
8 жыл бұрын
+Heather R i have the same problem. Also i believe the Apple computer makes a difference idk
@grmarose
6 жыл бұрын
I have the newer version of Excel, as well. I don't have the option you speak of.
How do I resize the pages and margins for HP micro notes paper size?
Cute for just a print planner. Was hoping for something more interactive with data.
Could you do one of these making a month calendar??
I'm having trouble printing front and back.. the boxes don't watch up on the other side
What paper do you use to print? Do you cut them yourself??
make this video with your midori printables!!! :D
How do you make a layout wherein there is four inserts in one page for pocket size? The usual paid inserts in etsy.
Thank you. Save as PDF : )
Hey hai, how to make Page setup in ms 2016?
Will the steps be the same for PC?
What version of excel are you using?
that was SUPER helpful thanx a million wish u all the blessings dear :)
How do I set my page to mulberry?I don't have that
Hi! WENDAFUL ! can you give me the size of the pages please ? the inches ?the first part please , or anyone pleasee
Hi Wendaful, I've tried printing your PDF A5 printables from your website but they are coming out too big...can you help? Thanks
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
Can this be done in google sheets? I don't have excel. ☹️
This is so long ago-but do you have any printing tips?!? Appreciate this tutorial but now I'm stuck on printing!
@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/
When I go to print and prints opposite side.
I'm going to try this because I can't do it in word, publisher or affinity publisher lol. I can use excel
No print out to see the results ? Okay I'll take it !! 🙋
What if I want to make a B6 TN insert?
@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?
Besides inserts, which are easy, how about making one that works with data.
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
8 жыл бұрын
+Lisa Gordon I was thinking it might be the version of excel used?
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
How do you print these pages out?
@shirleytaylor3661
9 жыл бұрын
Press print
@marym5037
6 жыл бұрын
How do you print both tables on the same page? I do not want to print one page at a time
Can't figure out how to change the page size. :(
ma 0,35° quanti centimetri sarebbero?
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
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
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:
This is easier to do in word
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!!!!!!!!!!!!!!!!!!!!!!!!
you really should slow down so we can kind of follow you a little bit more
Really not even 5 min into the video n you set a commercial. Next
i hate it because it makes a download then virus use your own brain
@danabynum8625
7 жыл бұрын
Ivy Icy n
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??
I was able to make my own inserts! Thank you!!!
Thank You!!