Excel case sharing: how hundreds of vertical names in a table are printed on one page
Sometimes, after we have entered a large number of people's names in Excel, we want to print them, as shown in the following figure:
As we can see, it is thin and long, not only a waste of paper, but also unfriendly. What should we do if we encounter this type of print file? Here, Mr. Wang will come to share with you a good little trick.
1, find and replace method 1, enter A2 in the C2 cell next to it, then fill the H2 cell to the right, continue to fill in the second line, and drop down.
2, use the shortcut key "Ctrl + H", open "find and replace", enter "a", "replace with" set to "= a", click "replace all", and then delete useless cells.
3. Select all the tables, then copy them, paste them as "values", and delete the previous cells. (you can choose the filled cells according to your own needs.)
The final effect.
2. Column 1 in Word. Copy the table to the Word document.
2, enter "layout"-"Page setup"-"column"-"more columns", we set it to "6" column here, and make sure. You can set it according to your own needs. )
3. Position the cursor in the first cell and enter "layout"-"data"-"repeat header row".
The final effect is as follows.
This article comes from the official account of Wechat: Word Alliance (ID:Wordlm123), author: Wang Wangqi