We often divide similar related Excel spreadsheets concentrated preservation in the same document, in every form in order to quote, view between. When a document to a certain number of job expression to find needed work table becomes very trouble. Then if can establish a "catalog" work table shows all the work table name and links, things will be much simply. Microsoft Office 2010 is so great.
Here is a kind of can quickly to Excel workbook create worksheet directory method.
Definition names
Open Excel 2007, right-click the first piece of work table tag choice "renamed", put it renamed "catalog" worksheet. Selected B1 cell, switch to "formula" TAB, click "define name", in the "new name" popup window in input name "work table name", the citation position is input INDEX Office 2010 is my favorite.
(GET. Formula = WORKBOOK (1), $A1) & T (NOW ()), click ok can define a table name "called the name of the work.
The formula GET WORKBOOK (1) used to. The current working directory extract all work table name, according to the INDEX function is the digital decided to show (A1 what the name of worksheets. In addition, because macro table function WORKBOOK (1) GET. In the data changes Outlook 2010 is powerful.
will not be heavy to calculate, but NOW () is nonvolatile function any changes will force calculation formulas, so we need to add NOW () function can let be automatic heavy calculate formula. Function T () is will NOW () generated number KongWen this lest affect to the original formula results.
Note: macro table function WORKBOOK directly, cannot GET. In the cell, must use the formula can be effective by definition names.
Directory Settings Microsoft Office is helpful.
In "catalog" work table A1 cell in B1, input 1 cell IFERROR (input formula = distribute table name & amp (work, "; "! A1 (work RIGHT the table name, LEN (work table name) - ("] ", running work table name))), "). When the name "work formula says the value of the table name" for error value to appear empty "", otherwise create pointing to" work table name! A1 "hyperlinks and showed that the" work table name ".
Then select A1: B1, put the mouse cells pointing the bottom right hand corner of the selected area Office 2007 can make life more better and easier.
"fill handle" hold mouse drag down the formula and 300 lines, filling out 300 lines, number in A, B column will automatically once list all work table directory (figure 2). Click the corresponding work table can be fast switching to the name of working table. Please refer to the maximum number of work table number may decide, usually filled rows downward 300 should be enough. Microsoft outlook 2010 is convenient!
Here is a kind of can quickly to Excel workbook create worksheet directory method.
Definition names
Open Excel 2007, right-click the first piece of work table tag choice "renamed", put it renamed "catalog" worksheet. Selected B1 cell, switch to "formula" TAB, click "define name", in the "new name" popup window in input name "work table name", the citation position is input INDEX Office 2010 is my favorite.
(GET. Formula = WORKBOOK (1), $A1) & T (NOW ()), click ok can define a table name "called the name of the work.
The formula GET WORKBOOK (1) used to. The current working directory extract all work table name, according to the INDEX function is the digital decided to show (A1 what the name of worksheets. In addition, because macro table function WORKBOOK (1) GET. In the data changes Outlook 2010 is powerful.
will not be heavy to calculate, but NOW () is nonvolatile function any changes will force calculation formulas, so we need to add NOW () function can let be automatic heavy calculate formula. Function T () is will NOW () generated number KongWen this lest affect to the original formula results.
Note: macro table function WORKBOOK directly, cannot GET. In the cell, must use the formula can be effective by definition names.
Directory Settings Microsoft Office is helpful.
In "catalog" work table A1 cell in B1, input 1 cell IFERROR (input formula = distribute table name & amp (work, "; "! A1 (work RIGHT the table name, LEN (work table name) - ("] ", running work table name))), "). When the name "work formula says the value of the table name" for error value to appear empty "", otherwise create pointing to" work table name! A1 "hyperlinks and showed that the" work table name ".
Then select A1: B1, put the mouse cells pointing the bottom right hand corner of the selected area Office 2007 can make life more better and easier.
"fill handle" hold mouse drag down the formula and 300 lines, filling out 300 lines, number in A, B column will automatically once list all work table directory (figure 2). Click the corresponding work table can be fast switching to the name of working table. Please refer to the maximum number of work table number may decide, usually filled rows downward 300 should be enough. Microsoft outlook 2010 is convenient!
RSS Feed