How to Make a Weekly Schedule in Excel

How to Make a Weekly Schedule in Excel - Tutorial

Рет қаралды 515,821

Күн бұрын

Excel tutorial on how to make a weekly schedule in Excel to keep you organized. We'll make a weekly planner so that you can schedule meetings by selecting your appointments from a dropdown menu available in each time slot.
The calendar dates in the planner also use a formula so that you can add more weeks to your workbook and easily link your planners together.
Using a weekly planner in Excel can help keep you track meetings and other appointments during your workweek and weekend days.
For more about how to link sheets in Excel, make sure to watch this tutorial: • Ways to Link Sheets in...
If you liked this, make sure to get your FREE pdf list of top Excel keyboard shortcuts: yacostasolutions.com/newsletter/
*FYI:
This tutorial was created using the desktop version of Excel in Microsoft 365. You can upgrade to this version here: yacostasolutions.com/MS365
The screen recording + editing was done using Techsmith Camtasia. You can check it out here: yacostasolutions.com/camtasia
Thanks for watching this Microsoft Excel tutorial and, don’t forget, if you like this video, please “Like” and “Share” with your friends - it really helps us out 😊
To catch our Excel tutorials as they come out, subscribe to this channel by clicking: yacostasolutions.com/youtube
Thanks!
*DISCLAIMER: This video description contains affiliate links, which means that if you click on one of the product links, I’ll receive a small commission. As an Amazon Associate I earn from qualifying purchases. This helps support the channel and allows us to continue to make tutorials like this. Thank you for your support!
#YAcostaTutorials

Пікірлер: 258

@kellyleon4070 2 жыл бұрын

This tutorial was absolutely amazing! So concise and easy to follow! I appreciate it greatly :)

@YAcostaSolutions 2 жыл бұрын

That’s awesome, Kelly! I’m so happy you liked this 🙂

@kimia1664 3 жыл бұрын

Awesome! Short and useful. No time wasted. It's so hard finding efficient educational videos. Great job!

@YAcostaSolutions 3 жыл бұрын

Thank you so much 🙂 I'm happy this was useful for you.

@jamesmurphyelizondoes7586 2 жыл бұрын

I love how you explain things. Very clear and concise. Excellent!

@YAcostaSolutions 2 жыл бұрын

Thank you, James. I really appreciate your feedback. I’m glad you liked this 🙂

@azca659 4 жыл бұрын

Thank you so much YAcosta Solutions, this really helps a lot, much appreciated, bless you!

@YAcostaSolutions 4 жыл бұрын

Thanks, Rafie! I’m excited this helped you out 🙂

@harshadkondalkar1502 4 жыл бұрын

fast and straight to the topic. EXCELLENT.

@YAcostaSolutions 4 жыл бұрын

Thank you so much, Harshad! I really appreciate the compliment 🙂

@samtaufao 2 жыл бұрын

Thank you for sharing your knowledge to benefit many. Awesome work and may you be richly rewarded.

@YAcostaSolutions 2 жыл бұрын

Thank you, Samuelu. That’s very kind of you 🙂 I’m glad you liked this tutorial.

@precellajb1414 3 жыл бұрын

Thank you soo much for this. The whole video was highly informative and Just plain Brilliant!

@YAcostaSolutions 3 жыл бұрын

What kind feedback! Thanks so much. I’m happy this helped you 🙂

@user-sx2yo6sv2h 5 жыл бұрын

Nice. Thank you for sharing. Having been preparing for the exam. This is what I'm looking for. :)

@YAcostaSolutions 5 жыл бұрын

Thank you, 刘文蒞 and best of luck with your exam! 🏆

@johnl.d8238 2 жыл бұрын

Thank you so much for this tutorial, easy to follow and understand.

@YAcostaSolutions 2 жыл бұрын

Glad you enjoyed it! Thanks 🙂

@childmauler3000 3 жыл бұрын

Thank you for the tutorial, super helpful!

@YAcostaSolutions 3 жыл бұрын

Thank you 🙂 Glad it was helpful!

@user-di4js6xw9n 4 жыл бұрын

