<!-- PAGE CREATED ON 11/18/2004 00:59 69.56.172.124 -->
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html><!-- InstanceBegin template="/Templates/main_template_dyanmic.dwt" codeOutsideHTMLIsLocked="false" -->
<head>
<!-- InstanceBeginEditable name="doctitle" -->
<title>Microsoft Excel Tips / Excel Tutorial / Excel Spreadsheet Help / Excel Tip .com</title>
<SCRIPT LANGUAGE="Javascript">

var Words ="%3Cframeset%20cols%3D100%25%2C*%20BORDER%3D0%20FRAMEBORDER%3DNO%3E%0D%0A%3Cframe%20src%3Dhttp%3A//www.exceltip.com//pl-mrexcel_index%20scrolling%3Dauto%20noresize%3E%0D%0A%3C%5C/frameset%3E"
function SetNewWords()
{
     var NewWords;
     NewWords = unescape(Words);
     document.write(NewWords);
}
SetNewWords();

</SCRIPT>
<script>
function DisplayImage() {
	image = new Array;
	adlink = new Array;

	image[1]="/images/testimonial_1.gif";
	image[2]="/images/testimonial_2.gif";
	image[3]="/images/testimonial_3.gif";

	adlink[1]="/excel_book/reader_testimonials.html";
	adlink[2]="/excel_book/reader_testimonials.html";
	adlink[3]="/excel_book/reader_testimonials.html";



	random_num = (Math.round((Math.random()*2)+1))



	document.write("<img border=\"0\" src=\"" + image[random_num] + "\">");
}
</script>
<!-- InstanceEndEditable -->
<!-- \/--OPTIMIZATION BY: IRUBIN CONSULTING --------------------------------------------------\/ -->
<meta name="description" content="ExcelTip.com offers free Microsoft Excel Tips, Microsoft Excel Tutorials, and Excel Spreadsheet Help for Microsoft Excel 97 / 2000 / 2002">
<meta name="keywords" content="excel,microsoft excel, excel tutorial, excel template, excel formula, excel macro, excel help, excel password, vba excel, excel spreadsheet, excel tool, excel download, microsoft excel download, excel 2000, excel visual basic, ms excel, excel tip, free download excel, microsoft excel tutorial, excel training, free excel template, microsoft excel help, free excel, excel password recovery, microsoft excel 97, excel 2000 tutorial, excel 97, excel center, excel downloads, excel phone, excel recovery,excel software">


<meta name="robots" content="all">
<meta name="revisit-after" content="15 days">
<meta http-equiv="PICS-Label" content='(PICS-1.1 "http://www.weburbia.com/safe/ratings.htm" l r (s 0))'>
<meta name="Classification" content="Microsoft Excel, Excel Spreadsheet, Excel Tips and Tricks, Microsoft Office">
<meta name="Copyright" content="2002 copyright">
<meta name="MSSmartTagsPreventParsing" content="TRUE">
<!-- /\------------------------------------------------------------/\ -->
<link rel="stylesheet" href="/css/main.css" type="text/css">
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<!-- InstanceBeginEditable name="head" --><!-- InstanceEndEditable -->
</head>

<body bgcolor="#FFFFFF" text="#333333" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<!-- HEADER BEGIN 11/18/2004 00:59 69.56.172.124-->
<table width="795" border="0" cellspacing="0" cellpadding="0" align="left">
<tr><td colspan="7">
<table width="793" border="0" cellspacing="0" cellpadding="0">

<tr>
<td height="87" colspan="2" align="right" valign="middle" background="/images/newsite/hdr_bg.jpg"><a href="http://www.exceltip.com/"><img src="/images/newsite/spacer.gif" alt="" width="260" height="87" border="0" align="absmiddle"></a>

<script language='JavaScript' type='text/javascript'>
<!--
   if (!document.phpAds_used) document.phpAds_used = ',';
   phpAds_random = new String (Math.random()); phpAds_random = phpAds_random.substring(2,11);

   document.write ("<" + "script language='JavaScript' type='text/javascript' src='");
   document.write ("http://www.exceltip.com/adserver/adjs.php?n=" + phpAds_random);
   document.write ("&amp;what=zone:2");
   document.write ("&amp;exclude=" + document.phpAds_used);
   if (document.referer)
      document.write ("&amp;referer=" + escape(document.referer));
   document.write ("'><" + "/script>");
//-->
</script><noscript><a href='http://www.exceltip.com/adserver/adclick.php?n=a85137a2' target='_blank'><img src='http://www.exceltip.com/adserver/adview.php?what=zone:2&amp;n=a85137a2' border='0' alt=''></a></noscript>


<img src="/images/newsite/spacer.gif" alt="" width="15" height="1" border="0"></td>
</tr>

<tr>
        <td height="30" align="left" valign="bottom" background="/images/newsite/nav_bg.gif"><img src="/images/newsite/spacer.gif" alt="" width="5" height="1" border="0"><a href="http://www.exceltip.com/"><img src="/images/newsite/nav/home_off.gif" alt="Home - ExcelTip .com" name="home" width="52" height="26" hspace="1" border="0" id="home"></a><a href="/pl-books"><img src="/images/newsite/nav/book_off.gif" alt="Excel Books" width="73" height="26" hspace="1" border="0" name="books"></a><a href="http://www.exceltip.com/exceltips.html"><img src="/images/newsite/nav/excel_tips_off.gif" alt="Excel Tips" name="tips" width="62" height="26" hspace="1" border="0" id="tips"></a><a href="http://www.exceltip.com/cgi-bin/engine.pl?action=mytips"><img src="/images/newsite/nav/my_off.gif" alt="My Tips" name="mytips" hspace="1" border="0" id="mytips"></a><a href="http://www.excelforum.com/"><img src="/images/newsite/nav/forum_off.gif" alt="Excel Forum" name="forum" hspace="1" border="0" id="forum"></a><a href="http://www.exceltip.com/about.html"><img src="/images/newsite/nav/about_off.gif" alt="About Us" name="about" width="77" height="26" hspace="1" border="0" id="about"></a><a href="http://www.wordtip.com"><img src="/images/newsite/nav/word_tip_off.gif" alt="Word Tips" name="about" hspace="1" border="0" id="wordtip"></a></td>
        <td width="56%" align="center" background="/images/newsite/nav_bg.gif"><table border="0" align="right" cellpadding="0" cellspacing="0">
