Excel Format Options and Features Tutorials
Excel Basic Step by Step Format Tutorial
This step by step tutorial is a continuation of the Basic Excel Tutorial and covers how to apply formatting techniques such as merge and center titles and headings, changing column widths, shading alternate rows with conditional formatting, and applying number formats to worksheet data.
Creating Custom Conditional Formatting Rules in Excel
In addition to Excel's pre-set conditional formatting options, you can create custom rules using Excel formulas to test for user-specified conditions. This tutorial creates two custom rules to test for specific conditions in the data.
Excel IF Function Format Tutorial Part 1
This tutorial is a continuation of the step by step IF function tutorial and applies formatting techniques - such as adding rows, widening columns, and applying number formatting to the worksheet data.
If Function Format Tutorial Part 2
This tutorial is a continuation of the IF function formatting tutorial listed above. This portion of the tutorial includes such topics as changing the alignment of data, shading alternate rows with conditional formatting, and using merge and center for worksheet titles and headings.
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 to change column widths in Excel.
If you are unfamiliar with Excel's formatting features or your just don't have the time, Excel's Autoformat option gives you 17 styles to use to give your spreadsheets a professional look. Instructions on how to apply an autoformat style are included.
Insert a Watermark in Excel
This tutorial covers how create and display a visible watermark in Excel. The tutorial includes a step by step example of how to insert an image file into a header or footer to approximate a visible watermark.
Excel Wrap Text Tutorial
Use Excel 's wrap text feature to type text on multiple lines in a single worksheet cell.
Add Extra Cells to a Worksheet
This tutorial shows you how to add extra cells to an Excel worksheet wherever they are needed and without moving entire rows or columns of data. A step by step example of how to add single or multiple cells to an Excel worksheet is included.
Insert 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.
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.
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.
Adding/Formatting Borders in Excel
This tutorial 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.
Excel Negative Number Format
This tutorial covers how to format negative numbers in Excel to display in red rather than show the negative sign.
Customize the Quick Access Toolbar in Excel
The Quick Access Toolbar is used to store shortcuts to frequently used features in Excel. This tutorial shows you how to add the autoformat button to the Quick Access Toolbar.
Data for the Excel IF Function Format Tutorial
Data for the Excel Format Tutorial
Insert Columns to Excel Worksheets
This tutorial shows you how, with a click of the mouse, you can easily insert additional columns to Excel worksheets.
Add a Custom Footer in Excel
In Excel a footer can be used to add descriptive information to every page in the spreadsheet. A custom footer can be used to include such things as company information, a spreadsheet title, or spreadsheet author.
Add a Custom Header in Excel
A header is similar to a footer in the tutorial above, except that a header is found at the top of every page.
Format Numbers as Text in Excel
Formatting long numbers as text keeps the data from being changed by Excel's number and general formats. Step by step instructions on formatting cells as text are included.