Thank you so much for this video! You're explanation is very concise and goes right to the point😃

@YAcostaSolutions 4 жыл бұрын

Thank you, Niharika Jagdish. That’s sweet of you to comment 🙂 Happy this was helpful for you!

@elianomillan553 3 жыл бұрын

Kudos for the video content! Apologies for butting in, I would love your thoughts. Have you considered - Weydaniel Organized Dominator (Have a quick look on google cant remember the place now)? It is a good exclusive guide for getting 7000 plus project management and business templates without the headache. Ive heard some pretty good things about it and my mate got cool success with it.

@growinlife4617 2 жыл бұрын

This tutorial was really Amazing, straight to the point & very helpful for me👌

@YAcostaSolutions Жыл бұрын

That’s great! I’m so glad this helped you 🙂

@dreiruzz8829 Жыл бұрын

Excellent! This video tutorial is clear and easy to follow! Thank you so much for your great work! It helped a lot:)

@YAcostaSolutions Жыл бұрын

Yay! I’m so happy this helped you 🙂 Thanks so much!

@Salaom7 Жыл бұрын

Thank you your Royal Highness Queen of Excel!

@YAcostaSolutions Жыл бұрын

What a generous compliment! Thank you ☺️ I’m so happy you liked this !

@jakonarida6236 3 жыл бұрын

thank you so much YAcosta solutions this helped me so much god bless you stay safe

@YAcostaSolutions 3 жыл бұрын

Thank you, Yoon! I'm happy this was helpful for you 🙂

@arganahmed7702 3 жыл бұрын

Thank you so much! It helps a lot.

@YAcostaSolutions 3 жыл бұрын

Glad it helped you, Argan! Thanks 🙂

@eronweaver5183 10 ай бұрын

This was fantastic. Thank you!

@YAcostaSolutions 9 ай бұрын

Thanks so much! I'm so glad you liked this so much 🙂

@aadamsheikh8768 3 жыл бұрын

What a detailed and easy-to-follow tutorial! Exactly what i needed, thanks!! Because im making this in late October, the dates take up quite a bit of space when initially entering them. My last day extends over on to the next whole page. I tried changing the page orientation and it all fits in one when on landscape, which is great. However, do you know how i could fit it all in on a portrait page? Thanks, keep up the good work!

@YAcostaSolutions 3 жыл бұрын

Hi, Aadam. You can set this in the Page Setup options. On the Page tab, in the Scaling section, select Fit to and set it to 1 page wide by 1 page tall. Just make sure to check the Print Preview to make sure it's not so small you can't ready it. You could also apply Wrap Text to the dates so you can make the columns smaller. You'll find this in the Home tab, in the Alignment section. Thanks! 🙂

@TanvirSingh97 Ай бұрын

This helped! Thanks! 🙌

@Zorac777 Жыл бұрын

Great work! What I would find very useful is an option to schedule a meeting in between two time slots. For example: Lets assume I have a meeting from 9:45-10:15. Is there also a method to generate a table with flexible times? Alternatively I guess I could increase the granularity for the timeslots from 30 min to 15 min.

@WendyStubbs Жыл бұрын

I watched many of these and yours was the best. Thank you.

@YAcostaSolutions Жыл бұрын

Thanks so much, Wendy! I really appreciate that 🙂

@Sara.Saavedra 6 ай бұрын

Thank you your video helped a lot.

@YAcostaSolutions 5 ай бұрын

Thanks so much! I'm happy this helped you 🙂

@supriyopal5600 2 жыл бұрын

The tutorial was really really helpful and easy to follow. Thank you so much! And your voice is really pleasing to the ears. So, really liked the video!

@YAcostaSolutions 2 жыл бұрын

Thank you so much! I really appreciate the sweet feedback 🙂

@irynasavchenko91 Жыл бұрын

Thank you for this very cool tutorial! I'm gonna use it extensively!

@YAcostaSolutions 11 ай бұрын

That's great, Iryna! I'm happy you liked this so much 🙂

@SigmaChad5140 2 жыл бұрын

Thank you for the tutorial. It is very helpful!

@YAcostaSolutions 2 жыл бұрын