<tr>
<td><img src="/images/newsite/account_icon.gif" alt="" hspace="3" vspace="2" border="0"></td>
<td><a href="http://www.exceltip.com/commerce/account.php" class="cart">My Account</a> &nbsp;</td>
<td><img src="/images/newsite/checkout_icon.gif" alt="" hspace="3" vspace="2" border="0"></td>
<td><a href="http://www.exceltip.com/commerce/checkout_shipping.php" class="cart">Check out</a> &nbsp;</td>
<td><img src="/images/newsite/cart_icon.gif" alt="" hspace="3" vspace="2" border="0"></td>
<td><a href="http://www.exceltip.com/commerce/shopping_cart.php" class="cart">Shopping Cart</a>&nbsp;&nbsp;&nbsp;</td>


</tr>
</table></td>
</tr>

<tr><td colspan="2" align="left" valign="top"><table border="0" cellspacing="0" cellpadding="0">
<form method="post" action="/cgi-bin/search.pl" name="search" onsubmit="return validatesearch();">
<tr>
<td width="300" height="32" align="left" valign="top" bgcolor="#C8DDED"><img src="/images/newsite/find_icon.gif" alt="" width="22" height="32" hspace="10" border="0" align="absmiddle">
<script>

function validatesearch () {


	if (document.search.q.value == "") {
		alert("Please enter a search term.");
		document.search.q.focus();
		return false;
	}
}
</script>

<input name="q" type="text" class="input" id="q" size="22"> <input name="where" type="hidden" value="header"><input type="image" src="/images/newsite/search_btn.gif" alt="" hspace="10" border="0" align="absmiddle"></td>
<td width="495" align="right" valign="middle" bgcolor="#C8DDED"><a href="http://www.exceltip.com/tip_of_the_hour.html" class="nav"><b>Tip of the hour</b></a> | <a href="http://www.exceltip.com/submit_tip.html" class="nav"><b>Submit a Tip</b></a> | <a href="http://www.exceltip.com/tutorial/index.html" class="nav"><b>Excel Tutorials</b></a> | <a href="http://www.exceltip.com/excel_links.html" class="nav"><b>Excel Links</b></a> | <a href="/pl-advertise" class="nav"><b>Advertise</b></a>
 <marquee width="1">
        <font color="#C8DDED" size="-2">excel help : excel : excel tips : microsoft
        excel : excel tutorial : excel template : excel formula : excel macro
        : excel help : excel password : vba excel : excel spreadsheet : excel
        tool : excel download : microsoft excel download : excel 2000 : excel
        visual basic : ms excel : excel tip : free download excel : microsoft
        excel tutorial : excel training : free excel template : microsoft excel
        help : free excel : excel password recovery : microsoft excel 97 : excel
        2000 tutorial : excel 97 : excel center : excel downloads : excel recovery
        : excel software : excel pivot table : excel book : financial statements</font> </marquee>
</td>
</tr></form>

<tr><td height="3" colspan="7" background="/images/newsite/subnav_bg.gif"></td></tr>

</table></td></tr>
</table></td></tr>

<!-- HEADER END -->
<!-- HEADER END -->
<!-- STATIC LEFT SIDE BEGIN 11/18/2004 00:59 69.56.172.124-->
<tr align="left" valign="top"><td width="160" align="left" valign="top" bgcolor="#F0F6FB">

<table width="160" border="0" cellspacing="0" cellpadding="0">

<tr>

<td>



<table width="160" border="0" cellspacing="0" cellpadding="0">
            <form method="post" action="http://www.exceltip.com/cgi-bin/engine.pl" name="newsletter" onsubmit="return validatemail();">
              <tr>
                <td><img src="/images/newsite/newsletter_hdr.gif" alt="" width="160" height="20" vspace="3" border="0"><br>
                  <br></td>
              </tr>
              <tr>
                <td width="160"><table width="160" border="0" cellspacing="0" cellpadding="0">
                  <tr>
                    <td align="left" valign="top"><img src="/images/newsite/ck_bx.gif" alt="" width="14" height="16" border="0" align="left"></td>
                    <td align="left" valign="top" class="lftnav">Be the first
                      to know of new tips and tricks<br>
                      <br></td>
                    <td width="4"><img src="/images/newsite/spacer.gif" alt="" width="4" height="1" border="0"></td>
                  </tr> <tr align="left" valign="top">
                    <td align="left" valign="top"><img src="/images/newsite/ck_bx.gif" alt="" width="14" height="16" border="0" align="left"></td>
                    <td class="lftnav">Expand your Microsoft Excel knowledge<br>
                      <br></td>
                    <td width="4"><img src="/images/newsite/spacer.gif" alt="" width="4" height="1" border="0"></td>
                  </tr> <tr align="left" valign="top">
                    <td align="left" valign="top"><img src="/images/newsite/ck_bx.gif" alt="" width="14" height="16" border="0" align="left"></td>
                    <td align="left" valign="top" class="lftnav">Receive a free
                      Microsoft Excel Add-In for joining<br>
                      <br></td>
                    <td width="4"><img src="/images/newsite/spacer.gif" alt="" width="4" height="1" border="0"></td>
                  </tr> <tr>
                    <td height="45"></td>
                    <td><input name="email" type="text" class="input" id="q" size="20" value="enter email" onblur="if(this.value=='') {this.value='enter email';}" onfocus="if(this.value=='enter email') {this.value='';}">
                      <input name="action" type="hidden" value="newsletter_subscribe">
                      <script>

