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.

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.

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.

Useful Shortcut Keys for Formatting Data

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