SITEMAP UPDATES ABOUT
MiC Quality

FREE COURSE Excel Primer

  PROCESS IMPROVEMENT AND SIX SIGMA
ONLINE COURSES FREE TRIAL SIX SIGMA FAQ BROCHURES LICENSES ENROLL
FREE TRIAL
:: Online Courses
:: Free Trial
>> Statistics Module
>> Excel Primer
:: Six Sigma
:: FAQ
:: Brochures
:: Licenses
:: Discounts
 
Welcome to MiC Quality
Online Course Instructor
Glen Netherwood
MiC Quality
Online Learning
:: Home :: FREE TRIAL :: CURRENT STUDENTS LOGIN
:: Formatting Cells Syllabus    PreviousNext

You can change the cell font size and alignment using the toolbar:

   

If you want to format the way numbers are displayed you can find an extensive range of options by using the 'Format-Cells' option from the main menu:

 



Note that even if you restrict the number of decimal places displayed the original accuracy is still used in calculations.

In the example the value in cell B2 is actually 3.145 but is formatted as a number to 2 decimal places.

You can explore the various options. I've used 'Currency', selected two decimal places and the '$' symbol to format the spreadsheet from the previous example:



Load the spreadsheet and make sure you can format it as I have done. Try to improve it. For example you can try the accounting format. You can also improve the appearance by:

  • changing the width of the columns
  • adding or deleting rows
  • adding a border around the table
  • changing the background color for the table
  • giving the table a centered title

 
Copyright 1998-2008 MiC Quality Legal Notices and Privacy Policy