![]() Right-click in any cell of the worksheet and select Format Cells from the right-click menu to open the Format Cells dialog box shown above.Ĭell values can be formatted both to display the data in various ways and alter its font size, font color, create borders, and more. To edit directly inside a cell, either double click inside the cell, or select the cell and press the F2 key.Įach cell has a specific format which tells Excel how to display its contents. When done typing, either press the Enter key or click inside another cell. To edit from the Formula Bar, select the cell and click inside the Formula Bar. When entering dates, Excel defaults to the current year if the year portion of the date is omitted.Ĭell contents may be edited from the Formula Bar or directly inside a cell. What you type also displays in the Formula Bar. To enter data into a cell, click in the cell and begin typing. In the image at right we have selected cells A2 through B4 (written A2:B4 in formulas). To select a group of contiguous cells, click in one corner cell and drag the mouse to the opposite corner.To select one or more columns of cells, click on the column letter(s).To select one or more rows of cells, click on the row number(s).There are a variety of ways to select cells in an Excel spreadsheet: Press the Enter key to move to the cell immediately below the current cell, and press the Tab key to move one cell to the right. The arrow keys can be used to move left, right, up, and down from the current cell. New worksheets can be created, and worksheets can be renamed, but there are rules for what characters can be included in a worksheet name. Worksheets can be deleted, moved, and copied to the same or a different workbook. Worksheet names are displayed on tabs at the bottom of the workbook. New workbooks, when created, contain three worksheets by default: Sheet1, Sheet2, and Sheet3. The Excel workbook is a collection of worksheets. The Formula Bar displays the contents of the selected cell which may be a number, text, or formula. The beginning of the Formula Bar can be seen in the area above Column D on our worksheet. Notice that the column letter (C) and the row number (2) change color. In our worksheet above, the selected cell is C2. The Name Box is located in the area above Column A, and displays the cell reference of the selected cell - the cell where the cursor is resting. For example, the formula to add the contents of cells B2 and B3 is: =B2+B3. And cells in the first column are A1, A2, A3, etc.Ĭell references are often used in math formulas or functions. The column names are letters of the alphabet starting with A, and rows are numbered chronologically starting with one.Įach cell has an address or a cell reference: cells in Row #1 are A1, B1, C1, and so on. The Excel WorksheetĪn Excel worksheet, or spreadsheet, is a two-dimensional grid with columns and rows. However, the power of Excel is the ability for the Excel user to enter formulas that perform mathematical calculations, compare values, and much more. Excel is a great tool for documenting and tracking data-everything from a company's revenue numbers to the neighborhood baseball schedule. ![]() Microsoft Excel is a program that allows the user to enter data in rows and columns, similar to a Microsoft Word table. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |