How to use SORT in Excel

Hi..Readers !

In this lesson you can learn how to Arrange Records in A-Z or Z-A Order we also called SORT Order in Excel sheet. Watch below Steps


Steps 1:


Create a Table as per given below

 A                    B                    C
Slno               name             Salary
105                    Anthony          15000
108                    David              17000
103                    Misra                25000
104                   Vasavi              28000




Step2:
Select above table ->  Go to 'DATA' Menu  -> Click 'SORT'


 Step3:
 Now select 'Ascending (A-Z) Order ->  Click 'Ok'


Now Your Table will be like this



Slno               name             Salary
103                    Misra                25000
104                   Vasavi              28000
105                    Anthony          15000
108                    David              17000

How to Hide or Show Worksheets in Excel

Show or Hide Worksheets 

It is very easy. You can hide any sheet in your excel work book. when ever you want you can make sheet visible. follow the below steps to make hide sheets or show sheets in excel workbook

step 1:

in the above screen shot, We have 3 sheets by default in excel workbook, to Hide sheet 1 , right click on sheet click to 'Hide' option.

Step 2:

Once you click hide button, you are able to see only 2 sheets in your workbook,

Steps for Unhide Sheet

1.right click and Click 'Unhide' 
2.Select Your Sheet 1
3.Click to 'OK'

How to Remove duplicates Values

Hi...Readers !


 In this lesson I am going tell you remove duplicate values from the excel data. Lets see how to do this.


1. select entire Table -> data -> Remove Duplicates


2. Click to 'Select All' Button -> Ok.

Now, It removes row 6, because row 1 and row 6 are same. so it removes only row 6.


Thank you.
Excel Tips