, ,

14. Getting Help

MS Excel provides context sensitive help on mouse over. To see context sensitive help for a particular Menu option, hover the mouse over the option for some time. Then you can see the context sensitive Help as shown below.Getting More…
, ,

13. Opening a Workbook

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…
, ,

12. Closing a 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 I did in MS Excel…
, ,

11. Deleting a 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…
, ,

10. Hiding a 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…
, ,

9. Basics: Copying a 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 Total1/6/2010 East Jones Pencil 95 1.99 189.051/23/2010 Central Kivell Binder 50 19.99 999.52/9/2010 Central Jardine Pencil 36 4.99 179.642/26/2010 Central Gill Pen 27 19.99 539.733/15/2010 West Sorvino Pencil 56 2.99 167.444/1/2010 East Jones Binder 60 4.99 299.44/18/2010 Central Andrews Pencil 75 1.99 149.255/5/2010 Central Jardine Pencil 90 4.99 449.15/22/2010 West Thompson Pencil 32 1.99 63.686/8/2010 East Jones Binder 60 8.99 539.46/25/2010 Central Morgan Pencil 90 4.99 449.17/12/2010 East Howard Binder 29 1.99 57.717/29/2010 East Parent Binder 81 19.99 1,619.198/15/2010 East Jones Pencil 35 4.99 174.65Here…
, ,

8. Basics: Saving a Workbook

Saving New Sheet Once you are done with typing in your new excel sheet, it is time to save your sheet/workbook to avoid losing work you have done on an Excel sheet. Following are the steps to save an edited excel sheet −Step 1 − Click…
, ,

7. Basics: Creating New Worksheet

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…
, ,

6. Basics: Moving around in Excel

Excel provides a number of ways to move around a sheet using the mouse and the keyboard.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…
, ,

5. Basics: Entering Values in Cell

Entering values in excel sheet is a child’s play and this chapter shows how to enter values in an excel sheet. A new sheet is displayed by default when you open an excel sheet as shown in the below screen shot.Sheet area is the place…