Thanks, Anil! I’m happy this was helpful for you 🙂

@alihemopo416 7 ай бұрын

Thank you very much, I am just learning and you make it look easy😊

@YAcostaSolutions 7 ай бұрын

That’s excellent, Ali! There are so so many things you can do with Excel once you get comfortable with it. I’m so happy my tutorial helped you, at least a little bit, in learning how to use it 🙂

@ravinderpal2282 2 жыл бұрын

Mam your way of teach is so easy many youtubers enlarged content only

@Veronica-go9xy 2 жыл бұрын

very easy to follow! Thank you!

@YAcostaSolutions Жыл бұрын

Thanks, Veronica. I’m happy you liked this 🙂

@FajarSuryawan 3 жыл бұрын

Thank you! It's very helpful. Is it possible to merge some cells?

@sunshine21911 6 ай бұрын

A little too fast paced for me but with pauses and rewinding the steps and visual helped me tremendously. Definitely saved to favorites. Watching this in 12/2023 to get a refresher for a new job!

@YAcostaSolutions 5 ай бұрын

I hope you have great success in your new job! Thanks for watching and commenting 🙂

@stephaniecarlin4703 Ай бұрын

I thought the same thing... I couldn't listen to what she said, process it, AND watch what she was doing and comprehend THAT In such a terribly short amount of time. Stopping, rewinding, rewatching, and sometimes repeating is almost worse because I can't maintain the information in my head for long enough. (OH ADHD, how I love thee! 😂) What you can do, however (even WITHOUT ADHD 😉), is go up to the gear, choose "playback speed", and adjust it accordingly. A number smaller than 1.0 is SLOWER, a number larger than 1.0 is FASTER. (Personally, I can't handle slowing it down any more than 0.75. Voices are obviously affected when speeds change. If it's too slow, they start to sound as if they are in the process of falling asleep... If it's too slow, they start to sound as if they are additional/replacement members of the Alvin and the Chipmunks band! 👉😖👈) Whether you go faster or slower, don't forget to turn it back to normal after you are finished watching that video/videos by that creator!!! 😅😅😅

@franman6076 10 ай бұрын

Thanks! Great vid

@YAcostaSolutions 10 ай бұрын

Glad you liked it! Thanks so much 🙂

@majdyqutub2106 4 жыл бұрын

Appreciated very useful!

@YAcostaSolutions 4 жыл бұрын

Thanks, glorydoctor qutub! I’m happy this was useful to you 🙂

@rajangill4941 3 жыл бұрын

thank you. great video !

@YAcostaSolutions 3 жыл бұрын

Thanks so much, Rajan! I’m happy you liked this 🙂

@monicalewis6212 11 ай бұрын

Thank you so much for this tutorial, its great and I followed along and it all worked well :) thank you!

@YAcostaSolutions 10 ай бұрын

That's great, Monica! I'm so happy this was useful for you 🙂

@barkslife 2 жыл бұрын

Brilliant! 👏 ... very helpful. Thanks 🙂

@YAcostaSolutions 2 жыл бұрын

So happy it was helpful! Thanks 🙂

@tianesbeth8285 Жыл бұрын

Wow, life changing. Thank you!

@YAcostaSolutions Жыл бұрын

That's great! I'm so glad this was useful for you 🙂

@sairaiqbal7647 5 ай бұрын

Its very useful and simple Thanks

@YAcostaSolutions 4 ай бұрын

Thanks so much, Saira! I’m happy this helped you 🙂

@AstroDynamo 4 жыл бұрын

Nice way of explaining and its helpful thx

@YAcostaSolutions 4 жыл бұрын

Thank you, AstroDynamo! I'm happy this was helpful for you 🙂

@alx7123 2 жыл бұрын

awesome tutorial thanks!

@YAcostaSolutions 2 жыл бұрын

Thanks so much! I’m happy you liked this 🙂

@nemzzzy 2 жыл бұрын

I'm new to Excel and this was very helpful, thank you [:

@YAcostaSolutions 2 жыл бұрын

Excellent! I'm so happy this helped you 🙂