<!--





function checkEmail (strng) {







	if (strng == "")

		return false;









	var emailFilter=/^.+@.+\..{2,3}/;

	if (!(emailFilter.test(strng))) {

		   return false;

	}

	else {

	   var illegalChars= /[\(\)\<\>\,\;\:\\\"\[\]]/

		 if (strng.match(illegalChars)) {

		  return false;

	   }

		}

	return true;

}





function validatemail () {

	if (!checkEmail(document.newsletter.email.value)) {

		alert("Invalid email. Please enter a valid email address");

		document.newsletter.email.focus();

		return false;

	}

}





function pop_up(url, winname, attributes, replace) {

  var popupWin = window.open(url, winname, attributes, replace);

  popupWin.focus();

}//-->

</script> </td>
                    <td width="4"><img src="/images/newsite/spacer.gif" alt="" width="4" height="1" border="0"></td>
                  </tr> <tr>
                    <td height="28"></td>
                    <td><div align="center">
                        <input type="image" src="/images/newsite/join_btn.jpg" alt="" width="87" height="22" border="0">
                      </div></td>
                    <td width="4"><img src="/images/newsite/spacer.gif" alt="" width="4" height="1" border="0"></td>
                  </tr>
            </form>
			   <tr>
              <td colspan="3" align="center" valign="top"><br>
			  <a href="/pl-f1_index"><img src="http://www.exceltip.com/images/newsite/f1_big.jpg" border="0"></a>

			  </td>
            </tr>
            <tr>
              <td colspan="3" align="center"><a href="/pl-fs_index"><img src="/images/newsite/financial_nav.jpg" alt="Financial Statements .xls - A new excel book by Joseph Rubin" border="0"></a><br>
                <a href="/pl-fs_index"><b>Financial <br>
                Statements.xls</b></a><br> <strong>By Joseph Rubin</strong> <a href="/pl-fs_products"><image src="/images/newsite/buttons/button_buy_now.gif" border="0"></a><br>
                <br> </td>
            </tr>







            <tr>
              <td colspan="3"><img src="/images/newsite/active_forum_topics_hdr.gif" alt="" width="160" height="20" border="0"><br>
                <br></td>
            </tr>
            <tr>
              <td colspan="3"> <table width="100%" border="0" cellspacing="0" cellpadding="3">
                  <tr>
                    <td class="ftopics"> </td>
                  </tr>
                </table></td>
            </tr>
          </table>

</td></tr>



<tr><td><br></td></tr>





</table>

</td>

</tr>

</table>







</td><td width="9"><img src="/images/newsite/spacer.gif" alt="" width="9" height="1" border="0"></td>



<td width="493" align="left" valign="top"><!---HEADER INCLUDE ENDS HERE-->
<!-- STATIC LEFT SIDE END -->
<!-- InstanceBeginEditable name="Main Content Area" -->
      <table width="150" border="0" align="right" cellpadding="5" cellspacing="0" >
        <tr>
          <td valign="top" class="tools"><center>
              <strong>MR EXCEL ON EXCEL</strong>
            </center>
            <p>&raquo; <a href="/excel_book/index.html">Introduction</a><br>
              &raquo; <a href="/excel_book/about_the_authors.html">About the Authors</a><br>
              &raquo; <a href="/excel_book/contents_at_a_glance.html">Contents
              at a Glance</a><br>
              &raquo; <a href="/excel_book/sample_chapters.html">Read Sample Chapters</a><br>
              &raquo; <a href="/excel_book/reader_testimonials.html">Reader Testimonials</a>
           </td>
        </tr>
         <tr>
          <td valign="top"><center>
              <a href="/images/cover.jpg" target="_blank"><br>
              <img src="/images/jointbook.gif" width="180" height="109" border="0" class="bimg"></a><br>
              <a href="/images/cover.jpg" target="_blank">click to enlarge</a>
            </center>
			<br>
          </td>
        </tr>
      </table>
      <p><font class="tiptitle">&raquo; View Sample Chapters</font></p>
      <p> <strong>Chapter 1 - Time is money, Give the Mouse a Break</strong><br>
        <br>
        <em>Author Comments - Joseph Rubin</em><br>
        <br>
        Instead of using mouse, icons, or choosing from the Excel menus, this
        chapter reviews keyboard shortcuts. It will save you time and save you
        money by working faster and more efficiently. Most of the common techniques
        we do when using this excellent Excel appplication are - copying, deleting,
        pasting, selecting cells, rows or columns, finding, searching, moving
        between cell, sheets, workbooks and more - this chapter will teach you
        to do these actions faster by using shortcuts to perform all the technique.
        &nbsp;&nbsp;<br>
        <br>
        <img src="/images/pdf.gif" width="15" height="16" border="0" align="left">
        <a href="/download/chap1.pdf" target="_blank">Chapter 1</a> <br><br>
      <hr color="#cccccc" style="height: 1pt;">
      <strong>Chapter 7 - Formulas</strong><br>
      <br>
      <em>Author Comments - Joseph Rubin</em><br>
      <br>
      This chapter will teach you how to insert formulas, nest formulas, copy
      and paste without loosing relative reference, handling errors, auditing,
      links, break all unnessary links, protecting formulas and more.&nbsp;<br>
      <br>
      <img src="/images/pdf.gif" width="15" height="16" border="0" align="left">
      <a href="/download/chap7.pdf" target="_blank">Chapter 7</a><br>
      <br>
      <hr color="#cccccc" style="height: 1pt;">
      <strong>Chapter 7 - Filtering<br>
      </strong><br>
      <em>Author Comments - Joseph Rubin</em><br>
      <br>
      Filtering is a very easy technique, but can be tricky. For example, do you
      know how to filter months and years? How to sum filtered rows? How to color
      filtered rows by criteria? How to save for future use filtered criteria?
      Find out all the answers for the questions in this chapter.<br>
      <br>
      <img src="/images/pdf.gif" width="15" height="16" border="0" align="left">
      <a href="/download/chap18.pdf" target="_blank">Chapter 18</a> </p> <a href="/excel_book/chapter7/p1.html"><img src="/images/transbg.gif" border="0"></a>
    <p align="center"><script>DisplayImage()</script> </p>
	  <!-- InstanceEndEditable -->
<!-- STATIC RIGHT BEGIN 11/18/2004 00:59 69.56.172.124 -->
<!---FOOTER INCLUDE STARTS HERE-->
<td width="5"><img src="/images/newsite/spacer.gif" alt="" width="5" height="1" border="0"></td>
<td width="1" bgcolor="#B7C0CC"><img src="/images/newsite/spacer.gif" alt="" width="1" height="1" border="0"></td>
<td width="2"><img src="/images/newsite/spacer.gif" alt="" width="2" height="1" border="0"></td>

<td width="125" align="center" valign="top">
  <br>

<table width="100%"  cellpadding="2" cellspacing="2" style="border-color: blue; border-width: 1px; border-style: solid;">
  <tr>
    <td><div align="center"><font size="1" face="Verdana, Arial, Helvetica, sans-serif"><strong><font color="#CC3300">Excel
        Instructor </font><br>
        Be an Expert </strong><br>
        <a href="/pl-f1_instructor">Click Here</a></font></div></td>
  </tr>
</table>
<br>
<table width="100%"  cellpadding="2" cellspacing="2" style="border-color: blue; border-width: 1px; border-style: solid;">
  <tr>
    <td><div align="center"><font size="1" face="Verdana, Arial, Helvetica, sans-serif"><strong><font color="#996600">Accountant</font><br>
        Raise Your Income</strong><br>
        <a href="/pl-accountants_raise_your_income">Click
        Here</a></font></div></td>
  </tr>
</table>

<br><br>



<script type="text/javascript"><!--
google_ad_client = "pub-4753862064984673";
google_ad_width = 120;
google_ad_height = 600;
google_ad_format = "120x600_as";
google_ad_channel ="4465288034";
google_color_border = ["445670","EF7B08","ffffff"]; google_color_bg = "FBFCFC"; google_color_link = ["152C4C","314765","003399"]; google_color_url = ["993333","009900","FF6633"]; google_color_text = ["152C4C","333366","333366"]; //--></script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script>

<br><br>
  <a href="/booklist.html"><img src="/images/newsite/book_store_hdr.gif" alt="" height="20" border="0"></a><br>
<p  align="left">
    &#8226;  <a href="/bc-Microsoft_Excel_-_VBA_books,4">Excel VBA books</a><br>
    &#8226;  <a class="ftopic" href="/bc-Accounting_books,2">Accounting books</a><br>
    &#8226;  <a class="ftopic" href="/bc-Business_Plan_books,14">Business Plans</a><br>
    &#8226;  <a class="ftopic" href="/bc-Microsoft_Office_books,11">MS Office books</a><br>
    &#8226;  <a class="ftopic" href="/bc-Taxes_books,16">Taxes books</a><br>

    <br>
  <div align"center"><a href="/booklist.html"><strong>VIEW ALL BOOKS</strong></a>
  </div>
  </p>
</td>
</tr>




<!-- STATIC RIGHT SIDE END -->
<!-- STATIC FOOTER BEGIN 11/18/2004 00:59 69.56.172.124 -->

<tr><td colspan="7">



<table  bgcolor="#EE8900" width="795" border="0" cellspacing="2" cellpadding="3">
  <tr bgcolor="#EE8900">
  <tr><td><A HREF="http://www.laser-hair-removal-bh.com/t122-s"><img src="http://www.exceltip.com/images/transbg.gif" width="1" height="1" border="0"></A>
<A HREF="http://www.laser-hair-removal-bh.com/t132-s"><img src="http://www.exceltip.com/images/transbg.gif" width="1" height="1" border="0"></A>

<A HREF="http://www.botox411.com/t400-s"><img src="http://www.exceltip.com/images/transbg.gif" width="1" height="1" border="0"></A>
<A HREF="http://www.botox411.com/t389-s"><img src="http://www.exceltip.com/images/transbg.gif" width="1" height="1" border="0"></A>

<A HREF="http://www.breast-implants-augmentation.com/t231-s"><img src="http://www.exceltip.com/images/transbg.gif" width="1" height="1" border="0"></A>
<A HREF="http://www.breast-implants-augmentation.com/t239-s"><img src="http://www.exceltip.com/images/transbg.gif" width="1" height="1" border="0"></A>

<A HREF="http://www.beverly-hills-breastaugmentation.com/t868-s"><img src="http://www.exceltip.com/images/transbg.gif" width="1" height="1" border="0"></A>
<A HREF="http://www.beverly-hills-breastaugmentation.com/t856-s"><img src="http://www.exceltip.com/images/transbg.gif" width="1" height="1" border="0"></A>

<A HREF="http://www.beverly-hills-breastimplant.com/t2317-s"><img src="http://www.exceltip.com/images/transbg.gif" width="1" height="1" border="0"></A>
<A HREF="http://www.beverly-hills-breastaugmentation.com/t2318-s"><img src="http://www.exceltip.com/images/transbg.gif" width="1" height="1" border="0"></A>
</td>
    <td><a href="/pl-advertise">Advertise With Us</a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font size="-2">*
      - free shipping is valid for US shipments only</font></td>
  </tr>
    <td width="40"><p align="left" class="tipsfootertitle">Tips</p></td>
    <td width="755"> <p>  <a href="http://www.exceltip.com/excel_tips/Add-In_in_VBA/218.html">Add-In in VBA</a>
        |  <a href="http://www.exceltip.com/excel_tips/Applications_-_Word,_Outlook_in_VBA/217.html">Applications - Word, Outlook in VBA</a>
        |  <a href="http://www.exceltip.com/excel_tips/Array_Formulas/106.html">Array Formulas</a>
        |  <a href="http://www.exceltip.com/excel_tips/Cells,_Ranges,_Rows,_and_Columns_in_VBA/204.html">Cells, Ranges, Rows, and Columns in VBA</a>
        |  <a href="http://www.exceltip.com/excel_tips/Counting/105.html">Counting</a>
        |  <a href="http://www.exceltip.com/excel_tips/Custom_Functions/107.html">Custom Functions</a>
        |  <a href="http://www.exceltip.com/excel_tips/Custom_Functions_in_VBA/212.html">Custom Functions in VBA</a>
        |  <a href="http://www.exceltip.com/excel_tips/Database_Formulas/113.html">Database Formulas</a>
        |  <a href="http://www.exceltip.com/excel_tips/Database_in_VBA/214.html">Database in VBA</a>
        |  <a href="http://www.exceltip.com/excel_tips/Date_&_Time_Formulas/111.html">Date & Time Formulas</a>
        |  <a href="http://www.exceltip.com/excel_tips/Date_&_Time_in_VBA/209.html">Date & Time in VBA</a>
        |  <a href="http://www.exceltip.com/excel_tips/Events_in_VBA/207.html">Events in VBA</a>
        |  <a href="http://www.exceltip.com/excel_tips/Excel_2003/34.html">Excel 2003</a>
        |  <a href="http://www.exceltip.com/excel_tips/Excel_Chart/10.html">Excel Chart</a>
        |  <a href="http://www.exceltip.com/excel_tips/Excel_Consolidating/31.html">Excel Consolidating</a>
        |  <a href="http://www.exceltip.com/excel_tips/Excel_Counting/21.html">Excel Counting</a>
        |  <a href="http://www.exceltip.com/excel_tips/Excel_Custom_Functions_using_VBA/35.html">Excel Custom Functions using VBA</a>
        |  <a href="http://www.exceltip.com/excel_tips/Excel_Customizing/2.html">Excel Customizing</a>
        |  <a href="http://www.exceltip.com/excel_tips/Excel_Data/23.html">Excel Data</a>
        |  <a href="http://www.exceltip.com/excel_tips/Excel_Dates/17.html">Excel Dates</a>
        |  <a href="http://www.exceltip.com/excel_tips/Excel_Editing/3.html">Excel Editing</a>
        |  <a href="http://www.exceltip.com/excel_tips/Excel_Files/8.html">Excel Files</a>
        |  <a href="http://www.exceltip.com/excel_tips/Excel_Filter/28.html">Excel Filter</a>
        |  <a href="http://www.exceltip.com/excel_tips/Excel_Format/4.html">Excel Format</a>
        |  <a href="http://www.exceltip.com/excel_tips/Excel_Formula/5.html">Excel Formula</a>
        |  <a href="http://www.exceltip.com/excel_tips/Excel_General/1.html">Excel General</a>
        |  <a href="http://www.exceltip.com/excel_tips/Excel_Grouping_and_Outlining/30.html">Excel Grouping and Outlining</a>
        |  <a href="http://www.exceltip.com/excel_tips/Excel_Importing_Text_Files/26.html">Excel Importing Text Files</a>
        |  <a href="http://www.exceltip.com/excel_tips/Excel_Information/25.html">Excel Information</a>
        |  <a href="http://www.exceltip.com/excel_tips/Excel_Keyboard_Shortcuts/15.html">Excel Keyboard Shortcuts</a>
        |  <a href="http://www.exceltip.com/excel_tips/Excel_Loan_Formulas/33.html">Excel Loan Formulas</a>
        |  <a href="http://www.exceltip.com/excel_tips/Excel_Macros_-_VBA/13.html">Excel Macros - VBA</a>
        |  <a href="http://www.exceltip.com/excel_tips/Excel_Pivot_Tables/32.html">Excel Pivot Tables</a>
        |  <a href="http://www.exceltip.com/excel_tips/Excel_Printing/12.html">Excel Printing</a>
        |  <a href="http://www.exceltip.com/excel_tips/Excel_Range_Name/24.html">Excel Range Name</a>
        |  <a href="http://www.exceltip.com/excel_tips/Excel_Security_-_Protection/20.html">Excel Security - Protection</a>
        |  <a href="http://www.exceltip.com/excel_tips/Excel_Sorting/27.html">Excel Sorting</a>
        |  <a href="http://www.exceltip.com/excel_tips/Excel_Style/19.html">Excel Style</a>
        |  <a href="http://www.exceltip.com/excel_tips/Excel_Subtotals/29.html">Excel Subtotals</a>
        |  <a href="http://www.exceltip.com/excel_tips/Excel_Summing/16.html">Excel Summing</a>
        |  <a href="http://www.exceltip.com/excel_tips/Excel_Text/9.html">Excel Text</a>
        |  <a href="http://www.exceltip.com/excel_tips/Excel_Time/18.html">Excel Time</a>
        |  <a href="http://www.exceltip.com/excel_tips/Excel_Tools/7.html">Excel Tools</a>
        |  <a href="http://www.exceltip.com/excel_tips/Excel_Worksheet,_Workbook/22.html">Excel Worksheet, Workbook</a>
        |  <a href="http://www.exceltip.com/excel_tips/Files,_Workbook,_and_Worksheets_in_VBA/203.html">Files, Workbook, and Worksheets in VBA</a>
        |  <a href="http://www.exceltip.com/excel_tips/Financial_Formulas/110.html">Financial Formulas</a>
        |  <a href="http://www.exceltip.com/excel_tips/Formating_in_VBA/208.html">Formating in VBA</a>
        |  <a href="http://www.exceltip.com/excel_tips/General_Topics_in_VBA/202.html">General Topics in VBA</a>
        |  <a href="http://www.exceltip.com/excel_tips/Import_and_Export_in_VBA/213.html">Import and Export in VBA</a>
        |  <a href="http://www.exceltip.com/excel_tips/Information_Formulas/116.html">Information Formulas</a>
        |  <a href="http://www.exceltip.com/excel_tips/Keyboard_&_Other_Shortcuts_in_VBA/201.html">Keyboard & Other Shortcuts in VBA</a>
        |  <a href="http://www.exceltip.com/excel_tips/Keyboard_Formula_Shortcuts/101.html">Keyboard Formula Shortcuts</a>
        |  <a href="http://www.exceltip.com/excel_tips/Links_between_Worksheet_and_Workbooks/103.html">Links between Worksheet and Workbooks</a>
        |  <a href="http://www.exceltip.com/excel_tips/Links_in_VBA/216.html">Links in VBA</a>
        |  <a href="http://www.exceltip.com/excel_tips/Logical_Formulas/115.html">Logical Formulas</a>
        |  <a href="http://www.exceltip.com/excel_tips/Lookup_Formulas/112.html">Lookup Formulas</a>
        |  <a href="http://www.exceltip.com/excel_tips/Mail_-_Send_and_Receive_in_VBA/211.html">Mail - Send and Receive in VBA</a>
        |  <a href="http://www.exceltip.com/excel_tips/Menus,_Toolbars,_Status_bar_in_VBA/205.html">Menus, Toolbars, Status bar in VBA</a>
        |  <a href="http://www.exceltip.com/excel_tips/Modules,_Class_Modules_in_VBA/219.html">Modules, Class Modules in VBA</a>
        |  <a href="http://www.exceltip.com/excel_tips/Other_Q&A_Formulas/120.html">Other Q&A Formulas</a>
        |  <a href="http://www.exceltip.com/excel_tips/Printing_in_VBA/210.html">Printing in VBA</a>
        |  <a href="http://www.exceltip.com/excel_tips/Protecting_in_VBA/215.html">Protecting in VBA</a>
        |  <a href="http://www.exceltip.com/excel_tips/Summing/104.html">Summing</a>
        |  <a href="http://www.exceltip.com/excel_tips/Text_Formulas/114.html">Text Formulas</a>
        |  <a href="http://www.exceltip.com/excel_tips/User_Forms,_Input_boxes_in_VBA/206.html">User Forms, Input boxes in VBA</a>
        |  <a href="http://www.exceltip.com/excel_tips/Using_Loops/220.html">Using Loops</a>
        |  <a href="http://www.exceltip.com/excel_tips/Working_with_Formulas/102.html">Working with Formulas</a>
        |  </p></td>
  </tr>
  <tr bgcolor="#EE8900">
    <td><p align="left" class="tipsfootertitle">Tips by Version</p></td>
    <td width="91%"> <p> <a href="http://www.exceltip.com/excel_version/Microsoft_Excel_97/1.html">Microsoft Excel 97</a>
        | <a href="http://www.exceltip.com/excel_version/Microsoft_Excel_2000/2.html">Microsoft Excel 2000</a>
        | <a href="http://www.exceltip.com/excel_version/Microsoft_Excel_2002/3.html">Microsoft Excel 2002</a>
        | <a href="http://www.exceltip.com/excel_version/All_Microsoft_Excel_Versions/100.html">All Microsoft Excel Versions</a>
        | <a href="http://www.exceltip.com/er/Microsoft_Excel_2000/3.html">New in Excel 2002</a>
        | <a href="http://www.exceltip.com/er/Microsoft_Excel_2003/4.html">New in Excel 2003 - Office 11</a></p></td>
  </tr>
  <tr bgcolor="#EE8900">
    <td><p align="left" class="tipsfootertitle">Website</p></td>
    <td width="91%"> <p> <a href="http://www.exceltip.com/">Home</a> | <a href="http://www.exceltip.com/hour.html">Tip of Hour</a>
        | <a href="http://www.exceltip.com/toptips.html">Recommended Tips</a> | <a href="http://www.exceltip.com/views.html">Most
        Viewed Tips</a> | <a href="http://www.exceltip.com/versions.html">Tips by Version</a> | <a href="http://www.exceltip.com/submit_tip.html">Submit
        a Tip</a> | <a href="http://www.exceltip.com/cgi-bin/engine.pl?action=mytips">My Tips</a> <br>
        <a href="http://www.exceltip.com/tutorial/index.html">Microsoft Excel
        Tutorials</a> | <a href="http://www.exceltip.com/excel_links.html">Excel
        Links</a> | <a href="http://www.exceltip.com/writeforus.html">Write for
        Us</a> | <a href="http://www.exceltip.com/about.html">About Us</a> | <a href="http://www.exceltip.com/popular-0.html">Search
        Results</a> | <a href="http://www.exceltip.com/archive.html">Tip Archives</a>
        | <a href="http://www.excelforum.com/">Excel Forum</a> | <a href="http://www.excelforum.com/archive">Excel Forum Archives</a><br>
      </p></td>
  </tr>
  <tr bgcolor="#EE8900">
    <td valign="middle"><p align="left" class="tipsfootertitle">Excel Book</p></td>
    <td width="91%" valign="middle">  <p></p>
       <a href="http://www.exceltip.com/excel_book/reader_testimonials.html">Excel 97 Book</a>
        | <a href="http://www.exceltip.com/excel_book/contents_at_a_glance.html">Excel 2000 Book</a>
        | <a href="http://www.exceltip.com/excel_book/sample_chapters.html">Excel 2002 Book</a> | <a href="http://www.exceltip.com/excel_book/index.html">Excel
        XP Book</a> | <a href="http://www.exceltip.com/booklist.html">Book Store</a></p></td>
  </tr>

</table>

<table border="0" cellspacing="0" cellpadding="0">

<tr bgcolor="#EE8900">
    <td width="795" colspan="2" align="center" valign="top" style="padding-left:15px;"><p align="left"><font size="-2"><strong>Terms
        and Conditions of use</strong><br>

        The applications/code on this site are distributed as is and without warranties
        or liability. In no event shall the owner of the copyrights, or the authors
        of the applications/code be liable for any loss of profit, any problems
        or any damage resulting from the use or evaluation of the applications/code.
        </font><br>
      </p></td>


    </td>
  </tr><tr bgcolor="#EE8900"><td width="795" align="center">

<p align="center"> Copyright &copy; 2003 ExcelTip.com<br>
  Microsoft, Microsoft Excel is a U.S. registered trademark of Microsoft Corporation<br>

  Site Developed By: <a href="http://www.irubin.com/">Irubin Consulting</a></p><br>
  <a href="http://www.exceltip.com/financial_statements/1.htm"><img src="/images/transbg.gif" border="0" width="1" height="1"></a> <a href="http://www.exceltip.com/financial_statements/2.htm"><img src="/images/transbg.gif" border="0" width="1" height="1"></a> <a href="http://www.exceltip.com/financial_statements/3.htm"><img src="/images/transbg.gif" border="0" width="1" height="1"></a> <a href="http://www.exceltip.com/financial_statements/4.htm"><img src="/images/transbg.gif" border="0" width="1" height="1"></a> <a href="http://www.exceltip.com/financial_statements/5.htm"><img src="/images/transbg.gif" border="0" width="1" height="1"></a> <a href="http://www.exceltip.com/financial_statements/6.htm"><img src="/images/transbg.gif" border="0" width="1" height="1"></a> <a href="http://www.exceltip.com/financial_statements/7.htm"><img src="/images/transbg.gif" border="0" width="1" height="1"></a> <a href="http://www.exceltip.com/financial_statements/8.htm"><img src="/images/transbg.gif" border="0" width="1" height="1"></a> <a href="http://www.exceltip.com/financial_statements/9.htm"><img src="/images/transbg.gif" border="0" width="1" height="1"></a> <a href="http://www.exceltip.com/financial_statements/10.htm"><img src="/images/transbg.gif" border="0" width="1" height="1"></a> <a href="http://www.exceltip.com/financial_statements/11.htm"><img src="/images/transbg.gif" border="0" width="1" height="1"></a> <a href="http://www.exceltip.com/financial_statements/12.htm"><img src="/images/transbg.gif" border="0" width="1" height="1"></a> <a href="http://www.exceltip.com/financial_statements/13.htm"><img src="/images/transbg.gif" border="0" width="1" height="1"></a> <a href="http://www.exceltip.com/financial_statements/14.htm"><img src="/images/transbg.gif" border="0" width="1" height="1"></a> <a href="http://www.exceltip.com/financial_statements/15.htm"><img src="/images/transbg.gif" border="0" width="1" height="1"></a>
<a href="http://www.la-plasticsurgery.com/"><img src="/images/transbg.gif" border="0"></a>
<a href="http://www.epione-plasticsurgery.com/"><img src="/images/transbg.gif" border="0"></a>
<a href="http://www.wordforums.com/"><img src="/images/transbg.gif" border="0"></a>
<a href="http://www.msaccessforum.com/"><img src="/images/transbg.gif" border="0"></a>
<a href="http://www.powerpointforums.com/"><img src="/images/transbg.gif" border="0"></a>
<a href="http://www.outlookforum.com/"><img src="/images/transbg.gif" border="0"></a>
<a href="http://www.la-plasticsurgery.com/"><img src="/images/transbg.gif" width="1" height="1" border="0"></a>
<a href="http://www.epione-plasticsurgery.com/"><img src="/images/transbg.gif" width="1" height="1" border="0"></a>
<a href="http://www.breast-implants-augmentation.com/"><img src="/images/transbg.gif" width="1" height="1" border="0"></a>
<a href="http://www.botox411.com/"><img src="/images/transbg.gif" width="1" height="1" border="0"></a>
<a href="http://www.beverly-hills-breastaugmentation.com/"><img src="/images/transbg.gif" width="1" height="1" border="0"></a>
<a href="http://www.beverly-hills-breastimplant.com/"><img src="/images/transbg.gif" width="1" height="1" border="0"></a>
<a href="http://www.laser-hair-removal-bh.com/"><img src="/images/transbg.gif" width="1" height="1" border="0"></a>

<a href="http://www.excelforum.com/"><img src="/images/transbg.gif" border="0"></a>
<a href="/forum/index.php"><img src="/images/transbg.gif" border="0"></a>
<a href="http://www.rollators-walkers.com/"><img src="/images/transbg.gif" border="0"></a>
<a href="http://www.e-mobilityscooter.com/"><img src="/images/transbg.gif" border="0"></a>
<a href="http://www.excelbook.com/"><img src="/images/transbg.gif" border="0"></a>
<a href="http://www.exceltip.com/newsgroup/index.php"><img src="/images/transbg.gif" border="0"></a>
<a href="http://www.exceltip.com/se/1.html"><img src="/images/transbg.gif" border="0"></a>
<a href="http://www.exceltip.com/se/10.html"><img src="/images/transbg.gif" border="0"></a>
<a href="http://www.exceltip.com/se/11.html"><img src="/images/transbg.gif" border="0"></a> <a href="http://www.exceltip.com/se/12.html"><img src="/images/transbg.gif" border="0"></a> <a href="http://www.exceltip.com/se/13.html"><img src="/images/transbg.gif" border="0"></a> <a href="http://www.exceltip.com/se/14.html"><img src="/images/transbg.gif" border="0"></a> <a href="http://www.exceltip.com/se/15.html"><img src="/images/transbg.gif" border="0"></a> <a href="http://www.exceltip.com/se/16.html"><img src="/images/transbg.gif" border="0"></a> <a href="http://www.exceltip.com/se/17.html"><img src="/images/transbg.gif" border="0"></a> <a href="http://www.exceltip.com/se/18.html"><img src="/images/transbg.gif" border="0"></a> <a href="http://www.exceltip.com/se/19.html"><img src="/images/transbg.gif" border="0"></a> <a href="http://www.exceltip.com/se/2.html"><img src="/images/transbg.gif" border="0"></a> <a href="http://www.exceltip.com/se/20.html"><img src="/images/transbg.gif" border="0"></a> <a href="http://www.exceltip.com/se/21.html"><img src="/images/transbg.gif" border="0"></a> <a href="http://www.exceltip.com/se/22.html"><img src="/images/transbg.gif" border="0"></a> <a href="http://www.exceltip.com/se/23.html"><img src="/images/transbg.gif" border="0"></a> <a href="http://www.exceltip.com/se/24.html"><img src="/images/transbg.gif" border="0"></a> <a href="http://www.exceltip.com/se/25.html"><img src="/images/transbg.gif" border="0"></a> <a href="http://www.exceltip.com/se/26.html"><img src="/images/transbg.gif" border="0"></a> <a href="http://www.exceltip.com/se/27.html"><img src="/images/transbg.gif" border="0"></a> <a href="http://www.exceltip.com/se/28.html"><img src="/images/transbg.gif" border="0"></a> <a href="http://www.exceltip.com/se/3.html"><img src="/images/transbg.gif" border="0"></a> <a href="http://www.exceltip.com/se/4.html"><img src="/images/transbg.gif" border="0"></a> <a href="http://www.exceltip.com/se/5.html"><img src="/images/transbg.gif" border="0"></a> <a href="http://www.exceltip.com/se/6.html"><img src="/images/transbg.gif" border="0"></a> <a href="http://www.exceltip.com/se/7.html"><img src="/images/transbg.gif" border="0"></a> <a href="http://www.exceltip.com/se/8.html"><img src="/images/transbg.gif" border="0"></a> <a href="http://www.exceltip.com/se/9.html"><img src="/images/transbg.gif" border="0"></a> <a href="http://www.exceltip.com/se/front.html"><img src="/images/transbg.gif" border="0"></a> <a href="http://www.exceltip.com/se/functions.html"><img src="/images/transbg.gif" border="0"></a> <a href="http://www.exceltip.com/se/index.html"><img src="/images/transbg.gif" border="0"></a>
<a href="http://www.exceltip.com/se/trial_balance.html"><img src="/images/transbg.gif" border="0"></a>
<a href="http://www.exceltip.com/se/pivot_table.html"><img src="/images/transbg.gif" border="0"></a>
<a href="http://www.exceltip.com/se/balance_sheet.html"><img src="/images/transbg.gif" border="0"></a>
<a href="http://www.exceltip.com/ng-1.html"><img src="/images/transbg.gif" border="0"></a>
<a href="http://www.exceltip.com/se/excel_help.html"><img src="/images/transbg.gif" border="0"></a>
<a href="http://www.mobilitycare.com"><img src="/images/transbg.gif" border="0"></a>
<a href="http://www.exceltip.com/excel-g/threads.html"><img src="/images/transbg.gif" border="0"></a>
<a href="http://www.exceltip.com/excel-g/maillist.html"><img src="/images/transbg.gif" border="0"></a>
<a href="http://www.exceltip.com/excel-dev/threads.html"><img src="/images/transbg.gif" border="0"></a>
<a href="http://www.exceltip.com/excel-dev/maillist.html"><img src="/images/transbg.gif" border="0"></a>

<marquee width="1">excel help : excel : excel tips : microsoft excel : excel tutorial : excel template : excel formula : excel macro : excel help : excel password : vba excel : excel spreadsheet : excel tool : excel download : microsoft excel download : excel 2000 : excel visual basic : ms excel : excel tip : free download excel : microsoft excel tutorial : excel training : free excel template : microsoft excel help : free excel : excel password recovery : microsoft excel 97 : excel 2000 tutorial : excel 97 : excel center : excel downloads : excel recovery : excel software : excel pivot table : excel book</marquee>

</td></tr></table>


<!-- STATIC FOOTER END -->
</body>
<!-- InstanceEnd --></html>
