Best Offer for Books in Amazon

Tuesday 16 May 2017

How to use 'MERGECELLS' in Excel sheet

Hi. Readers!

in this lesson we are going to learn how to use 'MERGECELLS' in excel, this feature is very important feature in excel sheet, many people use mergecells for merge multiple cells as a single cell and add their text into center position of the cells like report titles, project heading ect. Let us see how do the mergecells in excel sheet, watch below steps how to create mergecells.

using merge cells in excel






steps:
1. select more than two cells in your excel sheet row or column
2. Go to Home Tab -> click 'MERGECELLS' -> Click 'merge & center' option.
3. now, enter your text into this cell.
4. then press enter , your text position will be exact center of the cell.



No comments:

Post a Comment

How to Protect sheet in Ms-Excel

STEPS:  1. OPEN Ms-Excel 2. Go to Review-> Protect Sheet -> Protect sheet  3. enter Password -> Re-enter Password-> save.