How to make a party budget table in Excel_Excel tutorial on how to make a party budget table

Dear readers, how to easily create a party budget sheet has always been a headache for many people. PHP editor Baicao hereby collects and organizes detailed Excel operation tutorials to help you solve this problem step by step.

1. First open Excel2007 and click on Page Layout in the lower right corner.

2. Click [Page Layout] on the toolbar, select [Paper Orientation] and select [Landscape].

3. Hold down the left mouse button to select the first row, adjust the row height on the left, then click on the toolbar, select merge cells, and then click to add all borders.

4. Enter the table name [Party Budget Table], click on the toolbar, set the font size to 24, align the text in the center, and then click [Bold].

5. Frame select the second row, adjust the row height on the left, then click on the toolbar to add all frame lines.

6. As shown in the figure below, select the cells one by one and merge them.

7. The entire header is as shown in the figure below, fill in the corresponding project name.

8. Frame the table header, then click on the toolbar, set the font to center alignment, and make the text bold.

9. As shown in the picture below, select the entire page below, and then click to add all frames.

10. Frame select the area in the picture, then click on the toolbar and select Spanning Merge. The ones marked in red below do the same thing.

11. Finally, click on the view to cancel the grid lines.

The above is the detailed content of How to make a party budget table in Excel_Excel tutorial on how to make a party budget table. For more information, please follow other related articles on the PHP Chinese website!