Shift cells to the left or above

To shift cells to the left or above:

1. Select the cells to be shifted.

2. Click Edit > Delete > Shift Cells Left or Shift Cells Up to move the cells to the left or up respectively.

• Related Articles

• Insert cells in a sheet / Shift the cells to the right or down.

  To shift cells to the right or down: 1. Select the cells to be shifted. 2. Click Insert > Cell > Shift Cells Right or Shift Cells Down to move the cells to the right or down respectively.

• Change the alignment of data in cells

  You can change both the horizontal and the vertical alignment of data entered into the cell. To change the alignment of data inside the cells: 1. Select the cells to be aligned.  2. On the default toll bar, click on Alignment    icon. 3. Choose to ...

• Remove or clear the formatting from cells

  To clear the formatting of a cell: Select the cell you want to clear the formatting of. Click on the Clear icon  in the tool bar. You can then choose to clear only the formats from the cell. Alternatively, right click on the cell you want to clear ...

• Lock cells

  To lock a range of cells, Select the particular cell or range of cells that you wish to lock. Select Data > Lock> Lock Cells. You can also right click on the selected range and click Lock Cells. The Lock Cells dialog box appears. Choose the ...

• Apply borders to cells

  To apply borders for cells: 1. Select the cell(s). Click the Borders  icon from the toolbar. 2. You can choose from a range of border types that are available . These are the types that you can choose from : You can also choose from the various ...