{oapdf_gg}
Office software is closely linked to the PDF,the PDF is also must have to control!      Set home Page  Add to Favorites  
You are here:Home > OA application skills > EXCEL skills
EXCEL skills
How to Excel at the same time table and multi-multi-line freeze out
Finishing by: Date:2009-04-10 21:02:51 Popularity: Tags:
Excel to freeze the window is a very practical function. Excel in the operation, you have not found, when you have been frozen out of a time, if you want to freeze the other rows or columns of a particular time, the system often can not be achieved. At this time you may wish to try the following method, it is useful Oh ......



The first step: In Excel, click to select "B2" click the cell, the implementation of "window" ¡ú "split" command (Figure 1), the next will be the effect shown in Figure 2, if the map does not appear 2 shows the effect of the split window that was not successful.
 

Excel

Excel
 
Step Two: Click to select the most upper-left corner of the "A1" cell to implement the "window" ¡ú "freeze pane" command (Figure 3).
 
Excel
 
Then the realization of the perfect first line of the freezing, the effect of the first column (Figure 4). Data for some more forms, the need for a fixed table or the first column of the first, after the freezing of view on the much more convenient.
 
Excel
 
The same token, if you want to freeze the first row and first column 1,2, then click to select cell C2, the implementation of "window - split" command, and then click to select cell A1 or B1, or two cells are selected, then the implementation of "window - freeze" on the OK!
there isArticle InformationsComment Information
Category column

Site Help | Site Map | Feedback |
OAPDF.COM Copyright 2009 V1.1