All language subtitles for 2. Editing Worksheets

In this video you will learn how to insert delete hide rows columns and cells in a log book you get

insert a row or a column in your vote sheet to better organize your data in this New York worksheet.

We also need to store information about number of units sold so let us insert a column to store the

information to insert the column before column sales amount.

Select Cell C one on the Home tab in the sales group click the insert arrow and then in the list click

insert Sheet Columns.

Excel inserts a new column C type number of units sold as the header in this column.

We also want to store information about unit price of items sold.

You can also insert column by right clicking a sale and then select Insert from the list select entire

column and click ok Excel inserts a new column type unit price as the header in this column.

Like columns we can also insert rows select a sale in the raw and click insert sheet rows in the insert

list Excel insert a neutral.

You can also right click a sale in the row above which you want to insert a neutral then select Insert

from the list select entire row and click Okay.

Excel inserts a neutral.

You can hide rows or columns in the worksheet rightly the column header of column C and then click.

Hide note that column C disappears but it is only hidden not deleted.

To hide the hidden column.

Select the column headers on either side of the hidden column right click and select and hide.

You can also hide on and hide columns from the format button in the sales group on the Home tab.

You can also hide rows in the civil Lemon right click the row header and then click.

Height note that row disappears.

But it is only hidden not deleted to hide the hidden row.

Select the raw headers on each side of the hidden drawer right click and select and hide.

Let us not try deleting some cells on the tab but click the Los Angeles sheet that click Cell C 9 and

on the Home tab in the cells group click the delete arrow then in the list click delete cells that delete

dialog box opens.

Select the shift self up radio button and click Okay.

Exhales delete Cell C 9 and shift the cells C 10 and C eleven up you can insert individual cells into

a worksheet to insert a cell click the cell that you want.

The new cell to appear let us click cell a trail in the cells group under insert list click insert cells

select the shift cells write radio button and then click OK.

Excel inserts a new cell 812 You can also insert cells by right clicking the cell and selecting insert.

You can also move the data in a group of cells to another location in your vote sheet to do that.

Select the cells you want to move and point the mouse through the selection.

The point that changes to afford pointed at or you can use to drag these selected cells to the new location.