One of the beauty of the Excel is rich formats, we can format the numbers, fonts, font color, background color, alignments and many more things we can do in Excel. This tutorial will help you to learn Formatting Data and Formatting Cells in Excel.

We have many tools in Excel to work with Formatting

Home Tab

If you observe the Home Tab, you can see many commands to work with formats.

Excel Basics Screen7

Font

We can use these commands to format the Fonts Styles like Bold, Underline, Italic, Font size, Background Color, Font Color etc. You can click on the icon at bottom-right corner to see the more Font Settings.

Alignment

We can align the data in a Cell using these Commands to align Left,right, Center, etc. Also we have another two frequently used Commands like Wrap Text and Merge Commands

Number

We can format the numbers to currency, percentages, decimals and other formats. We will see in more detailed manner in another topic only on number formats.

Excel Basics Screen8

Right Click: Format Cells Dialog/ Quick Options

You can also right click on the Cell and Select ‘Format Cells…” Command from the properties list to view the Format Cells Dialog.

Excel Basics Screen9

Useful Shortcut Keys for Formatting Data

You can use the following Shortcut Keys to Quickly Format the Data.

To Format Press this key
Bold the selection Ctrl+b
Italicize the selection Ctrl+I
Underline the selection Ctrl+u
Strike through the selection Ctrl+5
Open the style dialog box alt+’
Open the format cells dialog box Ctrl+1
Apply the general format Ctrl+Shift+~
Apply the currency format Ctrl+Shift+$
Apply the percentage format Ctrl+Shift+%
Apply the date format Ctrl+Shift+#
Apply the time format Ctrl+Shift+@
Apply the number format Ctrl+Shift+!
Apply the exponential number format Ctrl+Shift+^
Apply an outline border to the selection Ctrl+Shift+&
Remove an outline border from the selection Ctrl+Shift +_
120+ Professional Project Management Templates!
Save Up to 85% LIMITED TIME OFFER

A Powerful & Multi-purpose Templates for project management. Now seamlessly manage your projects, tasks, meetings, presentations, teams, customers, stakeholders and time. This page describes all the amazing new features and options that come with our premium templates.

Browse All Templates
Excel VBA Project Management Templates

All-in-One Pack
120+ Project Management
Premium Templates
View Details

Essential Pack
50+ Project Management
Premium Templates
View Details
50+ Excel
Project Management
Templates Pack
View Details
50+ PowerPoint
Project Management
Templates Pack
View Details
25+ MS Word
Project Management
Templates Pack
View Details
Ultimate Project Management Template
View Details
Ultimate Resource Management Template
View Details
Project Portfolio Management Templates
View Details
By Last Updated: June 17, 2022Categories: ExcelTags:

Share This Story, Choose Your Platform!

One Comment

  1. Amiq Khan November 2, 2013 at 1:07 PM

    Very nice site, a lot of useful ad free information. Thanks!

Leave A Comment