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.



50+ Project Management Templates Pack
Excel PowerPoint Word

Advanced Project Plan & Portfolio Template
Excel Template

Business Presentations Templates Pack
PowerPoint Slides

20+ Excel Project Management Pack
Excel Templates

20+ PowerPoint Project Management Pack
PowerPoint Templates

10+ MS Word Project Management Pack
Word Templates

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.


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.

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 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 +_
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

Related pages

access vba delete tablelearn macro excelvba excel replaceactivesheet unprotect password vbavba excel tricksexcel vba case statementexcel delete duplicates in columnhow to merge and center cells in excel 2010tableau tutorial for beginners pdfexcel duplicate rowspivot table in excel 2010 tutorialdml & ddlclear duplicates in excelaccess vba multidimensional arrayvba connection string to sql serverexcel formulas countiftrim command exceltask assignment template excelexcel filter based on cell valuevba for powerpointexcel vba sample projectsvba typeofhow to insert macro in excel 2007excel macro repeataccess vba in excelhow to write a query in excelcreate a stacked bar chart in excel 2010vba new workbookexample of countifhow to record a macro in excel 2007excel macro fileexcel 2013 pivot tabledata definition language ddl commandcount columns in excelexcel vba column countexcel vba specify rangeexcel vba call formvba code to transfer data from one sheet to anothervba excel graphpractice vlookupexcel vba matchsave a workbook vbacreate userform in excel 2007how to insert title in excelhow to hide tabs in excelvba prompthow to write macros in excel 2007hide sheet excelactivate developer tab in excel 2010excel copy cell to another sheetexcel vba delete duplicate rowsexcel copy row to another sheetpassword protect multiple excel filesexcel tutorial pivot tablesvba excel for beginnerssql and sastcl commands in sql with examplesoutlook attachment vbamacro in excel with examplevba open file for inputexcel vba macro programminghow to find duplicate value in exceladd developer tab to the ribbon in wordado excelexcel rgb colorhow to remove excel sheet passwordexcel vba shortcut keyformula for vlookup in excel 2007vbscript in excelwhat is a hyperlink in excelmicrosoft word add developer tab to ribbonpivots exceloption button in excelexcel userform tutorialsql server adodb connection stringinterior.colorindexvba dim integerhow to copy data validation to other cellscells.find vbarows count vbaexcel test for finance interviewms access vba import excel