tailieunhanh - Microsoft Excel 2010 phần 3

Nhấp vào tiêu đề cột B để chọn nó. Click vào nút Text Bọc trong nhóm Alignment trên tab Home để loại bỏ các gói. Chú ý rằng cột là bây giờ không đủ rộng để hiển thị văn bản. Mở rộng cột B bằng cách nhấp đúp vào biên giới dọc bên phải của nó. Các hàng tự động điều chỉnh chiều rộng trước đây của họ. | Remove Wrap Text in a Column 1. Click the column B header to select it. 2. Click the Wrap Text button in the Alignment group on the Home tab to remove the wrapping. Notice that the column is now not wide enough to display the text. 3. Widen column B by double-clicking its right vertical border. 4. The rows automatically adjust to their previous width. 7. Press Enter. Enter a Line Break to Wrap Text Easier If desired text can be wrapped as the data is entered. 1. Click cell C3. 2. Type the word Price. 3. Press Alt Enter. 4. Type the word per 5. Press Alt Enter. 6. Type the word Item. Using AutoComplete and AutoCorrect The AutoComplete feature will automatically insert data in a cell that begins the same as a previous entry. If the data inserted by AutoComplete is the data desired in the cell simply press Enter. If it is not the desired data simply continue typing the correct data. This feature is very useful in a worksheet that contains repetitive data entries. The AutoCorrect feature automatically corrects many common typing errors. To see what symbols and words are in the AutoCorrect dialog box click the File tab and then click the Options button located below the Help tab. At the Excel Options dialog box click Proofing in the left panel and then Click the AutoCorrect Options button located in the right panel. The AutoCorrect dialog box will appear. Excel Unit 1 PG 5-31-2011 Professional Development Center Page 21 of 31 Editing Cells Once information has been entered it may be necessary to make changes either because of typographical errors or because the information itself has changed. If a change is made to a cell containing a number used in a formula the formula will automatically be updated. To delete or clear the contents of a cell press the Delete key. There are several ways to edit cells. Edit Data in the Formula Bar The Formula Bar shows all data entered not the results of data calculations. All information therefore can be edited this way. 1. Click cell .