Rows & Columns in Excel

---

Row and Column Basics

MS Excel is in tabular format consisting of rows and columns.

• Row runs horizontally while Column runs vertically.

• Each row is identified by row number, which runs vertically at the left side of the sheet.

• Each column is identified by column header, which runs horizontally at the top of the sheet.

For MS Excel 2010, Row numbers ranges from 1 to 1048576; in total 1048576 rows, and Columns ranges from A to XFD; in total 16384 columns.

Navigation with Rows and Columns

Let us see how to move to the last row or the last column.

• You can go to the last row by clicking Control + Down Navigation arrow.

• You can go to the last column by clicking Control + Right Navigation arrow.

Cell Introduction

The intersection of rows and columns is called cell.

Cell is identified with Combination of column header and row number.

For example − A1, A2.

Move Data in Excel

---

Let us see how we can Move Data with MS Excel.

Step 1 − Select the data you want to Move. Right Click and Select the cut option.

Step 2 − Select the first cell where you want to move the data. Right click on it and paste the data. You can see the data is moved now.

Delete Data in Excel

---

MS Excel provides various ways of deleting data in the sheet. Let us see those ways.

Delete with Mouse

Select the data you want to delete. Right Click on the sheet. Select the delete option, to delete the data.

Delete with Delete Key

Select the data you want to delete. Press on the Delete Button from the keyboard, it will delete the data.

Selective Delete for Rows

Select the rows, which you want to delete with Mouse click + Control Key.Then right click to show the various options. Select the Delete option to delete the selected rows.

Select Data in Excel

---

MS Excel provides various ways of selecting data in the sheet. Let us see those ways.

Select with Mouse

Drag the mouse over the data you want to select. It will select those cells as shown below.

Select with Special

If you want to select specific region, select any cell in that region. Pressing F5will show the below dialogue box.

Click on Special button to see the below dialogue box. Select current region from the radio buttons. Click on ok to see the current region selected.

As you can see in the below screen, the data is selected for the current region.

Insert Data in Excel

---

In MS Excel, there are 1048576*16384 cells. MS Excel cell can have Text, Numeric value or formulas. An MS Excel cell can have maximum of 32000 characters.

Inserting Data

For inserting data in MS Excel, just activate the cell type text or number and press enter or Navigation keys.

Inserting Formula

For inserting formula in MS Excel go to the formula bar, enter the formula and then press enter or navigation key. See the screen-shot below to understand it.

Modifying Cell Content

For modifying the cell content just activate the cell, enter a new value and then press enter or navigation key to see the changes. See the screen-shot below to understand it.

Open Workbook in Excel

---

Let us see how to open workbook from excel in the below mentioned steps.

Step 1 − Click the File Menu as shown below. You can see the Open optionin File Menu.

There are two more columns Recent workbooks and Recent places, where you can see the recently opened workbooks and the recent places from where workbooks are opened.

Step 2 − Clicking the Open Option will open the browse dialog as shown below. Browse the directory and find the file you need to open.

Step 3 − Once you select the workbook your workbook will be opened as below −

Close Workbook in Excel

---

Close Workbook

Here are the steps to close a workbook.

Step 1 − Click the Close Button as shown below.

You'll see a confirmation message to save the workbook.

Step 2 − Press the Save Button to save the workbook as we did in MS Excel - Save Workbook chapter.

Now your worksheet will get closed.