Excel skills: smart paging printing

What should you do if you have a lot of data in your table and want to sort it and print it in pages? Don't tell me that you have to adjust manually one by one. I don't know how much time it will waste.

As shown in the table below, there are several departments, namely sales one, sales two, and sales three. How can each department be printed separately?

1. Sort We position the cursor to the department, then go to "data"-"sort and filter", and sort the content first.

2, classified summary will position the cursor in the table, select "data"-"hierarchical display"-"classified summary", select the field you want to classify in the "classified field", and then check "each group of data pagination" to determine. Here, we have paged the data.

3. Repeat the title line. Finally, let's set the repeat title line. Go to "Page layout"-"Page setup"-"worksheet", select the title row you want to repeat in "Top title Row", and make sure.

Finally, let's take a look at the print preview.

This article comes from the official account of Wechat: Word Alliance (ID:Wordlm123), author: Wang Wangqi