Clearing contents or Formats in Excel:

When a value is deleted from a cell using Delete key or by overtyping, the cell’s format not affect. The clear command is use to remove the format.Clearing contents or Formats in Excel

The following procedure is use to clear contents or formats.

• Select the cells (S) to be clear.
• Select Edit > Clear. The Clear sub-menu display.
• Select contents to clear only the data and leave the formatting. OR
• Click Formats to clear only formatting and leave the data. OR
• Select All to clear both data and formatting. OR

Resizing Column or Row:

The columns and rows can be resize with the following ways:

Resizing using Mouse

The following procedure is use to resize column or row using mouse:

• Position the pointer over the divider to right of column header or the bottom of row header to be resized. The pointer changes to a double headed arrow pointing in the direction of movement.
• Click and drag to resize manually. OR Double click to resize the column or row to fit the largest entry automatically.Resizing several entry automatically.

Resizing Several Adjacent Columns OR Rows

The following procedure is use to resize several adjacent column or rows:

• Select all of the columns or rows.
• Click and drag any one of the select dividers. All of the highlight column or rows are resize equally.

Resizing Column using menu;

The following procedure is use to resize column using menu:

• Click and drag across the column headers to select the column to be resize.
• Select Format > Column.
• Click Auto fit select to resize to fit column contents OR click Width…. The column Width dialog box will be display.
• Type new column width in the box and click OK. The column width is measured in numbers of characters displayed.

Resizing Row using menu;

The following procedure is use to resize row using menu:

• Click and drag across the column headers to select the column to be resize.
• Select Format > Row.
• Click Height….
• The Row Width dialog box appears. Row height is measured in points (Font size)
• Type a new row height in the box and click OK.

Hiding rows and Columns:

The following procedure is use to hide rows and columns

• Right click on row or column heading or range of rows or columns to hide.
• Click Hide in shortcut menu. OR
• Select the rows or columns to hide.
• Click Format menu.
• Point to row or column and click Hide.

Un hiding Row or Columns:

The following procedure is use to unhide rows or columns

1. Right Click on the rows between whom the hidden rows exist OR right click the columns between whom the hidden columns exist.
2. Click Unhide in shortcut menu. The hidden rows or columns will appear.

Auto Format:

Auto Format provides predefined formatting for worksheets. AutoFormat can be apply to all or only some parts of worksheet. It is an efficient way of formatting worksheets.

The formatting of auto format can be adjustment. Ms Excel provides sixteen preset formatting option that include colors. Fonts and numeric formatting.

The following procedure is use to apply predefined auto Format:

• Highlight the cells to be formatted.
• Select Format > Auto Format.
• Select any format to apply to the table.
• Click Option ….button to select the elements on which formatting will be applied.
• Click OK when finished.