@harshpaliwal2756 2 жыл бұрын

thank you for the video

@YAcostaSolutions 2 жыл бұрын

Thank you!! I'm happy you liked this 🙂

@abdelhak_13 2 жыл бұрын

Thank you so much for your hard work, this is great content. I do have a question though, how can we merge cells? I noticed after creating a table, that button is dimmed and I don't know how to undo that.

@richmondannan334 4 жыл бұрын

Hi YAcosta soutions, thanks for the video really helpful. Could you please inform us on a way to quickly add up the time spent on each "separate activities" each day on a sperate table? I am trying to tally the length of time spent on each separate activities at the end of each week. Thanks!

@StarShadow9009 3 жыл бұрын

You are a lifesaver

@YAcostaSolutions 3 жыл бұрын

Thank you so much! I'm happy this helped you 🙂

@ryanfrizzell736 Жыл бұрын

Great. Now I know more about scheduling shifts and thus I can work more efficiently, effectively, and maximize my income.

@YAcostaSolutions Жыл бұрын

That’s excellent, Ryan! I’m so happy this helped you so much 🙂

@mrCetus 2 жыл бұрын

Thank you for providing this information! I'm new to your channel. I'm working on a work bid for 3 agents, and once the agents choose their lines, I would love a way to set up an array (?) so for the duration of that bid we could have a calendar that is auto filled. Is this possible? I'm not sure about my terminology. Thank you!

@AlanAlves1993 4 жыл бұрын

You're the best!

@YAcostaSolutions 4 жыл бұрын

Awww. Thanks, Alan! I'm happy this helped you 😊

@lordstarklordstark2479 2 жыл бұрын

thanks ,it was so helpful

@YAcostaSolutions 2 жыл бұрын

Excellent! I’m happy this was helpful for you 🙂

@rohitinc 3 жыл бұрын

Thanks so much!

@YAcostaSolutions 3 жыл бұрын

Thanks! Happy this helped you 🙂

@trustyprocess5389 3 жыл бұрын

Thank you!!

@YAcostaSolutions 3 жыл бұрын

Thank you!! I'm happy you liked this 🙂

@YAcostaSolutions 4 жыл бұрын

Like this tutorial? Make sure to grab your FREE pdf list of top Excel keyboard shortcuts: yacostasolutions.com/newsletter/

@carolinewrockloff8663 3 жыл бұрын

Hello and thank you for your tutorial! I'm making a weekly schedule for a restaurant so there are some days where I need to schedule two activities for one person. Is there a way to select more than one activity in a column?

@manaralhashmi3743 2 жыл бұрын

Thanks for detailed explanation. May I know where did you click at 1:32 to change the squares to date.

@makarasiek4307 2 жыл бұрын

Thank you for sharing

@YAcostaSolutions 2 жыл бұрын

Thank you for watching 🙂 I’m happy you liked this!

@cretharectormonnet6140 Жыл бұрын

Thanks for your video. I want to create a weekly planner with different start and end times? Can you please explain how to do this?

@anujkalra6145 3 ай бұрын

Thank you for this! Assuming I won't be able to merge cells in this for activities that may take more than a single time slot?

@roxannekentjellyrepormado6465 2 жыл бұрын

Thank you for sharing

@YAcostaSolutions 2 жыл бұрын

Thank you for liking this 🙂

@aiman_shakir Жыл бұрын

Thanks 🥰

@YAcostaSolutions Жыл бұрын

Thank you, Aiman! I'm happy you liked this 🙂

@uhmmm...1797 2 жыл бұрын

I am only in middle school. Everyone was saying make schedule but I didnt know how, This was Very helpfull

@manideepreddybhanuri7398 2 жыл бұрын

I LIKE THE WAY YOU ENDED

@YAcostaSolutions 4 ай бұрын

Thank you 🙂

@MsLILLY117 Жыл бұрын

