Working with cells, rows, columns, and sheets

Insert Row, Column, or Sheet

You can insert rows and columns. You can also insert sheets and change their names.

Insert Row

Perform the following to insert a row into the row where is selected.
  1. Select the heading of the row where you want to insert a new row.
  2. Click Insert-Insert Row.

Cell_Insert_row.png

Insert Column

Perform the following to insert a column into the column where is selected.
  1. Select the heading of the column where you want to insert a new column.
  2. Click Insert-Insert Column.

Cell_Insert_column.png

Insert Sheet

Perform the following to insert a sheet.
  1. Click Insert-Insert Sheet.
  2. Click and drag the last sheet that is just created to the location where you want to place on the sheet tab.
  3. Right-click on the new sheet and click the Rename Sheet on the context menu and then change the sheet name.

Note

You can delete, rename, or hide sheets using the context menus that appear when you right click on a sheet tab.

 

Delete or Hide Row/Column

You can delete and hide or unhide the selected row and column.

Delete Row

Perform the following to delete a row.
  1. Select the heading of the row which you want to delete from the sheet.
  2. Click Edit-Delete Row.
    You can delete the column in the same way, and you can cancel the deletion of the row by clicking the Undo icon_undo.png icon on the toolbar.

Hide Column

Perform the following to hide the selected column.
  1. Select the heading of the column that you want to hide.
  2. Click Edit and then click Row/Column-Hide Column.
    The left and right arrow icons between columns appear to allow you to expand the hidden column.

 

You can hide or unhide the row in the same way.

 

Merge Cells

You can combine two or more selected cells into one cell and then unmerge them. The reference cell of merged cells is the cell on the top left of the selected range.

Merge Cells

Perform the following to merge two or more cells into one cell.
  1. Select a range of cells to merge.
  2. Click Edit-Cell-Merge & Center.
    If the notification about the loss of the data except for the top-left cell appears, click the Yes button to merge cells.

Split Cells

Perform the following to unmerge the cell.
  1. Select the cell that was merged.
  2. Click Edit-Cell-Unmerge.

Please note the differences between options for merging cells.

  Merge & Center: merges two or more cells into one cell while keeping the upper-left most data only and align the data in the center. 
  Merge All: merges two or more cells into one cell while keeping the upper-left most data only and align the data by default alignment (normally left-aligned).
  Merge Horizontally: merges cells by row when multiple rows and columns are selected.
  Merge Vertically: merges cells by column when multiple rows and columns are selected.

 

Edit Sheet

You can rename, hide, or unhide a sheet. You can also delete sheets.

Delete Sheet

  1. Select the sheet you want to delete.
  2. Click Edit-Delete Sheet.
  3. Click the Yes button after reading the notification about the deletion of the selected sheet.

Rename Sheet

  1. Select the sheet you want to rename.
  2. Click Edit and then click Sheet-Rename Sheet.
  3. Delete the sheet name and type the name that you want to use.

Hide Sheet

  1. Select the sheet that you want to hide from the sheet tab.
  2. Click Edit and then click Sheet-Hide Sheet.
    If you click Sheet-Unhide Sheet on the Edit menu list, all the hidden sheets appear on the sheet tab.

Note

You can delete, rename, or hide sheets using the context menus that appear when you right click on a sheet tab.

 

 

Apply Filter

When you select the Filter option, the filter conditions in the active database are displayed.

Use Filter

Perform the following to apply a filter to data.
  1. Select a range of cells to apply a filter.
  2. Click Data and then Filter.
  3. Click the Filter Expand cell_filter_icon.png icon for the field you want to apply a filter to and then click the items you want to filter.

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Article is closed for comments.