Office software is closely linked to the PDF,the PDF is also must have to control!
Set home Page Add to Favorites
|
five, HYPERLINK The so-called HYPERLINK, that is, create a shortcut to open a document or a network drive, or even INTERNET address.ͨË׵ؽ², that is, in a cell after enter this function, one can go anywhere you want to go. Excel document in a certain, perhaps you need to invoke other Word documents or Excel documents, etc., the steps and methods that is the case: (1) to select the function you want to enter the cell, such as B6. (2) used the toolbar click the "Paste Function" icon, there will be "Paste Function" dialog box, in the "Function Category" box, select "common" in "function name" box, select HYPERLINK, at this time In the dialog box will appear at the bottom of a brief explanation of the function. (3) Click "OK" will pop-up dialog box HYPERLINK function parameter setting. (4) "Link_location" type of document you want to link or INTERNET address, for example: "c: \ my documents \ Excel function. Doc"; in the "Friendly_name" type "Excel function" (in this case is based on the assumption that we want to open Documentation is located in c: \ my documents under the document "Excel function. doc"). (5) Click "OK" to return to the Excel you are editing a document, at this time and then click cell B6 can be used to immediately open the Word document to edit the minutes of the meeting. HYPERLINK function to create a variety of shortcuts, such as open files or network drives, such as jump to a Web site. Exaggerate it a little, in a cell after enter this function, you can jump to any location we want to go. Other (CHOOSE, TRANSPOSE) 1, CHOOSE function Index_num can use the CHOOSE function to return to the list of numerical parameter values. CHOOSE function can be based on the use of the index return as many as 29 to be elected in any one of numerical values. Grammatical form: CHOOSE (index_num, value1, value2 ,...)< br/> Index_num parameters for the specified serial number to be elected and the parameter values. Index_num must be between 1-29 figures, or figures 1-29 contains a formula or cell reference. Value1, value2, ... for the 1-29 numerical parameters, based on the CHOOSE function index_num, select a value or to perform the corresponding action. Parameters for the number of cell references, defined names, formula, function or text. 2, TRANSPOSE function TRANSPOSE to transpose back to the region. TRANSPOSE function must be in an area with an array formula in the form of input, the region the number of rows and columns, respectively, with the array of columns and rows the same. Function can be changed using the TRANSPOSE worksheet or macro sheet in an array of vertical or horizontal direction. Grammatical form of TRANSPOSE (array) Array for the need to transpose the array or range of the worksheet. Transpose the so-called array is the first line of the array as a new array of the first column, second line of the array as a new array of the second column, and so on. Example, the original order for the lateral transposition of the performance table for the vertical array.
|
