Home  >  Article  >  Software Tutorial  >  How to make a party budget table in Excel_Excel tutorial on how to make a party budget table

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

王林
王林forward
2024-04-24 16:28:15904browse

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.

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

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

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

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.

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

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].

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

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

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

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

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

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

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

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

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

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

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

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.

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

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

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

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!

Statement:
This article is reproduced at:zol.com.cn. If there is any infringement, please contact admin@php.cn delete