![]() When you create a new worksheet, all cells are formatted with the General number format. Select the appropriate font, size, color, etc for the cell (whether it be text or numbers). Then click Format on the Menu bar then click Cells. Click on the Alignment tab, click in the Wrap Text check box, and then click OK. ![]() Highlight the cells, rows or columns you want. To the last cell containing data in the sheetį5 key (GOTO) then enter the cell addressįormatting Text in Cells To Automatically Wrap Text To the farthest cell in the data region in a given direction A thinner, black border will appear and the cursor will appear in the cell OR use F2 function key from the keyboard. To edit a cell, double click in the middle of it. To select a cell, click in the middle of it. The Data Region is the area of a worksheet that contains data (as opposed to headings, etc.) 2) Moving from Cell to Cell This allows you access different sheets within a workbook. ![]() Sheet name tabs are shown along the bottom for each sheet within the workbook. For example the cell address A1 refers to the intersection of column A and row 1 and the cell address C6 refers to the intersection of column C and row 6. The point where the rows and columns intersect is a cell (the little squares).Ĭells are identified with a letter and a number that refer to the column and row where it is located-this is the cell’s address. This is also where you enter mathematical formulas.Įach worksheet is made up of columns (vertical sections) and rows (horizontal sections). You can edit text in this bar or in the cell itself. Range name box- lists the address of the cell currently selected.įormula bar- When you enter information into a cell, anything you type appears in the Formula bar. ![]() Worksheet - (or just Sheet) : the individual page within each workbook. Workbook- term used to describe an entire Excel file. 3Ħ) Formulas: Entering and Manipulating Data 6Ģ6) Establishing Links Between Worksheets or Workbooks 39 (“THE END OF THE BEGNING”) TABLE OF CONTENTSġ) Basic Terms and Parts of the Screen. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |