Using Excel to make a double-sided seat check print template

believe that the office of the family will have a lot of time in the preparation of meetings, and the printing of the leadership of the two-sided seat must be you have encountered a problem. In fact, only with the weapons you have at hand Excel can easily solve the problem. Here are some specific ways to introduce you.

Solution: With the "align → direction" option of the "format → cell" menu, the first and last two names to be printed are adjusted to "-90 degrees" and "90 degrees" respectively.

Open Excel, and in Sheel1, select a table area that is symmetric with a vertical line and merge into two merged cells of the same size. Select the two merged areas that you created in the previous step, set to the print area (file → print area → set print area). In a cell below the print area (the B17 cell in Figure 1), enter the name you want to print, making the preceding two merged regions equal to the value of the cell (two merged cells are respectively "=B17"), as shown in Figure 1.

Sets the orientation of the text in the print area so that the name on the left is inverted to the right, set to 90 degrees ("format → cell → alignment → orientation"), and the name on the right to the left, set to 90 degrees. The text size and font effects are adjusted as shown in Figure 2.

Set the page to "landscape", adjust the size and position of the print area, and when you get a satisfactory result in print preview, you're done! If the right border of the first merged cell is displayed as a black line, it can also be used as a printed fold.

Save this file, to print other people's names, just change the name of the print area to OK.