The following basic window appears when you start the excel application. Let us now understand the various important parts of this window. (toc) Explore Excel Window File Tab The File tab replaces the Office button from Excel 2007. You can click it to check the Backstage view, where you come when you need to open or save […]
Tag: M S Office
Backstage View in M S Excel
The Backstage view has been introduced in Excel 2010 and acts as the central place for managing your sheets. The backstage view helps in creating new sheets, saving and opening sheets, printing and sharing sheets, and so on. (toc) Getting to the Backstage View is easy. Just click the File tab located in the upper-left corner of the Excel […]
Entering Values in M S Excel
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. Enter Text Sheet area is the place where you type your text. The flashing […]
Move Around in M S 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 Cost Total 1/6/2010 […]
Save Workbook in M S Excel
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 the File tab and select Save As option. Save As Option Step 2 − […]
Create Worksheet in M S 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 − […]
Copy Worksheet in M S 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 […]
Hiding Worksheet in M S 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. Hide Sheet Unhiding Worksheet Here are the steps to unhide a worksheet. Step 1 − Right Click on any Sheet Name and select the Unhide… option. Unhide Sheet Step 2 − Select Sheet Name to unhide in Unhide dialog to unhide the sheet. Press […]
Delete Worksheet in M S Excel
Delete Worksheet Here is the step to delete a worksheet. Step − Right Click the Sheet Name and select the Delete option. Delete Sheet Sheet will get deleted if it is empty, otherwise you’ll see a confirmation message. Delete Sheet 2 Press the Delete Button. Now your worksheet will get deleted.
Close Workbook in M S Excel
Close Workbook Here are the steps to close a workbook. Step 1 − Click the Close Button as shown below. Close Sheet You’ll see a confirmation message to save the workbook. Close Sheet2 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.