tiên, chọn hai hoặc nhiều cột và các hàng trong bảng tính, sau đó kích hoạt các lệnh Insert như mô tả trong phần này. Excel cho biết thêm cùng một số các cột và các hàng như số bạn ban đầu được lựa chọn. | CHAPTER 9 Excel Building Spreadsheets Add a Row 1 Click the heading of the row below where you want to insert a new row. 2 Click the Home tab on the Ribbon. 3 Click the Insert . 4 Click Insert Sheet Rows. You can also right-click a row heading and click Insert. Excel adds a row. A smart tag icon ffil may appear and you can click the icon to view a list of options that you can assign. Can I insert multiple columns and rows Yes. First select two or more columns and rows in the worksheet then activate the Insert command as described in this section. Excel adds the same number of new columns and rows as the number you originally selected. Can I insert columns or rows using the Insert dialog box Yes. Click a cell click the Insert on the Home tab and click Insert Cells to open the Insert dialog box. Then click Entire Row or Entire Column and click OK. Excel adds a row or column above or to the left of the active cell. 55 Resize Columns and Rows By default long lines of data that you type into a cell remain on one line or are truncated if you type additional data into adjoining cells. One way to remedy this is to enable the textwrapping refer to the section Turn On Text Wrapping for details . Another option is to resize the column to fit the data. In addition to resizing your worksheet s columns to accommodate text you can also resize columns to make the worksheet more aesthetically appealing. Note that just as you can resize columns in your worksheet so too can you resize worksheet rows. Resize Columns and Rows 1 Position the mouse pointer over the border of the heading of the column or row that you want to resize. The pointer changes to 4 . 2 Click and drag the border to the desired size. A dotted line marks the new border of the column or row as you drag. 3 Release the mouse button. Excel resizes the column or row. You can also click the Format button on the Home tab and then click AutoFit Selection to quickly resize a highlighted .
