TeachUcomp, Inc.

 MY CART
  • VIDEO COURSES
    • All-Access Subscriptions
    • Business Licensing
    • Course List
      • Accounting
      • Adobe
        • Acrobat
        • Lightroom Classic
        • Photoshop
        • Photoshop Elements
      • Crystal Reports
      • Employment Skills
        • Interview Skills
        • Resume Skills
      • For Lawyers
        • Excel for Lawyers
        • Outlook for Lawyers
        • QuickBooks for Lawyers
        • Word for Lawyers
      • HTML
      • JavaScript
      • Microsoft Office
        • Access
        • Excel
        • Microsoft Office Suite
        • OneNote
        • Outlook
        • Outlook on the Web
        • PowerPoint
        • Publisher
        • Word
      • Microsoft Project
      • Microsoft Teams
      • QuickBooks Online
      • QuickBooks Pro
      • Sage
        • Peachtree
        • Sage 50
      • SQL
      • Windows
    • Video Course Options
  • SUBSCRIPTIONS
  • MANUALS
    • Adobe
      • Acrobat
      • Lightroom Classic
      • Photoshop
      • Photoshop Elements
    • Crystal Reports
    • For Lawyers
      • Excel for Lawyers
      • Outlook for Lawyers
      • QuickBooks for Lawyers
      • Word for Lawyers
    • HTML
    • JavaScript
    • Microsoft Office
      • Access
      • Excel
      • OneNote
      • Outlook
      • Outlook on the Web
      • PowerPoint
      • Publisher
      • Word
    • Microsoft Project
    • Microsoft Teams
    • QuickBooks Online
    • QuickBooks Pro
    • Sage
      • Peachtree
      • Sage 50
    • SQL
    • Windows
  • REFERENCE CARDS
    • Adobe
      • Acrobat
      • Lightroom Classic
      • Photoshop
      • Photoshop Elements 2025
      • Photoshop Elements 2024
      • Photoshop Elements 2023
      • Photoshop Elements 2022
      • Photoshop Elements 2021
      • Photoshop Elements 2020
      • Photoshop Elements 2019
      • Photoshop Elements 2018
      • Photoshop Elements 15
    • Google
      • Google Classroom for Teachers
      • Google Docs
      • Google Drive
      • Google Forms
      • Google Sheets
      • Google Slides
    • Mac OS
      • Mac OS Keyboard Shortcuts
    • Microsoft Office
      • Excel Formulas and Functions
      • Excel Keyboard Shortcuts
      • Excel Tables PivotTables and Charts
      • Microsoft 365
        • Access for Microsoft 365
        • Excel for Microsoft 365
        • Microsoft Office 365
        • Outlook for Microsoft 365 Classic Edition
        • PowerPoint for Microsoft 365
        • Publisher for Microsoft 365
        • Word for Microsoft 365
      • Microsoft Office 2021
        • Access 2021
        • Excel 2021
        • Microsoft Office 2021
        • Outlook 2021
        • PowerPoint 2021
        • Publisher 2021
        • Word 2021
      • Microsoft Office 2019
        • Access 2019
        • Excel 2019
        • Microsoft Office 2019
        • Outlook 2019
        • PowerPoint 2019
        • Publisher 2019
        • Word 2019
      • Microsoft Office 2016
        • Access 2016
        • Excel 2016
        • Microsoft Office 2016
        • OneNote 2016
        • Outlook 2016
        • PowerPoint 2016
        • Publisher 2016
        • Word 2016
      • Microsoft Office 2013
        • Excel 2013
        • Microsoft Office 2013
        • OneNote 2013
        • Outlook 2013
        • PowerPoint 2013
        • Word 2013
      • Microsoft Office for iPad
        • Microsoft Office for iPad
      • Word Keyboard Shortcuts
    • Microsoft Teams
      • Microsoft Teams
    • QuickBooks Online
      • QuickBooks Online
    • QuickBooks Pro
      • QuickBooks Pro 2024
      • QuickBooks Pro 2023
      • QuickBooks Pro 2022
      • QuickBooks Pro 2021
      • QuickBooks Pro 2020
      • QuickBooks Pro 2019
      • QuickBooks Pro 2018
      • QuickBooks Pro 2017
      • QuickBooks Pro 2016
      • QuickBooks Pro 2015
      • QuickBooks Pro 2014
    • Sage
      • Sage 50 Accounting
    • SQL
      • SQL
    • Windows
      • Windows 11
      • Windows 11 and 10 Keyboard Shortcuts
      • Windows 10
  • STICKERS
    • Chrome OS
      • Chrome OS for Chromebooks
    • Mac OS
      • Mac OS
    • Microsoft Office
      • Word and Excel (Mac) 2022
      • Word and Excel (PC/Windows) 2021-2016 and 365
    • QuickBooks Desktop
      • QuickBooks Desktop (PC/Windows) 2024
      • QuickBooks Desktop (PC/Windows) 2023
      • QuickBooks Desktop (PC/Windows) 2022-2015
    • Windows
      • Windows 11 and 10
  • SUPPORT
    • Company
      • About Us
      • Blog
      • Contact Us
      • Our History
      • Our Philosophy
        • Customer Service
        • Mission
      • Policies
      • Testimonials
    • Contact Us
    • FAQ
    • Help
    • Lost Password
    • Register a Product
  • LOGIN
    • Manage My Account
    • Member Login
    • My Courses
