Tag: Microsoft 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 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 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 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 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.

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. File […]

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. Insert Data Inserting Formula For inserting formula in MS Excel go to the formula bar, enter […]

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 Data with mouse Select with Special If you want to select specific region, select any cell in that […]

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 Selected Data with mouse Delete with Delete Key Select the data you want to delete. Press on the Delete Button from […]

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. Cut Selected data with Right Click 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. Moved Data