Excel tips in telugu about Cells Group Part 5

excel tips in telugu

To insert new cells, rows, or columns in an Excel worksheet, follow these steps:

Select the cells, rows, or columns where you want the new, blank cells to appear.

Click the drop-down button attached to the Insert command button in the Cells group of the Home tab.

Click Insert Cells on the drop-down menu.

The Insert dialog box opens with the following option buttons:

Shift Cells Right: Select this option to shift existing cells to the right to make room for the blank cells you want to insert.

Shift Cells Down: Use this default option to instruct the program to shift existing cells.

Entire Row: Select this option to insert complete rows in the cell range. You can also select the row number on the frame before you choose the Insert command.

Entire Column: Select this option to insert complete columns in the cell range. You can also select the column letter on the frame before you choose the Insert command.

Hiding Columns

You can hide columns of your worksheet containing information that you do not need to view or do not want to print.

1. Select a cell within the column(s) to be hidden
2. On the Home command tab, in the Cells group, click FORMAT
3. From the Format menu, in the Visibility section, select Hide & Unhide » Hide Columns
   The column is hidden.

Hiding Columns: Quick Menu Option

1. Right click the column ID » select Hide

Redisplaying Columns

1. Select at least one cell from both of the columns around the hidden column(s) to be redisplayed
   EXAMPLE: If column B is hidden, select a cell from both columns A and C.
   HINT: If you cannot select the appropriate cells, you can use the Go To command.
2. On the Home command tab, in the Cells group, click FORMAT
3. From the Format menu, in the Visibility section, select Hide & Unhide » Unhide Columns
   The column reappears.

Redisplaying Columns: Quick Menu Option

This option works well for redisplaying column A, since there are not columns on both sides of column A.

1. Hold your cursor between column IDs on the right side of the hidden column
   The cursor will change to an open, double sided arrow as shown here.
   
2. Right click » select Unhide

Hiding Rows

You can hide rows containing information that you do not need to view or do not want to print.

1. Select a cell within the row(s) to be hidden
2. On the Home command tab, in the Cells group, click FORMAT
3. From the Format menu, in the Visibility section, select Hide & Unhide » Hide Rows
   The row is hidden.

Hiding Rows: Quick Menu Option

1. Right click the row ID » select Hide
   The row is hidden.

Redisplaying Rows

1. Select at least one cell from both of the rows around the hidden row(s) to be redisplayed
   EXAMPLE: If row 5 is hidden, select a cell from rows 4 and 6.
   HINT: If you cannot select the appropriate cells, you can use the Go To command.
2. On the Home command tab, in the Cells group, click FORMAT
3. From the Format menu, in the Visibility section, select Hide & Unhide » Unhide Rows
   The row appears.

Redisplaying Rows: Quick Menu Option

This option works well for redisplaying row 1, since there are not rows on both sides of row 1.

1. Hold your cursor between row IDs where the hidden row is located
   The cursor will change to an open, double sided arrow as shown here.
   
2. Right click » select Unhide

Hiding Cell Contents

You have the ability to hide the contents of individual cells if you do not need to view their contents or you simply do not want to print certain cells.

1. Select the cell(s) to be hidden
2. From the Home command tab, in the Cells group, click FORMAT » select Format Cells…
   The Format Cells dialog box appears.
3. Select the Number tab
4. Under Category, select Custom
5. In the Type text box, type three semicolons ( ;;; )
   
6. Click OK
   The cells are now hidden.

To redisplay cell information:

1. Select the cell(s) to be redisplayed
2. From the Home command tab, in the Cells group, click FORMAT » select Format Cells…
   The Format Cells dialog box appears.
3. Select the Number tab
4. Under Category, make the appropriate selection
   The dialog box refreshes to display options corresponding to the selected category.
5. Select the desired options
6. Click OK
   The cell(s) reappear.