Change width and Height of Row & Columns:
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.
You
can apply the same change to more than one row or column by selecting
the rows or columns you want to change and then dragging the border of
one of the selected rows or columns to the location you want. When you
release the mouse button, all the selected rows or columns change to the
new height or width.
Inserting rows, columns, and cells:
You can also insert a row or column between cells that contain data to make your data easier to read. 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.
Delete a 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 delete more than one row or column by selecting the rows or columns
you want to delete and then right-click on one of the selected row’s or
column’s head and then click delete.
Hide & Unhide rows or column:
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.
Note:
Inserting an individual cell:
You
can insert individual cells into a worksheet. To insert a cell, click
the cell that is currently in the position where you want the new cell
to appear. On the Home tab, in the Cells group, in the Insert list,
click Insert Cells to open the Insert dialog box. In the Insert dialog
box, you can choose whether to shift the cells surrounding the inserted
cell down (if your data is arranged as a column) or to the right (if
your data is arranged as a row). When you click OK, the new cell appears, and the contents of affected cells shift down or to the right, as appropriate.
Deleting an individual cell:
If
you want to delete a block of cells, select the cells, and on the Home
tab, in the Cells group, in the Delete list, click Delete Cells to open
the Delete dialog box—complete with options that you can use to choose
how to shift the position of the cells around the deleted cells.
Move group of cell’s data:
If you want to move the data in a group of cells to another location in your worksheet, select the cells you want to move and point to the selection’s border. When the pointer changes to a four pointed arrow, you can drag the selected cells to the desired location on the worksheet. If the destination cells contain data, Excel displays a dialog box asking whether you want to overwrite the destination cells’ contents. If you want to replace the existing values, click OK. If you don’t want to overwrite the existing values, click Cancel and insert the required number of cells to accommodate the data you want to move.
