MS Excel Merge & Wrap, Borders, Shades, Apply Formatting

Merge & Wrap in Excel Tutorial


Merge Cells
You can merge two or more cells into one easily in Microsoft Excel Sheet. During merging the cells together, it must be noted that content does not merge. Merging cells together simply removes the separating boundary between cells. 
  • To merge the desired cells, select them together and go to the Merge & Center control option listed under the Home Tab as shown below.
  • You can also merge cells from the Format Cells dialogue box and ticking the option for “Merge Cells” listed under Alignment tab.
Additional Options
You can find additional options listed under the Merge and Center Control drop down list along with Merge and Center option. This control is listed under Alignment group in Home Tab.
  • Merge Across: This option merges the cells together only which are contained in the same row keeping the identity of the row while merging producing one for each row.
  • Merge Cells: This option lets you simply merge the cells without applying Center Alignment feature.
  • Unmerge Cells: This option unmerges the merged cells selected.
Wrap Text and Shrink to Fit
In case the text is too long for a cell to accommodate, you can use one of two options, Wrap Text or Shrink to Fit. Wrap Text will adjust the text in separate lines one below the other whereas shrink to fit will reduce the size to fit within the cell width.

Borders and Shades in Excel Tutorial


Apply Borders
Microsoft Excel offers you to apply border to the selected cells. To apply the border, open the Format Cells Dialog Box by right clicking the cell. Find the option for “Select the Border Style” under Border Tab as shown below in the screenshot.
You can also apply border by using the option of “Apply Borders” listed in Font Group under Home Tab.
Apply Shading
Excel also allows you to add shades to the cell. To add shade, use the option “ Select the Color” listed in Font Group under Home Tab.

Apply Formatting in Excel Tutorial


There are many options available in Microsoft Excel for applying various formatting options to a single or multiple selected cells. You can find the options in the Format Cells Dialog Tab listed under various Tabs as shown below.
Here is the list of various Tabs along with short description:
  • Number: This option allows you to set the format of a cell according the text contained in the cell.
  • Alignment: This Tab lists various options for setting the desired alignment for the text contained in a cell.
  • Font: This Tab lists various options which lets you change the font, font size etc.
  • Border: This Tab lists various options which let you select an appropriate border for your cell with various patterns and width.
  • Fill: This Tab lists various options that lets you choose from the different fill patterns and themes available.
  • Protection: This Tab lists options relating to the Excel Sheet Protection like Locked, and Hidden.

No comments: