How to make a course schedule with Excel spreadsheet, a must-have for students

Question: Want to create a course schedule in an Excel spreadsheet, but don’t know how? Simple instructions: This tutorial will guide novice users step by step to create a course schedule using Excel tables. Guided Reading: Read on to learn more about how to easily create a course schedule using Excel's border formatting tools, allowing you to see all your course information at a glance. PHP editor Xigua will provide you with a detailed step-by-step guide to help you master this skill easily.

Select cells A1 to H1, click [Start], in the alignment column, click [Merge and Center], merge cells A1 to H1, follow the same operation method , merge cells A3 to A6, and cells A7 to A10.

Adjust cell size, (Reference article: Excel table operations, do you know these 3 shortcuts to adjust row height and column width?), in the merged cells Enter the course schedule, morning, and afternoon into the boxes respectively, set the font size, and adjust the text alignment.

Click on cell A2, right-click, click [Format Cells], a window will pop up, click the [Border] tab, set the cell slash, click 【Sure】.

Enter the date in the cell, press the [Alt+Enter] key, change the line in the cell, then enter the shift, press the space bar to adjust the text position until it is coordinated and beautiful Can.

Enter Monday in cell B2, move the mouse to the lower right corner of the cell, the mouse will turn into a cross shape, drag the mouse to the right to fill in Tuesday and Wednesday ..., and then set the text to be displayed in the center.

The basic framework of the course schedule is ready. Save the form. If the sections of the course schedule change, modify it again and print it out. It is made once and can be used repeatedly. It is flexible and efficient. .

Enter data in the prepared course schedule template, adjust the text to be centered, set the text style, and a complete course schedule is ready. The effect is as shown below.

The above is the detailed content of How to make a course schedule with Excel spreadsheet, a must-have for students. For more information, please follow other related articles on the PHP Chinese website!