利用EXCEL表格搞定生物芯片数据.docVIP

Cell conventions Cells are referred to by their column letter and row number (ex: A2). A series of cells are referred to by showing the starting and ending cells, separated by a colon (ex: A2:A100). When cells are copied and pasted, the column and row are shifted to adjust to the position of the new cell. For example, if the formula =B5 is copied and pasted one cell to the right, the formula in the new cell will change to =C5. If you wish to maintain the position(s) of cell(s) in a formula, use the prefix $ to create an absolute link to cells that wont change with copying an pasting. For e