Saturday, March 29, 2014

Formatting Data and Formatting Cells in Excel

Leave a Comment


Microsoft Excel provides us the tools to make rich formats, we can format the numbers, fonts, font color, background color, alignments and many more things we can do in Excel. This tutorial section 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.
To Format
Short-cut Key
Bold
Ctrl+b
Italic
Ctrl+I
Underline
Ctrl+u
Strike through
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 +_


0 comments :

Post a Comment