- Picture and text skills
When we print a form, we sometimes need to print the form in pages according to the categories in the form.
How to do it?
▪Take this sales form as an example. First, we need to Subtotals.
Select the data area and click Data in the upper menu bar - Classification and summary.
In the pop-up dialog box, select the classification field, such as "Product"; select the summary method, such as "Sum"; Select a summary item, such as "Sales Volume"; check "Page per group of data".
Click OK to classify and summarize this table.
▪We can also set a fixed title row.
Click on the upper menu bar Page Layout - print the title or header.
In the pop-up dialog box, enter the top title line and click Print Preview. At this time we can preview the effect of printing the table in pages according to categories.
Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/biao-ge-da-yin-ji-qiao-he-ji-geng-xin-zhong-biao-ge-ru-he-an-zhao-lei-bie-fen-ye-da-yin.html
评论列表(196条)
测试