-
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…
-
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…
-
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…
-
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…
-
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 −…
-
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…
-
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…
-
Open Workbook in M S 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…
-
Insert Data in M S 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…
-
Select Data in M S 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…