change width of column:

place mouse pointer at right edge of column label which is to be resized;

drag upto required size;

double click to fit to largest content cell.

(or)

Home tab–>cells groupàformat–>columnwidth/Autofit column width

change height of row:

place mouse pointer at lower edge of row number which is to be resized; drag upto required size; double click to fit to largest content cell.

(or)

Home tab–>cells group–>format–>row height/Autofit row height

Hide/Unhide rows/columns/sheets:

1. Select rows/columns/sheets to be hidden
2. right click and select hide/unhide (or) Home Tab–>Cells GroupàFormat Buttonàvisibilityàhide & unhide

Cells, rows and columns can be inserted or deleted in a worksheet but total number of columns and rows doesn’t change. These adjustments can be applied finally to the data stored in the worksheet.

Insert/delete cells/Rows/Columns

1. right click on cell where new cell to be inserted–>click Insert/delete
2. In Insert/delete dialog select

1. Shift cells right/left to adjust the cells
2. Shift cells down/up to adjust above/below cell
3. Entire row to adjust entire row to inserted/deleted place
4. Entire column to adjust entire column

(or)

Home tab–>cells groups–>insert/delete button