Excel's Formatting options is a way to make your
easier to read and to understand the important data. This Series of Tutorials and Articles
takes you through the basics of using Excel's formatting features to improve the look and effectiveness of your spreadsheets.
Number formatting involves adding percent symbols ( % ), commas ( , ), decimal places, and dollar signs( $ ) to a spreadsheet. This article gives you an overview of where to find Excel's number formatting options and how to use them.
Part One of this two part tutorial covers a number of formatting tools available in Excel:
- number formatting
- changing cell colors
- adding text formatting
Part Two of this tutorial covers:
- changing the alignment of text in cells
- adding a
- using the NOW
function to add the current date to the spreadsheet.
In Excel spreadsheets, headers and footers are lines of text that print at the top (header) and bottom (footer) of each page in the spreadsheet. They contain descriptive text such as titles, dates, and/or page numbers and are used to add information to a printed spreadsheet.
To quickly copy formatting from one cell or group of cells to another part of the spreadsheet use the format painter in Excel. This feature is very useful when extending a spreadsheet and you need to format the newly added cells to match the original ones.
In Microsoft Excel 2003 it is possible to color code the tabs of worksheets. Changing the tab color of worksheets containing related information can make it easier to navigate through very large spreadsheets.
To quickly apply a number of Excel's Formatting features to a spreadsheet you can use one of the 17 AutoFormat styles available. These styles combine a number of formatting options that will instantly give your spreadsheets a professional look.