excel表格的35招必学秘技（Excel table 35 strokes will be）.doc

excel表格的35招必学秘技（Excel table 35 strokes will be） Excel table 35 strokes will learn Cheats (keep slowly!) 2011-02-26 10:54 Natural scores Often have friends ask how to print the results this answer, not long have been adopted for recording a macro or VBA to realize, this was about to teach a certain difficulty. For this reason, I present here a trivial way of implementing functions. Here, Mr. sure, the achievements are retained in the A1 to G64 cell area of the Sheet1 worksheet, with first action topics, second actions, and educational names. 1. switch to the Sheet2 worksheet, select the A1 cell, enter the formula: =IF (MOD (ROW ()), 3), =0,, IF (0MOD, ROW (), 3 (=1, Sheet1)! A reports, INDEX (sheet1! $A:$G, INT (((ROW ()) +4) /3) +1), COLUMN ())). 2. again select the A1 cell, use the fill handle to the above formula is copied to the B1 to G1 cell; then, at the same time the selected region A1 to G1 cell, use the fill handle to the formula to A2 to G185 cell. At this point, the basic performance molding, following simple polishing. 3. adjust good line line width, and selected area A1 to G2 cells (first area, the success of Mr.) according to the pattern Toolbar frame is left under the push button, in the subsequent presentation of the frame list, select the all line option, add borders for the selected area (if you do not need to frame, can not make this step and the following operations). 4. select the A1 to G3 cell area at the same time, click the format brush button on the commonly used toolbar, and then press the right mouse button, drag from A4 to the G186 cell area, and add borders for all the result bars. Press the print button to print the achievement bar. Fourteen and Excel help you select functions When dealing with data with functions, it is often difficult to know what functions are appropriate. Excels search function helps you reduce the scope and choose the right function. The implementation of the insert to function command, open the insert function dial