how to insert multiple rows in excel 2016

1
Insert one or more rows, columns, or cells in
Excel for Mac
2

• You can insert rows above a selected row and
  columns to the left of a selected column.
  Similarly, you can insert blank cells above or to
  the left of the active cell on a worksheet. Cell
  references automatically adjust to match the
  location of the shifted cells.

3
Insert rows
4
Office setup is the best software which is widely
used in globe .It is a powerful service that
activate office 2016 helps you unleash your best
ideas , get things done, and stay connected on
the go. For more details visit here.

5
Step 1

• Select The Heading Of The Row Above Where You
  Want To Insert Additional Rows.

Tip Select the same number of rows as you want
to insert. For example, to insert five blank
rows, select five rows. Its okay if the rows
contain data, because it will insert the rows
above these rows.
6
Step 2

• Hold Down CONTROL, Click The Selected Rows, And
  Then On The Pop-up Menu, Click Insert.

Tip To insert rows that contain data, see Copy
and paste specific cell contents.
7
Insert columns
8
Step 1

• Select the heading of the column to the right of
  which you want to insert additional columns.

Tip Select the same number of columns as you
want to insert. For example, to insert five blank
columns, select five columns. Its okay if the
columns contain data, because it will insert the
columns to the left of these rows.
9
step 2

• Hold down CONTROL, click the selected columns,
  and then on the pop-up menu, click insert.

Tip To insert columns that contain data,
see Copy and paste specific cell contents .
10
Insert cells

• When You Insert Blank Cells, You Can Choose
  Whether To Shift Other Cells Down Or To The Right
  To Accommodate The New Cells. Cell References
  Automatically Adjust To Match The Location Of The
  Shifted Cells.

11

• Select the cell, or the range of cells, to the
  right or above where you want to insert
  additional cells.

Tip Select the same number of cells as you want
to insert. For example, to insert five blank
cells, select five cells.
12

• Hold down CONTROL, click the selected cells, then
  on the pop-up menu, click insert.

13

• On the insert menu, select whether to shift the
  selected cells down or to the right of the newly
  inserted cells.

14
Here's what happens when you shift cells left
15
Here's what happens when you shift cells down
16
Thank-you for watching
For more details visit activate office 2016