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.

Delete Worksheet in Excel

---

Delete Worksheet

Here is the step to delete a worksheet.

Step − Right Click the Sheet Name and select the Delete option.

Sheet will get deleted if it is empty, otherwise you'll see a confirmation message.

Press the Delete Button.

Now your worksheet will get deleted.

Hiding Worksheet in Excel

---

Hiding Worksheet

Here is the step to hide a worksheet.

Step − Right Click the Sheet Name and select the Hide option. Sheet will get hidden.

Unhiding Worksheet

Here are the steps to unhide a worksheet.

Step 1 − Right Click on any Sheet Name and select the Unhide... option.

Step 2 − Select Sheet Name to unhide in Unhide dialog to unhide the sheet.

Press the Ok Button.

Now you will have your hidden sheet back.

Copy Worksheet in Excel

---

Copy Worksheet

First of all, let us create some sample text before we proceed. Open a new excel sheet and type any data. We've shown a sample data in the screenshot.

OrderDate	Region	Rep	Item	Units	Unit Cost	Total
1/6/2010	East	Jones	Pencil	95	1.99	189.05
1/23/2010	Central	Kivell	Binder	50	19.99	999.5
2/9/2010	Central	Jardine	Pencil	36	4.99	179.64
2/26/2010	Central	Gill	Pen	27	19.99	539.73
3/15/2010	West	Sorvino	Pencil	56	2.99	167.44
4/1/2010	East	Jones	Binder	60	4.99	299.4
4/18/2010	Central	Andrews	Pencil	75	1.99	149.25
5/5/2010	Central	Jardine	Pencil	90	4.99	449.1
5/22/2010	West	Thompson	Pencil	32	1.99	63.68
6/8/2010	East	Jones	Binder	60	8.99	539.4
6/25/2010	Central	Morgan	Pencil	90	4.99	449.1
7/12/2010	East	Howard	Binder	29	1.99	57.71
7/29/2010	East	Parent	Binder	81	19.99	1,619.19
8/15/2010	East	Jones	Pencil	35	4.99	174.65

Here are the steps to copy an entire worksheet.

Step 1 − Right Click the Sheet Name and select the Move or Copy option.

Step 2 − Now you'll see the Move or Copy dialog with select Worksheetoption as selected from the general tab. Click the Ok button.

Select Create a Copy Checkbox to create a copy of the current sheet and Before sheet option as (move to end) so that new sheet gets created at the end.

Press the Ok Button.

Now you should have your copied sheet as shown below.

You can rename the sheet by double clicking on it. On double click, the sheet name becomes editable. Enter any name say Sheet5 and press Tab or Enter Key.

Create Worksheet in Excel

---

Creating New Worksheet

Three new blank sheets always open when you start Microsoft Excel. Below steps explain you how to create a new worksheet if you want to start another new worksheet while you are working on a worksheet, or you closed an already opened worksheet and want to start a new worksheet.

Step 1 − Right Click the Sheet Name and select Insert option.

Step 2 − Now you'll see the Insert dialog with select Worksheet option as selected from the general tab. Click the Ok button.

Now you should have your blank sheet as shown below ready to start typing your text.

You can use a short cut to create a blank sheet anytime. Try using the Shift+F11 keys and you will see a new blank sheet similar to the above sheet is opened.