Search This Blog

Friday, November 11, 2016

Inserting New Cell(s) In LibreOffice Spreadsheet V5.2.3


As you may already know, in a spreadsheet program such as LibreOffice Spreadsheet v5.2.3, Cell refers to the rectangular box that is formed by the intersection of a row and a column.

There are basically three ways in which you can insert new cells in your worksheet of LibreOffice Spreadsheet v5.2.3, but we are going to talk extensively on two of the method. So let us being with the first way to insert a new blank cell.





Using The File Menu:
  1. Select the cell where you want the new blank cell to appear.
    Note: if you want to insert more than one cells, then you need to select the corresponding number of cells. For example, if you need to insert new blank 3 cells, then you need to select the 3 cells that is currently occupying the position where you want the new cells to appear.
     
  2. Select the Sheet tab.
     
  3. Then click on the Insert Cells... option in the drop-down menu that will appear.

     
  4. In the Insert Cells dialog box that will appear, select either of the following option:
    1. Shift cells right: If you want the cell to be inserted at the current select cell position, but the selected cell will be moved to the right.
    2. Shift cells down: If you want the cell to be inserted at the current select cell position, but the selected cell will be moved downward.

       
  5.  Finally click the OK button in the insert dialog box to insert the new blank cells.

Using The Right-Menu:

  1. Select the cell where you want the new blank cell to appear.
    Note: if you want to insert more than one cells, then you need to select the corresponding number of cells. For example, if you need to insert new blank 3 cells, then you need to select the 3 cells that is currently occupying the position where you want the new cells to appear.
     
  2. Right-click on the selected cell.
     
  3. Then click on Insert... from the right-click menu.

     
  4. In the Insert Cells dialog box that will appear, select either of the following option:
    1. Shift cells right: If you want the cell to be inserted at the current select cell position, but the selected cell will be moved to the right.
    2. Shift cells down: If you want the cell to be inserted at the current select cell position, but the selected cell will be moved downward.

       
  5.  Finally click the OK button in the insert dialog box to insert the new blank cells.

Tips:
You can also access the Insert Cells dialog box by using Ctrl + + (i.e Ctrl + Shift + =)
 OR
pressing Alt + S + (Enter button) in the keyboard. These keys should be pressed one after the other and not while holding one key down.

Team Pinfoltd



SHARE THIS

0 comments:

Search This Blog