Modifying Excel Worksheets
In Excel, you can take other steps to make the data in your workbooks easier to work with. For example, you can change the width of a column or the height of a row in a worksheet by dragging the column’s right border or the row’s bottom border to the position you want. Increasing a column’s width or a row’s height increases the space between cell contents, making your data easier to read and work with.
Note: An practice exercise is given at the end of this post. If you want to learn better to modifying excel worksheets, then please must do it.
Inserting Rows, Columns, and Cells
Modifying column width and row height can make a workbook’s contents easier to work
with, but you can also insert a row or column between cells that contain data to make your data easier to read. Adding space between the edge of a worksheet and cells that contain data, or perhaps between a label and the data to which it refers, makes the workbook’s contents less crowded. You insert rows by clicking a cell and clicking the Home tab on the ribbon. Then, in the Cells group, in the Insert list, click Insert Sheet Rows. Excel inserts a row above the row that contains the active cell. You insert a column in much the same way, by choosing Insert Sheet Columns from the Insert list. When you do this, Excel inserts a column to the left of the active cell.
When you insert a row, column, or cell in a worksheet that has had formatting applied, the Insert Options button appears. When you click the Insert Options button, Excel displays a list of choices you can make about how the inserted row or column should be formatted, as described in the following list.
|Format Same As Above||Applies the formatting of the row above the inserted row to the new row|
|Format Same As Below||Applies the formatting of the row below the inserted row to the new row|
|Format Same As Left||Applies the formatting of the column to the left of the inserted column to the new column|
|Format Same As Right||Applies the formatting of the column to the right of the inserted column to the new column|
|Clear Formatting||Applies the default format to the new row or column|
If you want to delete a row or column, right-click the row or column head and then, on
the shortcut menu that appears, click Delete. You can temporarily hide rows or columns
by selecting those rows or columns and then, on the Home tab, in the Cells group, clicking the Format button, pointing to Hide & Unhide, and then clicking either Hide Rows or Hide Columns.
The rows or columns you selected disappear, but they aren’t gone for good as they would be if you’d used Delete. Instead, they have just been removed from the display until you call them back. To return the hidden rows to the display, select the row or column headers on either side of the hidden rows or columns. Then, on the Home tab, in the Cells group, click the Format button, point to Hide & Unhide, and then click either Unhide Rows or Unhide Columns.
In this exercise shown below, you’ll insert a column and row into a worksheet, specify insert options, hide a column, insert a cell into a worksheet, delete a cell from a worksheet, and move a group of cells within the worksheet.
1. On the May 12 worksheet (an example worksheet), select cell A1.
2. On the Home tab, in the Cells group, click the Insert arrow, and then in the list, click
Insert Sheet Columns to create a new column A.
3. In the Insert list, click Insert Sheet Rows to create a new row 1.
4. Click the Insert Options button that appears below the lower-right corner of the selected cell, and then click Clear Formatting to remove the formatting from the new row 1.
5. Right-click the column header of column E, and then click Hide to remove column E
from the display.
6. On the tab bar, click the May 13 sheet tab to display the worksheet of the same name.
7. Click cell B6.
8. On the Home tab, in the Cells group, click the Delete arrow, and then in the list, click Delete Cells to open the Delete dialog box.
9. If necessary, click Shift cells up, and then click OK. Excel deletes cell B6, moving the
cells below it up to fill in the gap.
10. Click cell C6.
11. In the Cells group, in the Insert list, click Insert Cells to open the Insert dialog box.
12. If necessary, click Shift cells down, and then click OK to close the Insert dialog box, create a new cell C6, and move cells C6: C11 down to accommodate the inserted cell.
13. In cell C6, enter 4499, and then press Enter.
14. Select cells E13: F13.
15. Point to the border of the selected cells. When the pointer changes to a four-pointed
arrow, drag the selected cells to cells B13: C13. The dragged cells replace cells B13: C13.
Close the workbook, saving your changes if you want to.