Shop Now

Cell Formatting in Microsoft Excel 2010

by Keeley Byrnes / Tuesday, January 07 2014 / Published in Excel 2010, Latest

Cell Formatting in Microsoft Excel 2010: Video

This video shows you how to apply cell formatting in Microsoft Excel 2010.

Formatting Cells in Excel 2010: Overview

Note that in the “Home” tab of the Ribbon, you have the “Font” group, the “Alignment” group, and the “Number” group. These groups contain buttons that allow you to format the appearance of selected cells. To do this, just start by selecting the cells you want to format. Then click the desired button.

Note that some of the buttons have a small drop-down arrow next to them. If you click one of these small drop-down arrows, a menu will appear and allow you to specify more button settings. For instance, if you click the drop-down arrow to the right of the “Fill Color” button, it will display the palette of colors in a drop-down menu that you can use to set a new fill color. Once you change the color, the color strip underneath the paint can will change to reflect the new selection. In the future, all you need to do is click the “Fill Color” button to apply your previous color choice.

Let’s examine the buttons that you will find in each group on the “Home” tab. As with the other groups in the Ribbon, not every possible aspect of formatting is shown in the button groupings. For more advanced formatting of cells, you can click the small dialog box buttons in the lower right corner of either the “Font,” “Alignment” or “Number” button groups to open the “Format Cells” dialog box, where you have all formatting options available. Note that you can also open this dialog box by clicking the “Format” button in the “Cells” group on the “Home” tab in the Ribbon, and then selecting the “Format Cells…” command from the drop-down menu that appears.

In the “Format Cells” dialog box, each button group is displayed as a separate tab. You can click the tabs to switch between the formatting options that are available. We will discuss the options available on each tab in a separate lesson. For now, just note how to open the dialog box. You can close the “Format Cells” dialog box by clicking the “x” in the upper right corner of the dialog box.

Back in the “Home” tab of the Ribbon, you have several common formatting options available. In the “Font” group, you have the “Font,” “Font Size,” “Increase Font Size,” “Decrease Font Size,” “Bold,” “Italic,” “Underline,” “Borders,” “Fill Color,” and “Font Color” buttons available.

In the “Alignment” group, you have the “Top Align,” “Middle Align,” “Bottom Align,” “Orientation,” “Wrap Text,” “Align Text Left,” “Center,” “Align Text Right,” “Decrease Indent,” “Increase Indent,” and “Merge and Center” buttons.

Finally, in the “Number” group, you have the “Number Format,” “Accounting Number Format,” “Percent Style,” “Comma Style,” “Increase Decimal,” and “Decrease Decimal” buttons available.

Tagged under: 2010, 2013, cells, excel, format, format cell, format table, formatting cells, help, how-to, learn, microsoft, office, software, training, tutorial

About Keeley Byrnes

Keeley is our Director of Marketing and has been with TeachUcomp since 2010. Keeley manages all aspects of our Marketing Department, acts as liaison for our reseller and affiliate partners and also authors courses in software and taxation.
Save $150! One Year Online Entire Library $49. Click here for more info.

 

Categories

  • GET SOCIAL

© 2001-2025 Copyright TeachUcomp, Inc. All rights reserved.

TOP
SALE! $49 All-Access 0 Days 14 Hours 14 Minutes 39 Seconds      $199 $49 Entire Library!
See Deal