By default the background color of the cell is white in MS Excel. You can change it as per your need from Home tab » Font group » Background color.

Changing Foreground Color

By default, the foreground or text color is black in MS Excel. You can change it as per your need from Home tab » Font group » Foreground color.

Also you can change the foreground color by selecting the cell Right click » Format cells » Font Tab » Color.

Text Alignments in Excel

If you don’t like the default alignment of the cell, you can make changes in the alignment of the cell. Below are the various ways of doing it.

Change Alignment from Home Tab

You can change the Horizontal and vertical alignment of the cell. By default, Excel aligns numbers to the right and text to the left. Click on the available option in the Alignment group in Home tab to change alignment.

Change Alignment from Format Cells

Right click on the cell and choose format cell. In format cells dialogue, choose Alignment Tab. Select the available options from the Vertical alignment and Horizontal alignment options.

Exploring Alignment Options

1. Horizontal Alignment − You can set horizontal alignment to Left, Centre, Right, etc.
• Left − Aligns the cell contents to the left side of the cell.
• Center − Centers the cell contents in the cell.
• Right − Aligns the cell contents to the right side of the cell.
• Fill − Repeats the contents of the cell until the cell’s width is filled.
• Justify − Justifies the text to the left and right of the cell. This option is applicable only if the cell is formatted as wrapped text and uses more than one line.
2. Vertical Alignment − You can set Vertical alignment to top, Middle, bottom, etc.
• Top Aligns the cell contents to the top of the cell.
• Center Centers the cell contents vertically in the cell.
• Bottom Aligns the cell contents to the bottom of the cell.
• Justify Justifies the text vertically in the cell; this option is applicable only if the cell is formatted as wrapped text and uses more than one line.
So, this brings us to the end of blog. This Tecklearn ‘How to Rotate Cells, Setting Colors and Text Alignment 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

584