You may need to highlight the weekend by Conditional Formatting. Later, a table has been created with your activities list.Afterward, create a table just like before and select My table has headers.After creating the table and opening a new sheet write up the Activities list which you want to put in your schedule.Note: Also, you can press CTRL + T as a keyboard shortcut to create a table. A dialog box will appear named Create Table.Firstly, select the entire data then go to Insert tab > pick Table.The table will give a decent look at our schedule. Now, we are going to make an Excel table with our data.Finally, you have entered the day with time for your weekly schedule.After that, write the first working day and again drag down the Autofill feature for other weekdays.Enter your starting time and then drag down the Fill Handle tool to the ending time of your work. ![]() It is necessary for proper visualization of our assigned work in time and day. Now, you have to enter the time and weekdays in your schedule.Step 2: Enter Necessary Time and Name of Day ![]() Here we use the starting time of 8:00 AM, take the time interval of 1 hour, and the ending time at 5:00 PM.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |