You are here:About>Computing & Technology>Spreadsheets> Excel Formatting
About.comSpreadsheets

How to Use Excel Formatting Features - Format Excel Spreadsheets

There are a variety of formatting options available in Excel - conditional formatting, number formatting, text and general spreadsheet formatting techniques. With so many choices it is easy to get lost or miss some options altogether. Here you will find free step by step tutorials, how to's, general information, tips and shortcuts to help you format your spreadsheets effectively.
Formatting Options for Excel Spreadsheets
Formatting your Excel spreadsheets makes them easier to read and understand the important information. This series of Excel articles and tutorials, takes you through the process of formatting your Excel spreadsheets.
Basic Formatting in Excel - Tutorial Part 1
Excel offers a variety of formatting options including number, text, and worksheet formatting. This is the first part of a step by step tutorial, using these types of formatting effectively to enhance your spreadsheets.
Basic Formatting in Excel - Tutorial Part 2
Excel offers a variety of formatting options including number, text, and worksheet formatting. This second part of a step by step tutorial, covers using these types of formatting effectively to enhance your spreadsheets.
Add and Delete Columns and Rows in Excel
This series of articles cover the basics of how to add and delete columns and rows in Excel worksheets. It is often necessary to alter the layout of a worksheet due to the addtion or removal of data.
Hide and Unhide Columns and Rows in Excel
This series of articles cover how to hide and unhide columns and rows in Excel worksheets.
Excel Conditional Formatting
Adding conditional formatting to a cell in Excel allows you to apply different formatting options, such as color, to a cell or cells based on the data entered into the cell(s).
Using Excel Headers and Footers
Headers and footers are used to add the same information on every page of the spreadsheet without actually typing the information on each page. Headers and footers often contain company information as well as the date, time and filename of the spreadsheet.
How to Use Microsoft Excel's Format Painter
To quickly copy formatting from one cell or group of cells to another part of the spreadsheet use the format painter in Excel. The format painter icon is on the formatting toolbar. It is very useful when extending a spreadsheet to accommodate new data and you need to format the new cells to match the original data area.
Hide Columns in Excel
This article shows you how, with a click of the mouse, you can easily hide columns in Excel spreadsheets.
Hide Rows in Excel
This article shows you how, with a click of the mouse, you can easily hide rows in Excel spreadsheets.
Unhide Columns in Excel
This article shows you how, with a click of the mouse, you can easily unhide columns in Excel spreadsheets.
Unhide Rows in Excel
This article shows you how, with a click of the mouse, you can easily unhide rows in Excel spreadsheets.
Change Column Widths in Excel
There are a number of ways to change column widths in Excel spreadsheets. This step by step tutorial shows you three ways of accomplishing the task in Excel.
How to Change the Sheet Tab Color of Excel Spreadsheets
In Microsoft Excel 2003 it is possible to color code the tabs of worksheets. Changing the color of worksheets tabs containing related information can make it easier to navigate through very . Or to use tab colors to differentiate between sheets containing unrelated information.
How to Use Excel's AutoFormat Option
Formatting a spreadsheet effectively can make the most important information on the spreadsheet stand out from the rest of the data. To accomplish this you can use one of the 17 AutoFormat styles available in Excel to give your spreadsheets a professional look that makes them easy to read.
Adding/Formatting Borders in Excel 2007
This article shows you how to add and format borders to a spreadsheet. Both the preset and draw borders options are covered. A step by step example of formatting borders is included.
 All Topics | Email Article | | |
Advertising Info | News & Events | Work at About | SiteMap | Reprints | HelpOur Story | Be a Guide
User Agreement | Ethics Policy | Patent Info. | Privacy Policy©2008 About, Inc., A part of The New York Times Company. All rights reserved.