How to Set Row or Column size in excel

Ya...Many of your not aware of how Set Column or Row Size easily in Excel. I will show you How to Set size. see below image.

Column Width Change

Column Width Change

Column Width Change

Column Width Change

Here, I Selected Column 'M'
Now Click 'Format' Button -> Now Click 'Column Width' Option -> Then It allow to Enter size.

like Below. Here I am Giving '25' input value.


Now Click to 'OK' Button. See the Result. below


Your Column Size is Bigger now.

Note: Similarly You Practice for ROW Height. Try Your Self if you unable to do this click 'Row Height' Tutorial.


Thank You.
Excel Tips Blog.

How to Remove Duplicate Records from the list in Excel

In this tutorial you will know that how to remove duplicate values from given database

product id	Product	Price	Qty	Sell Date
CES1015	Computer PC	$                25,000.00	15	1/4/2016
CES1016	Dell Laptop	$                45,000.00	10	1/5/2016
CES1017	Logitec Mouse	$                      150.00	5	1/4/2016
CES1018	Microsoft keyboard	$                      250.00	2	1/5/2016
CES1015	Computer PC	$                25,000.00	15	1/4/2016
CES1019	Dell Laptop I7	$                48,000.00	12	1/4/2016

In the above table some duplicate records are there, using the given steps you can remove that records,  

step1

Select the entire table

Step2

Go to ‘DATA’ menu -> Click ‘DUPLICATE VALUES’

 

 

 

 

 

 

Step3:

Click ‘SELECT ALL’ -> OK

Lesson : How to Hide Cells in Excel Sheet.

The above screen show cell margins in light gray color in Excel sheet, if you want to hide that cells margins and make them white do this process 

Steps :

Go to Page Layout menu , Make sure disable View option as per show below, then it will hide.

To Visible again, Enable View.