Formatting Data and Formatting Cells in Excel

Home/Excel/Formatting Data and Formatting Cells in Excel

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


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.


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


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 FormatPress this key
Bold the selectionCtrl+b
Italicize the selectionCtrl+I
Underline the selectionCtrl+u
Strike through the selectionCtrl+5
Open the style dialog boxalt+’
Open the format cells dialog boxCtrl+1
Apply the general formatCtrl+Shift+~
Apply the currency formatCtrl+Shift+$
Apply the percentage formatCtrl+Shift+%
Apply the date formatCtrl+Shift+#
Apply the time formatCtrl+Shift+@
Apply the number formatCtrl+Shift+!
Apply the exponential number formatCtrl+Shift+^
Apply an outline border to the selectionCtrl+Shift+&
Remove an outline border from the selectionCtrl+Shift +_
By |May 18th, 2013|Excel|1 Comment

About the Author:

Excel VBA Developer having around 8 years of experience in using Excel and VBA for automating the daily tasks, reports generation and dashboards preparation. Valli is sharing to helps us automating daily tasks.

One Comment

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

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

Leave A Comment