How to print a Single-column table in Excel

In fact, the use of Excel's own formula operation, can also easily achieve a single form of the text of the synthesis of printing. The example of "student name", which is arranged horizontally and displayed line by row, is as follows:

1. Select a column in the current table Sheet1 as the data compositing column, such as column F, and enter the formula "=f1&&" "&&b2" in cell 2nd below, where the formula says 2 F2 between two names, the first name is generated in F2. Select F2 to copy the formula in F2 to the following cell, using the method of dragging the fill handle downward, and the contents of the following cell will be the name synthesis in all rows before the current row.

2. Select the Sheet2 table and enter the formula in the A1 cell =trim (sheet1! F49) ", F49 the name of the last person in the Sheet1 table, copies all the names to the A1 cell, and then sets the A1 cell alignment to wrap, horizontally left, vertically aligned, and the width of column A is adjusted appropriately.

3. The A1 cell is set as the print area, and the print preview and printing can realize the observation and output of single text printing effect.

The advantage of using this method is that the content interval of two cells can be set arbitrarily as needed. At the same time, through the operation of Excel print preview of the margin line, you can quickly arbitrarily adjust the page up and down the left and right margin, to achieve the function of reasonable typesetting, in addition, the content of the A1 cell through the selective paste copy, can also be synthesized after the specific content in Word layout output. You may as well try.