Question Discussion & Solution

In 2003 and earlier versions - From Format Cells dialog box click on Merge Cells check box
In 2007 and subsequent versions - Merge & Center icon on the Home ribbon.

To select an entire column in MS-EXCEL, Click the column heading letter or press CTRL + Space Bar key.

Ctrl + H shortcut key is usedto replace a data with another in sheet.

Use the excel menu bar and toolbars inside the word application to edit in an embedded excel worksheet object in a word document.

An array formula is a formula that can perform multiple calculations on one or more of the items in an array. We can think of an array as a row of values, a column of values, or a combination of rows and columns of values. Array formulas can return either multiple results or a single result. For example, we can create an array formula in a range of cells and use the array formula to calculate a column or row of subtotals. We can also place an array formula in a single cell and calculate a single amount. An array formula that includes multiple cells is called a multi-cell formula, and an array formula in a single cell is called a single-cell formula.