Formatting in MS Excel

Adjusting Column Width and Row Height:

Steps to adjust column width include: -

1. Point to the column header’s right border until the pointer changes to a plus sign, with arrows pointing towards West and East direction.
2. Click and drag to the left or right to adjust the width. A dotted line appears as you drag, showing you where the new column border will be.

Alternatively,

Right-click the column header, select Column Width from the contextual menu, and enter the column width.

Or, select the column header, click the Format button in the Cells group on the Home tab, select Width, and enter column width.

Steps to adjust row height include: -

1. Point to the row header’s bottom border until the pointer changes to a plus sign, with arrows pointing towards North and South direction.
2. Click and drag up or down to adjust the height. A dotted line appears as you drag, showing you where the new row border will be.

Alternatively,

Right-click the row header, select Row Height from the contextual menu, and enter the row height.

Or, select the row header, click the Format button in the Cells group on the Home tab, select Height, and enter the row height.

Hiding/Unhiding Rows and Columns:

You can hide rows, columns, worksheets and entire workbook windows from view. Data isn’t deleted, but simply hidden from view until you unhide it.

Steps to hide a row or column include: -

1. Select the row or column heading for the row or column you want to hide.
2. Right-click the heading and select Hide from the contextual menu.

The row or column is hidden.

Alternatively,

1. Select the row or column heading for the row or column you want to hide.
2. On the Home tab, click the Format button in the Cells group.
3. Point to Hide & Unhide and select Hide Rows or Hide Columns.

Steps to unhide a row or column include: -

1. Select the row or column heading on both sides of the hidden row or column.

For example, if columns C and D were hidden, you would select the B and E column headings.

2. Right-click the heading and select Unhide from the contextual menu.

Alternatively,

1. Select the row or column heading on both sides of the hidden row or column.
2. On the Home tab, click the Format button in the Cells group.
3. Point to Hide & Unhide and select Unhide Rows or Unhide Columns.

Aligning a Worksheet Data:

Steps to align worksheet data include: -

1. Select your desired cells.
2. Go to the Home tab.
3. Use the Alignment group icons to choose between –
4. Top Align, Middle Align, or Bottom Align for vertical positioning, and
5. Align Text Left, Centre, or Align Text Right for horizontal positioning.

Alternatively,

1. Select your desired cells.
2. Right-Click the selected cells.
3. Select Format Cells. Format Cells Dialog Box appears.
4. Click on Alignment Tab.
5. Perform changes as per your requirement.
6. Click OK.