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

HOW TO insert sheets, columns and rows IN EXCEL?

how to insert sheets in excel?

“SHEET” IS A SUB-GROUP OF ANY FILE. SHEETS ARE THE DIFFERENT WORKING AREAS BUT IN THE SAME FILE. THE ARTICLE WILL DISCUSS HOW TO INSERT SHEETS, ROWS OR COLUMNS IN EXCEL YOUR WORKBOOK.

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

 

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

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

EXCEL SHEETS

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 in their old place.
  • SHIFT CELLS LEFT: Shift the cells to the left and insert the cells in their old place.
  • ENTIRE ROW: Insert an entire row and shift the rest of the cells down.
  • ENTIRE COLUMN: Insert column and shift the rest of the cells to the right.

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

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

OTHER WAYS TO REACH THIS ARTICLE

  • INSERT SHEETS IN EXCEL, HOW TO INSERT ROWS AND COLUMNS

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

gyankosh060309@gmail.com

Pin It on Pinterest

Share This

KINDLY SPEND FEW SECONDS HERE....

%d bloggers like this: