| Back to logs list
label custom worksheet formula IT data
34820 2010 年 06 月 29 日 01:40 Reading (loading. ..) Comments (2) Category: Personal Diary
Excel formulas and use of commonly used
1, two columns of data to find the same value corresponds to the position of
= MATCH (B1, A: A, 0)
2, the formula may result
known definition name = EVALUATE (Sheet1! C1)
known results have defined the formula
name = GET.CELL (6, Sheet1! C1)
3, line
forced to use Alt + Enter
4, more than 15 digital input
too many people ask this question, and also come away. First, the cell is set to text; two before the input digital input '
5, if column B is hidden, if it show up?
Selected columns A to C, Right-click, select Unhide
A to C column,
ed hardy bikinis, double-click the selected line width of any column or change any of a wide
move your mouse over to the AC between the columns,
福州各百货本年圣诞促销加码 最低扣头可达3.3折 - Qzone日记, such as the mouse becomes when the drag of the double vertical bar.
6, EXCEL in the ranks of the exchange
copy, Paste Special, select the transpose, can be determined
7, Excel is how encryption
ExcelRecovery
21, EXCEL root operation
will be open 8 3 power, you can use this formula in a cell type = 8 ^ (1 / 3)
22, the data in the distributed cell alignment
text format - full-width input
23, to find a link to the worksheet
Ctrl + ~ or edit - Links
24, how to automatically fill in empty cells as 0
need to change the selected area - find - empty - replace -0
25, the Word in the digital conversion to Excel
There are several ways, select - copy - set the input cell as text - Paste Special - Value - select - Convert Table to Text - paste - breakdown - breakdown option on As for the text
text file-EXCEL, open a text file - Import Text dialog box on the corresponding set