How to Replace a Value in Excel

Replace Word :

 Hi.. Reader..In this tutorial I will show you how to Replace a value with another value in excel sheet.Watch this Screen Shot.

Step1:

1. Select a column in the table. Here I selected column 'course'.
2. Now Click ' Replace' Button in Home Tab. (you can use Ctrl+H short key to enable)
3. Now Type a value in 'find What' input box (ex.:dtp)
4. Now Type a Value in 'Replace with' input box (ex: Desktop Publishing)
5. Now 'REPLACE ALL' button below


now check your data all 'dtp' values will be changed as 'desktop publishing' like below

Thank  you
Excel Tips

How to Find a value in Excel Sheet

Find Values :

Hi..Readers in this Tutorial I Will Teach you how to find a value from Excel Sheet. Lets See how to Find a Value in the given Table, Watch the given screen shot.

in the Home Tab, You can see 'Find' Button , Click there.Now it allows you to Enter your input value in the text box. Type your value(K.Sailaja)  in the text box  and Click 'FIND NEXT' Button.

It will highlight the location where the word is located.

Now Click 'FIND NEXT' for search next location where it is located.




 Thank you.
Excel Tips

How to Use Merge & Center in Excel

USING 'MERGE & CENTER' in Excel


It Is used to merge More than one Cells as a Single Cell. Follow the Steps to Merge Cells.

Step :1

Select Cells from 'A' to 'G' in the Above Row1.
now, Click Merge & Center Button . Now See The Result.

now, Cell Grid lines Removed and  it becomes a single Cell.

Thank You
Excel Tips

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.