google search

Tuesday, April 16, 2019

To Insert rows, columns and cells on a worksheet

How to modify columns, rows, and cells





How to insert rows, columns and cells on a worksheet

In Excel, you can insert blank cells above/below or to the left/right of the active cell on a worksheet shift other cells in the same column down or in the same row to the right. you can also insert rows above or below a row and columns to the left or to the right of a column. You can as well delete cells, rows, and columns. The Excel has limits of 18,278 A to Z columns wide by 1,048,576 rows tall.

How to insert rows on a worksheet

  •  Select the row below where you want the new row to appear.
 How to select rows, columns, and cells
  • Click on the arrow next to Insert on the Cells Group under Home tab
  • And then click Insert Sheet Rows.
  • The new row always appears above the selected row.
  • If you select just the cell and then click Insert, only a new cell will appear.
  •  So make sure you select the entire row below where you want the new row to appear and not just the cell.
  •  Notice that when you insert rows on your worksheet, all references that are affected by the insertion adjust accordingly, whether they are relative or absolute references. The same applies to deleting rows, except when a deleted cell is directly referenced by a formula.
·         If you want references to adjust automatically, it is a good idea to use range references whenever appropriate in your formulas, rather than specifying individual cells.

Tips: when you want to quickly repeat this action of inserting a row, click the location where you want to insert the row, and then press CTRL+Y that is to Redo an action. 

how to select character in a cell

How to insert columns on a worksheet

  • Select the column to the right of where you want the column to appear.
  • In the Cells group under Home tab,
  • Click the arrow next to Insert,


 





  •  And then click Insert Sheet Columns.



  • The new column always appears to the left of the selected column, only a new cell will appear when you select just the cell and click insert so make sure you select the entire column to the right of where you want the new column to appear and not just the cell.  

How to insert blank cells on a worksheet

  • Select the cell or the range of cells where you want to insert the new blank cell
  • Select the same number of cells as you want to insert. For example, to insert five blank cells, you need to select five cells.
  • Click on Insert Cells in the Cells group on the Home tab an insert dialog box will appear
You can cancel a selection of cells by clicking any cell on the worksheet.
  • In the Insert dialog box, click the direction in which you want to shift the surrounding cells.
  • And click ok
Right click the selected cells and then click Insert on the shortcut menu.

How to Modify/Adjust Row height

No comments:

Post a Comment