How to Merge & Wrap Cells, Borders and Shades and Apply Formatting in Excel

Last updated on May 28 2022
Ravinder Patil

Table of Contents

How to Merge & Wrap Cells, Borders and Shades and Apply Formatting in Excel

Merge Cells

MS Excel enables you to merge two or more cells. When you merge cells, you don’t combine the contents of the cells. Rather, you combine a group of cells into a single cell that occupies the same space.

You can merge cells by various ways as mentioned below.

• Choose Merge & Center control on the Ribbon, which is simpler. To merge cells, select the cells that you want to merge and then click the Merge & Center button.

How to Merge & Wrap Cells, Borders and Shades and Apply Formatting in Excel
How to Merge & Wrap Cells, Borders and Shades and Apply Formatting in Excel

• Choose Alignment tab of the Format Cells dialogue box to merge the cells.

How to Merge & Wrap Cells, Borders and Shades and Apply Formatting in Excel
How to Merge & Wrap Cells, Borders and Shades and Apply Formatting in Excel

Additional Options

The Home » Alignment group » Merge & Center control contains a drop-down list with these additional options −

• Merge Across − When a multi-row range is selected, this command creates multiple merged cells — one for each row.
• Merge Cells − Merges the selected cells without applying the Center attribute.
• Unmerge Cells − Unmerges the selected cells.

Wrap Text and Shrink to Fit

If the text is too wide to fit the column width but don’t want that text to spill over into adjacent cells, you can use either the Wrap Text option or the Shrink to Fit option to accommodate that text.

How to Merge & Wrap Cells, Borders and Shades and Apply Formatting in Excel
How to Merge & Wrap Cells, Borders and Shades and Apply Formatting in Excel

Borders and Shades in Excel

Apply Borders

MS Excel enables you to apply borders to the cells. For applying border, select the range of cells Right Click » Format cells » Border Tab » Select the Border Style.

How to Merge & Wrap Cells, Borders and Shades and Apply Formatting in Excel
How to Merge & Wrap Cells, Borders and Shades and Apply Formatting in Excel

Then you can apply border by Home Tab » Font group »Apply Borders.

How to Merge & Wrap Cells, Borders and Shades and Apply Formatting in Excel
How to Merge & Wrap Cells, Borders and Shades and Apply Formatting in Excel

Apply Shading

You can add shading to the cell from the Home tab » Font Group » Select the Color.

How to Merge & Wrap Cells, Borders and Shades and Apply Formatting in Excel
How to Merge & Wrap Cells, Borders and Shades and Apply Formatting in Excel

Apply Formatting in Excel

Formatting Cells

In MS Excel, you can apply formatting to the cell or range of cells by Right Click » Format cells » Select the tab. Various tabs are available as shown below

How to Merge & Wrap Cells, Borders and Shades and Apply Formatting in Excel
How to Merge & Wrap Cells, Borders and Shades and Apply Formatting in Excel

Alternative to Placing Background
• Number − You can set the Format of the cell depending on the cell content.
• Alignment − You can set the alignment of text on this tab.
• Font − You can set the Font of text on this tab.
• Border − You can set border of cell with this tab.
• Fill − You can set fill of cell with this tab.
• Protection − You can set cell protection option with this tab.

So, this brings us to the end of blog. This Tecklearn ‘How to Merge & Wrap Cells, Borders and Shades and Apply Formatting in Excel’ blog helps you with commonly asked questions if you are looking out for a job in Microsoft Excel. If you wish to learn Excel and build a career in Business Intelligence domain, then check out our interactive, Microsoft Power BI Training, that comes with 24*7 support to guide you throughout your learning period. Please find the link for course details:

Microsoft Power BI Training

Microsoft Power BI Training

About the Course

Microsoft Power BI Training at Tecklearn will help you achieve expertise in business analytics Our best online training course teaches you all important concepts like Power BI Desktop, Mobile, Power Query & Power Pivot, Data modelling, visualization, creating dashboards and reports, DAX, etc. As part of this program, you will work on real-world projects. Also, our Power BI course curriculum will equip you with all the key skills that are required to clear the Microsoft Power BI Certification exam (70-778).

Why Should you take Microsoft Power BI Training?

• The average annual pay for a Power BI Professional is $114,000 . -PayScale.com.
• Cognizant, Dell, KPMG, Hitachi, Wipro, Avanade, Annik Inc, Brillio and 45,000 MNCs across 185 countries use Power BI and it has a market share of around 7% globally.
• Microsoft Power BI has been ranked at No.1 position in the Gartner Magic Quadrant for Analytics and Business Intelligence Platforms for 13 consecutive years.

 

What you will Learn in this Course?

Introduction to Microsoft Power BI

• Microsoft Power BI Introduction
• Power BI Products
• Power BI Architecture
• Installing Power BI
• Connecting to Data Sources

Power BI Workflow

• Key features of Power BI workflow
• Power BI Vs MSBI
• History of Power BI
• Power BI Products
• Data modelling and relationships

Power Query for Data Transformation

• Power Query for Data Transformation
• Learning about Power Query for self-service ETL functionalities
• Working with Excel data
• Introduction to Query Editor
• Data transformation
• Pivot and UnPivot
• Merge Join, relational operators, date, time calculations, working with M functions
• Summary Tables
• Writing custom functions and error handling
• M advanced data transformations

Filters and Drill Down Report

• Visualization Filter
• Page Level Filter
• Report LEVEL Filter
• DRILL Through Filter or Report
• BookMark Report

Power Pivot for Data Modelling

• What is SSAS
• Data Modelling
• Star Schema
• Snowflake Schema
• Introduction to MDDB and Tabular
• Data Access Modes
• Tabular with DAX
• Power BI with DAX
• DAX Functions

Data Analysis Expression – DAX Queries

• TABULAR with DAX
• Power BI with DAX
• Calculated Members, Row, Filter & Evaluation Context
• Cumulative Charts
• Calculated Tables, ranking and rank over groups
• DAX advanced features

Power BI Desktop & Administration

• Reports and Visualization
• Learning about data modelling and data relationships
• Deploying data gateways
• Reports and Dashboards
• On Premises Data Gateway
• Gateway Clusters

Introduction to Power Q & A

• Power Service
• Power Q & A best practices
• Integrating with SaaS applications
• Gateway

 

0 responses on "How to Merge & Wrap Cells, Borders and Shades and Apply Formatting in Excel"

Leave a Message

Your email address will not be published. Required fields are marked *