You can reverse almost every action in Excel by using the Undo command. We can undo changes in following two ways.
• From the Quick access tool-bar » Click Undo.
• Press Control + Z.

You can reverse the effects of the past 100 actions that you performed by executing Undo more than once. If you click the arrow on the right side of the Undo button, you see a list of the actions that you can reverse. Click an item in that list to undo that action and all the subsequent actions you performed.

Redo Changes

You can again reverse back the action done with undo in Excel by using the Redo command. We can redo changes in following two ways.
• From the Quick access tool-bar » Click Redo.
• Press Control + Y.

Setting Cell Type in Excel

Formatting Cell

MS Excel Cell can hold different types of data like Numbers, Currency, Dates, etc. You can set the cell type in various ways as shown below −
• Right Click on the cell » Format cells » Number.
• Click on the Ribbon from the ribbon.

Various Cell Formats

Below are the various cell formats.
• General − This is the default cell format of Cell.
• Number − This displays cell as number with separator.
• Currency − This displays cell as currency i.e. with currency sign.
• Accounting − Similar to Currency, used for accounting purpose.
• Date − Various date formats are available under this like 17-09-2013, 17th-Sep-2013, etc.
• Time − Various Time formats are available under this, like 1.30PM, 13.30, etc.
• Percentage − This displays cell as percentage with decimal places like 50.00%.
• Fraction − This displays cell as fraction like 1/4, 1/2 etc.
• Scientific − This displays cell as exponential like 5.6E+01.
• Text − This displays cell as normal text.
• Special − Special formats of cell like Zip code, Phone Number.
• Custom − You can use custom format by using this.

Setting Fonts in Excel

You can assign any of the fonts that is installed for your printer to cells in a worksheet.

Setting Font from Home

You can set the font of the selected text from Home » Font group » select the font.

Setting Font from Format Cell Dialogue

• Right click on cell » Format cells » Font Tab
• Press Control + 1 or Shift + Control + F

Text Decoration in Excel

You can change the text decoration of the cell to change its look and feel.

Text Decoration

Various options are available in Home tab of the ribbon as mentioned below.
• Bold − It makes the text in bold by choosing Home » Font Group » Click B or Press Control + B.
• Italic − It makes the text italic by choosing Home » Font Group » Click I or Press Control + I.
• Underline − It makes the text to be underlined by choosing Home » Font Group » Click U or Press Control + U.
• Double Underline − It makes the text highlighted as double underlined by choose Home » Font Group » Click arrow near U » Select Double Underline.

More Text Decoration Options

There are more options available for text decoration in Formatting cells » Font Tab »Effects cells as mentioned below.
• Strike-through − It strikes the text in the center vertically.
• Super Script − It makes the content to appear as a super script.
• Sub Script − It makes content to appear as a sub script.

So, this brings us to the end of blog. This Tecklearn ‘How to Undo Changes , Setting Cell and Fonts , Text Decoration 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

802