What is the cross-page border problem after Excel cells are merged?

What is the cross-page border problem after Excel cells are merged? 2011-03-20

How does one solve the cross-page border problem after cells are merged?

After cells are merged, there is no problem with the bottom border in the Cross-page area. One adjustment is too slow. What are the best methods?

Generally, it is implemented by adjusting the Row Height one by one. However, if you want to insert or delete a row after merging, you have to adjust it too slowly !!

 

An example is provided. In fact, there are many Excel cells to be processed, and the number of cells to be merged is also different.
The bottom line is always lost. I can see that some cells are merged across pages, and the two pages are repeated. I don't know how to do this. For more information, see.

Unnamed .jpg
(19 kb, downloads: 0)

Upload

Downloads: 0

Book11.zip

Upload from

Downloads: 10

2.89 kb, downloads: 10

 

There are two solutions:

1. In the page settings, select "Print network line ". The disadvantage is that table lines also appear in the header row.
2. Use macro command: Reference http://club.excelhome.net/thread-160841-1-1.html
   Usage: Click the Excel tool-load macro-[browse] to find the location where the file is stored and click OK.

Author: Admin | category Directory: software used | Tag: excel, tips