USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Center
|
|
|
Merge and Center
|
|
|
Autofit
|
|
|
Scale
|
Detailed explanation-1: -Select the range of cells over which you want to center text. Right-click the selected cells, and then click Format Cells. Click the Alignment tab. In the Horizontal list, click Center Across Selection.
Detailed explanation-2: -Select the grouping of cells that you would like to merge. Right click on the selected area and click Format Cells. Click the Alignment tab at the top of the pop-up menu. In the Alignment tab, open the Horizontal dropdown and select Center Across Selection.
Detailed explanation-3: -To merge a group of cells: To merge a group of cells and center the text, you can also use the Merge and Center button on the Excel tool bar.
Detailed explanation-4: -Click Home > Merge & Center. If Merge & Center is dimmed, make sure you’re not editing a cell or the cells you want to merge aren’t inside a table. Tip: To merge cells without centering the data, click the merged cell and then click the left, center or right alignment options next to Merge & Center.
Detailed explanation-5: -Merge across cells: To merge across cells in a single row, highlight the cells and use this keyboard shortcut: ALT H+M+C. Unmerge cells: If you need to unmerge a group of cells, you can highlight the merged cell and press the following keys at the same time: ALT H+M+U.