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