This formula will return the name of the current worksheet: =MID(CELL("filename",INDIRECT("rc",)),FIND("]",CELL("filename",INDIRECT("rc",)))+1,255) Make sure that you've saved your file with a name other than Book1, otherwise the formula won't work. (Kenneth Lam got paid for submitting this tip. Learn how at www.acctadv.com/go.mv?id=tip.)

When copying a sheet full of formulas that refer to other worksheets and using paste special | transpose to place them in a new worksheet, the formulas reference incorrect cells. A simple trick is to use ctrl-h (replace) to change all the "=" signs to a benign value (such as AAAA or 9999), then copy and transpose. Once in the new worksheet, you can use the same process to change the 9999 back to = and all your formulas reference the right cells. (Rick Gray got paid for submitting this tip. Learn how at www.acctadv.com/go.mv?id=tip).

The Office Profile Wizard simplifies the process of transferring your Microsoft Office settings when you change computers. Two versions are available:
Office 2000 http://www.acctadv.com/go.mv?id=xl2kpw
Office XPhttp://www.acctadv.com/go.mv?id=xlxppw

You can use Excel's conditional formatting feature to highlight every other row in a spreadsheet, similar to the old-style green bar paper. To do so, select the portion of the spreadsheet that you wish to format, and then choose Format | Conditional Formatting. Change Cell Value Is to Formula Is and enter this formula:
=MOD(ROW(),2) <> 0
Click the Format button, and then under Patterns select the color of your choice. Click OK twice.

A free webcast that provides an overview of using Microsoft Excel for business intelligence is available from Microsoft at www.acctadv.com/go.mv?id=webcast. Topics include using pivot tables, pivot charts, and web-based analysis. You can also link to other free webcasts from this site.

The esteemed Excel book author John Walkenbach has published a review of Excel 2003. View it online at http://www.acctadv.com/go.mv?id=xl2003wr.

To create a workbook where the first page summarizes the rest of the workbook, make sure that your workbook has at least 4 sheets. Name the second sheet Start and the last sheet End. Hide these two sheets, which should left be blank. On the first sheet, the formula =SUM(Start:End!B2) will sum cell B2 on all other sheets in the workbook. Additional sheets inserted later will automatically be included in the summary. (Thanks to Brian Volk, who got paid for submitting this tip! Learn how.

Copy a range of cells to the clipboard, then hold the Shift key and click the Edit menu. Click the Paste Picture Link. (This option is not available unless you hold the Shift key) This creates a picture that is linked to the cells you copied. You can move this picture around as you would a graphic. The picture updates automatically when you change the related cells. This is a helpful way to combine data from multiple locations on to a single sheet, particularly for printing purposes. (Neale Blackwood got paid for this tip. Learn how.

To easily navigate between worksheets, press Ctrl+Page Up to move to the right, or Ctrl+Page Down to move to the left. (Girish Dinakaran got paid for submitting this tip! Learn How

To alter the font or color of any part of a cell, use the Formula Bar at the top of the screen to highlight a portion of the text within a cell. Next, click Format, and then Cells. You can use Font tab to change the font or apply characteristics such as superscript/subscript, underlining, bold, or color.