函数分栏打印excel（The function print columns Excel）.doc

函数分栏打印excel（The function print columns Excel） How to use the Excel function to achieve print columns Source: the IT service platform published: 10-12-13 editor:: IT tutorial This paper introduces how to use the Excel function to realize this technique is suitable for printing print columns, column number less Excel table, to avoid the emergence of a large number of blank. I occasionally need to print some number less form cases: scores table, salary list, construction inspection list, product code table etc.. To the construction staff annual inspection list, only serial number, name and certificate number 3. Direct printing, due to the 3 list lattice is much smaller than the width of the paper, there will be a lot of blank, not only ugly, but also a waste of paper. So it is necessary to put the table columns full page print, but Excel did not split function, how to achieve print columns? In fact, Excel2007 can easily form print columns with function. 1. format settings Open column annual list of work table for Excel2007. Hold down the Ctrl key and drag annual list tab to replicate a annual list (2) work table, and rename it column. In the columns work table press Ctrl+A select and delete the data according to the Delete key, to get a frame, line height, column width, font and table the same empty table. According to the required column spacing adjustment fourth column width, and then select the A1:D1 replication, and then select the first row right click and select paste, paste in the window to select the column widths, determined to form A1:D1 in the column width to all columns. 2. input formula In the A1, enter the formula =IF (A2= , $A1 , the annual list!), in the A2 non empty display inspection list work table title A1 or empty, in B2, C3 has the same input formula, but the formula in $A$1 were changed to $B$1, $C$1 to refer to the corresponding title. In the A2, enter the formula =IF (INDIRECT (annual list! A ROW (+INT) (COLUMN) (/4) *COUNT ($D:$D)) = , INDIREC