In this section, you will learn how to set a sequential date for your work schedule (this particular one excludes Sunday, as this is often a day of closure for businesses): To do this, navigate to the “ View” tab and click on “ Fix top line” under “ Freeze Window.” Finally, fix the header at the top of the screen so that it is still visible when you scroll down the work schedule.Now type in the time “6:00-10:00.” By double-clicking the cell last, you can adjust the font size of the shift name and time and mark things as bold. To format the cells for individual layers, just type in “Early Shift” (or midday, late, or night shift) and then use the Excel shortcut + [ENTER) to manually break lines.You can set the columns K and L as you like – depending on how much space you have left. In our example, column A (December 2019) has a width of 35 columns C,E,G, and I have a value of 20 empty columns B, D, F, H, and J, which are meant to break up the schedule are only 40 pixels wide (corresponds to a value of 5). This saves you having to adjust all table columns manually.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |