Home
Learn
Forum
Others Links
Learn
Microsoft Word
Microsoft Excel
Dictionary
ContactMicrosoft Excel
introduction
requirements for MS excel
creating a new workbook
saving a workbook
closing a workbook
opening a workbook
Activating worksheet
activating cell
editing a workbook
saving an existing workbook with a different name and location
renaming a worksheet
inserting a worksheet
deleting a worksheet
Copying a worksheet to another workbook
moving a worksheet within the same workbook
selecting cells using mouse
merge and center
copying cells
moving cells
inserting cells, rows or columns
deleting cells, rows or columns
changing column width
changing row height
formatting characters in cells
formatting cells with borders
Using different formats
Exiting from MS Excel
using text alignment
using undo, redo
Changing page margins
Next Page>>>
Booksrequirements for MS excel
creating a new workbook
saving a workbook
closing a workbook
opening a workbook
Activating worksheet
activating cell
editing a workbook
saving an existing workbook with a different name and location
renaming a worksheet
inserting a worksheet
deleting a worksheet
Copying a worksheet to another workbook
moving a worksheet within the same workbook
selecting cells using mouse
merge and center
copying cells
moving cells
inserting cells, rows or columns
deleting cells, rows or columns
changing column width
changing row height
formatting characters in cells
formatting cells with borders
Using different formats
Exiting from MS Excel
using text alignment
using undo, redo
Changing page margins
Next Page>>>
Dictionary
Forum
Others Links
Time -
Clock
Forgot Password?
Chapter 20
inserting cells, rows or columns
To insert cells, rows or columns follow these instructions :
Select a cell or range of cells.
From the Insert menu, choose the option CELLS.
Or click on the arrow sign of the Insert icon at the left of the Cells option of the Home tab and select Insert Cells.
A dialog box will be displayed.
Select the option Shift Cell Up/Down/Right/Left.
Click on OK.
This will insert the same number of rows or columns as you selected. To insert a single row or column you can also follow these :
Select the row or column before which you want to insert new row or column.
From the Insert menu, choose the option ROWS or COLUMNS.
Or click on the arrow sign of the Insert icon at the left of the Cells option of the Home tab and select Insert Sheet Rows or Insert Sheet Columns.
Was this helpful for you?
