excel 操作窍门（操作窍门 excel）.docVIP

excel 操作窍门（操作窍门 excel） Log of cold, crystal, cold, crystal, current log, log home page? A newer / older article share Excel skills: Introduction (1), fast to rename the EXCEL cell for each cell has a default name, the naming rule is the column with D3 said fourth cells such as abscissa, columns and third rows. If you want to rename a cell, just click with the mouse... [office essential] Excel operation skills. If the original Excel ~ ~ ~ ~ have to use so much! 2009-11-29 14:37 | (classification: other) Introduction to Excel operating techniques: (1) rename the cell quickly EXCEL for each cell has a default name, the naming rule is the column with D3 said fourth cells such as abscissa, columns and third rows. If you want to rename a cell, just click a cell with the mouse and see its current name in the upper left corner of the table, and then you can enter a new name with the mouses name. (2) remove the default form line (net) Click options in the tools menu, and then click the view in the dialog box to find the grid line and disable it. (remove the X from the left). (3) increase the number of pages of workbooks Click the worksheet in the Insert menu to see a new name worksheet at the bottom. A workbook can have up to 255 worksheets. (4) name the worksheet quickly Double click the name at the bottom of the current worksheet, such as Sheet1, and then enter a new name. (5) implementation condition display; When statistics student achievement, hoped that enters the following 60 mark, when can display does not pass, enters 60 above the mark, displays passes. This effect may be called conditional display, and can be implemented using the IF function. Suppose the score is in the B3 cell, and the class is displayed in the C3 cell. Then enter the following formula in the C3 cell to achieve different levels: =if (b3=60, fail, pass), fail and pass two grades =if (b3=60), fail, if (b3=90), pass, excellent) are divided into three grades =if (b3=60), fail, if (b3=70), pass, if (b