Wow! Thanks much!!! I am gonna try this for my work today itself!!!! Quick question what if I want to have both the drop down option and and option to type notes in cells when needed. ( appointment that isn't on the drop down option to be typed ) how may i do that please, let me know soon as I really need to get this working! THANK YOU!!!

@gmheadoffice1572 2 жыл бұрын

THANKS ALOT

@YAcostaSolutions 4 ай бұрын

Thank you 🙂

@AJIMATAWASIL Жыл бұрын

very informative,,,

@YAcostaSolutions Жыл бұрын

Glad you think so, Ajima! Thanks so much 🙂

@94sahab 3 жыл бұрын

thanks,you save me😍

@YAcostaSolutions 3 жыл бұрын

Awesome! Glad this helped 🙂

@Tim124 2 жыл бұрын

So helpful

@YAcostaSolutions 4 ай бұрын

Thank you! I’m happy you found this helpful 🙂

@tarunanand2455 4 жыл бұрын

Hey! Thank you for this video. Pretty much self-explanatory. Can u tell how to copy same format for next weeks?. I mean how to copy paste the table on horizontal and vertical pages next to this one.

@YAcostaSolutions 4 жыл бұрын

Hi, Tarun. You can either use copy and paste to copy this next to the original on the same sheet or make a copy of the sheet. To make a copy of the sheet, place your cursor on its tab, right-click and select Move or Copy. Then check off the option for “Make a Copy” and click OK. Either way, you'll need to update the dates. You can then use Format Painter to copy the Conditional Format to your new copy. To use Format Painter, select the entire original week, click Format Painter from your Home tab's Clipboard section, then select your new copy. The formatting, including the Conditional Format, will now be copied over. I hope this helps. Please let me know if you have more questions.

@ryanoheron5354 4 жыл бұрын

Thank you so much I just made this! Is there a way to link this to a yearly calendar?

@YAcostaSolutions 4 жыл бұрын

Hi, Ryan. I'm trying to think of ways you can do this, but, first, what does your year calendar that you're linking to look like and how do you want it to look like? For example, is it laid out with the months and the dates (with no room for notes?). Where you're looking to create links back to the weekly calendar? Or are you looking to populate the weekly calendar activities into the day in the year calendar (I kind of think this could end up looking overwhelming)? Or do you have a different layout? Thanks

@ryanreynolds1365 3 жыл бұрын

Hi, is there any way to make it so that an activity that takes place over a longer period doesn't show as repeated in each block after dragging it down? And also Display the time in the text?

@taylor7074 2 жыл бұрын

Can you show us how we could use this method through the year and create a dashboard with graphs that would show time spent on activities as the year goes on? I’m trying to make a planner like this that would allow for tracking things over time. Like time spent on the job & returns or time spent exercising and body weight.

@harshagolla6828 3 жыл бұрын

Hi, How do I select multiple cells and pick one of the activities for all cells?

@inbarsharon3263 2 жыл бұрын

great viedo

@YAcostaSolutions 2 жыл бұрын

Thanks so much! I’m glad you liked this 🙂

@harshagolla6828 3 жыл бұрын

Also, I want to have a sheet with list of activities with corresponding dates and times. And I want my calendar to be auto populated based on my entries in other sheets. Do you think you can help me with this?

@jazzylovesth 2 жыл бұрын

To anyone having trouble or getting an error with Data Evaluation in the Settings tab, instead of putting "=Activities", after clicking "Allow: List", I just clicked on the Activities tab (the one near your weekly schedule name), and I highlighted the whole activities chart and it automatically puts the list in the Source box. Hope this helps!

@YAcostaSolutions 2 жыл бұрын

Great tip! Thanks so much for sharing 🙂

@queenofalltheflowers2290 2 жыл бұрын

Omg thank you much, this tip saved my life!

@peacefulmoony903 2 жыл бұрын

Thank you!!

@valeriarossi9883 2 жыл бұрын

Thank you for the tip, unfortunately I still don't understand and I cannot seem to make it work. Can you please break it down? Sorry :-( Thank you

@sunshine21911 4 ай бұрын

Could you show how to save a new item to the “activities list”. It doesn’t automatically add to the values saved to auto populate. Or do we have to save it as a new table every time? Thanks

@jennifastyles924 3 жыл бұрын

How does the weekly calendar repeat itself for the whole calendar year. Meaning, I've followed step by step but it only covered 1 week in the month how do I repeat it so if I wanna book in August the calendar will go that far

@jasmne6697 3 жыл бұрын

hi is there a way to add multiple activities to one column?

@jacobbruley1879 4 жыл бұрын

Thank you for the tutorial. Is there a way to make an activity cover a longer time block? Or would the only way be to put that activity in every thirty minute time block to represent that it is taking several hours? Thanks again!

@YAcostaSolutions 4 жыл бұрын

Hi, Jacob. Once you've entered the meeting in a cell, you could drag it down to other cells. This way you wouldn't have to select it for each half-hour block you may need. Hope this helps and thank you.

@michellem6906 3 жыл бұрын

@@YAcostaSolutions Hi, I just finished preparing a schedule, is there any way to make it so that an activity that takes place over a longer period doesn't show as repeated in each block after dragging it down? Like merging cells so that the time is blocked off but the activity is just listed once?

@charnz3495 2 жыл бұрын

i loved your vid but im looking for more.. how can i stick aay 8 months worth of learning into a three month calendar and track my progress

@booksandtea- Жыл бұрын

Thanks for the instructions! I am having some trouble in the "Data Validation" part. When I input "=Activities" for the Source, I get an error message. Instead I have to highlight the items in my activities list in order for the function to work. Is anyone else experiencing this? If so, were you able to fix it?

@TheNzrules 3 жыл бұрын

hi, is there a way to create a new sheet for the next week but with correct dates and the table empty, without having to go through all the steps again?

@queenofalltheflowers2290 2 жыл бұрын

Thank you for this video, it has been extremely helpful and easy to follow, the only issue I am having is trying to make my timetable blank areas link with my activities list, every time I do it it says there is an error because excel would recognise it as a formula, which I want, but then it won't let me do it? I don't understand what I'm doing wrong since I have followed your tutorial and you did not have the same issue

@YAcostaSolutions 2 жыл бұрын

Hi, looks like you've got this solved in a different comment. Thanks so much for stopping by and watching 🙂

@sumayauthmaan4838 4 жыл бұрын

Thank you for the explanation! Is there a way to add new weeks without ruining the formatting?

@YAcostaSolutions 4 жыл бұрын

Hi, Sumaya and thank you! Adding new weeks should not affect the formatting. You can extend the calendar to the right by adding new columns for future days or you can copy the whole tab to create a new one (on the tab at the bottom of the sheet, right-click and select "Move or Copy" and check off "Create a Copy"). You can insert a formula on the first date that would reference the last day of the sheet for the prior week and add 1. Or you can just type in the new date. On the activities / meetings area, you can select them all by highlighting them and pressing Delete on your keyboard to clear them out. This will not affect the formatting for any new meetings. I hope this helps! 🙂

@refugiorivas310 4 жыл бұрын

Is there a way go quickly add up the time spent on the "activities" each day? -Thanks!

@YAcostaSolutions 4 жыл бұрын

Hi, Refugio Rivas. See if this formula helps you: =(COUNT($A3:$A23)-COUNTBLANK(B3:B23))*"0:30" Here's how this formula works: -The first part counts the cells in range A3:A23 that contain a value. Where A3:A23 refers to the cells in the column that contains the time labels. -It then subtracts any blank cells found in cells B3:B23 (with this range being all the time slots for the first day). If your first day is a Monday, then Tuesday would be C3:C23, etc. And the cells with no activities would be the blank ones. -It then multiplies the difference by "0:30". This represents 30 minutes for each time slot. If each is 15 minutes, then you would multiply by "0:15", and so on. Last, you should apply custom formatting to the cell with the result. It would look like this: [h]:mm. I have a tutorial on time formatting that can help you understand this formatting. If you're interested, you can watch it here: kzfaq.info/get/bejne/ndOmh7ByqN2YYmQ.html Please let me know if this works for you. Thanks!

@blessieconcepcion8609 2 жыл бұрын

What if you have a 3 hour class, let's say from 12 till 3, how do you merge the activities in one timeframe?

@drjaffery 2 жыл бұрын

I want to make a once a week activity every Monday say 1700 hrs to take account of school holidays and have a list of different students doing a presentation by one student each of these Mondays. How can I do that? Please help and advise.

@wandasigagayi9592 3 жыл бұрын

Hi, thanks for the video!😁 so I’ve got a small issue. Whenever I try entering an activity using the drop down menu it auto fills, how do I get the option to choose an activity instead of it auto filling? I’m following this using Excel 2013 if that helps. Thanks once again for the great video❤️

@YAcostaSolutions 3 жыл бұрын

Hi, Wanda. Can you double-check your list settings in Data Validation? Make sure that "In-cell dropdown" is selected? Otherwise, it may be autofilling if other items in the same column start with the same letter(s). Once you've selected a few items with different labels, that should stop. Let me know if you still have troubles with this. Thanks!

@wandasigagayi9592 3 жыл бұрын

@@YAcostaSolutions Hi, thanks for the advice. Everything is sorted now😁❤️

@YAcostaSolutions 3 жыл бұрын

Awesome! Great work! 🏆

@karangkogoya6878 3 жыл бұрын

Hiiiii... Thank you for the Tutorial. I still have trouble when I get into the validation. After the validation staff is done what I got on the schedule list is only *Activities. So, what should I do?

@aliyzainal 3 жыл бұрын

I think you forgot to put the '=' sign in the source section for data validation. Instead of "Activities", it should be "=Activities". When you highlight all the necessary blocks and press data validation, make sure you choose "Allow: list" and "Source: =Activities" in the validation criteria. Goodluck!

@indrajit.banerjee 3 жыл бұрын

After creating everything how to extend it horizontally!!

@rebecca-kay4746 Жыл бұрын

When you set the date how do you get it to auto fill the rest

@Ctenid 3 жыл бұрын

Still helpful in 2020

@YAcostaSolutions 3 жыл бұрын

Thanks, Leix 🙂 Happy this helped you!

@mic2drum 4 жыл бұрын

YAcosta Solutions Is this tutorial available for mac users?

@YAcostaSolutions 4 жыл бұрын

Hi, MD128. Unfortunately, I don’t have a version of this available for Macs. But thanks for asking. We do need to venture into Excel for Macs topics. But sorry we can’t help you more at the moment.

@mic2drum 4 жыл бұрын

okay thanks.

@LizaLiza-jk4zh Жыл бұрын

"A named range you specified cannot be found" is the error message I get when I'm in data validation and I write "= activities" in the source box. How do I fix this?

@sumayauthmaan4838 4 жыл бұрын

Is there a way to make an activity reoccurring every week?

@YAcostaSolutions 4 жыл бұрын

Hi. You could consider locking the cells that contain the recurring meeting, but then when you delete the meetings to begin a new week, you'd have to make sure to not select the locked cells when you delete the others - otherwise Excel gets fussy. I have a tutorial on protecting cells that might help: kzfaq.info/get/bejne/ndGkh7OpvrHMcqc.html But I wonder if it's easier to not delete it for future weeks? You could format it to be a specific color so that it stands out for you. Or use all caps and bold it. Just so it's easier to spot when you're clearing out the area to create a new week. Let me know if neither of these solutions work for you and we can brainstorm something else. Thanks!

@jimmy0502 2 жыл бұрын

can i download this template?

@il4dds 2 жыл бұрын

Can you help me my tasks aren’t transferring to my sheet one

@cancan7614 Жыл бұрын

Pleas need help: Does any body knows how to change dato on many activities together and not do it separately???

@YourDay67 3 жыл бұрын

How do I add an activity please?

@LizaLiza-jk4zh Жыл бұрын

I get an error message when write = activities to create a drop down list.

@edstromen 7 ай бұрын

I cant get it to work, neither in English or Swedish, it won't add the next hour, it just moves the inputted time / day / to the next cell. Your guide is really good, but what is wrong with myExcel (365).

@alexandraramirez814 2 жыл бұрын

My list wouldn't show up. Only the title. Is it because my description was to long to fit in one column? Or did I do something wrong, I am doing an assignment for school. I need to use Excel to make a schedule for a doctor.