PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES

CONTENTS

HOW TO INSERT SHEETS, COLUMNS AND ROWS IN EXCEL?

HOW TO INSERT SHEETS IN EXCEL ?

“SHEETS” ARE A SUB-GROUP OF ANY FILE IN MICROSOFT EXCEL .

SHEETS ARE THE DIFFERENT WORKING AREAS WHICH ARE IN THE SAME FILE OR WORKBOOK .

 

THE ARTICLE WILL DISCUSS THE TOPICS LIKE HOW TO INSERT SHEETS, ROWS OR COLUMNS IN EXCEL YOUR WORKBOOK.

SHEETS CAN BE USED TO CLASSIFY THE DATA OR KEEP THE GROUPS DIFFERENT.

 SIMPLY STATING

AN EXCEL FILE IS KNOWN AS A WORKBOOK.

SHEETS ARE THE DIFFERENT WORK AREAS WITHIN A WORKBOOK.

 

BUTTON LOCATION FOR INSERTION OF SHEETS, COLUMNS OR ROWS IN EXCEL

The button locations for INSERTING SHEETS, ROWS AND COLUMNS is under the HOME TAB and cells subsection as shown in the picture.

The location is same for the later versions of Excel also like Excel 2010, 2013, 2016, 2019 etc.

EXCEL SHEETS
BUTTON LOCATION FOR INSERTING CELLS, SHEETS AND COLUMNS

STEPS TO INSERT SHEETS IN EXCEL

STEPS:

  • Open the option under tab HOME>CELLS>INSERT.
  • CLICK Insert Sheet.
  • A new sheet will be added.

STEPS TO INSERT CELLS IN EXCEL

STEPS:

  • Open the option under tab HOME>CELLS>INSERT.
  • CLICK Insert Cells.
  • Following dialog box will be opened.
Excel cells insert

STEPS:

  • Choose the action to be performed on rest of the cells when New cells are inserted.
  • SHIFT CELLS RIGHT: Shift the cells to the right and insert the cells at their older place.
  • SHIFT CELLS LEFT: Shift the cells to the left and insert the cells at their older place.
  • ENTIRE ROW: Insert an entire row and shift the rest of the cells down [The complete rows will be shifted down ].
  • ENTIRE COLUMN: Insert column and shift the rest of the cells to the right. [A new column will be added ]

STEPS TO INSERT COLUMNS IN EXCEL

Refer to the picture below.

STEPS:

  • SELECT the column preceding to the new column to be introduced.(The new column will be inserted next to the column selected.)
  • Click INSERT SHEET COLUMNS.
  • THE column will be inserted immediately.
ADDING MULTIPLE COLUMNS
  • Select the number of columns needed to be inserted and then click the option INSERT SHEET COLUMNS. The number of columns selected will be added and the selected columns will be shifted to the right.
EXCEL SHEETS
INSERT COLUMNS IN SHEETS- MICROSOFT EXCEL

STEPS TO INSERT ROWS IN EXCEL

Refer to the picture below.

STEPS:

  • SELECT the rows above  the new row/rows to be inserted. (The new rows will be inserted on top of the selected row.)
  • Click INSERT SHEET ROWS.
  • THE ROWS will be inserted immediately.
ADDING MULTIPLE ROWS
  • Select the number of rows needed to be inserted and then click the option INSERT SHEET ROWS. The number of rows selected will be added and the selected rows will be shifted downside.
EXCEL SHEETS
INSERT ROWS IN SHEET- MICROSOFT EXCEL

Leave a Reply

YOU MAY LIKE

LEARN

  • EXCEL
  • HTML
  • JAVASCRIPT
  • MORE TO COME…

Encourage us by following at …

If you have any queries or suggestions or any problem which you would like us to solve for you, kindly mail at

[email protected]

Leave a Reply