Excel Tips
Repeat Top Row in All Printed Pages »
May 25, 2003
How to make top row appear at the top of each page when printing out the spreadsheet.
May 24, 2003
How to have cell A1 correspond with 3 rows in column B by merging cells.
December 17, 2002
You've just built a pivot table in Excel. You click outside of the pivot table. You build an Excel formula. You copy this formula down to all of the rows in the pivot table. The calculation reports the wrong answer for all but the first row of the pivot table.
December 10, 2002
Microsoft says that you can now store data as XML and easily re-purpose the data. Open the same data file and it looks one way in Excel, open the data file and it looks another way in Word. It is very powerful.
December 3, 2002
Trying to create a timeline by using timeline options in the chart wizard, but unfortunately, they did not look too appealing.
November 26, 2002
Is there a way to print a table of contents based on Excel worksheet names so I can quickly turn to page #xx?
Suppress Rows While Printing »
November 19, 2002
I don't want to hide the rows, I just want to suppress their printing in Excel.
November 12, 2002
I build a monthly transaction list in Excel. At the end of the month, I need to eliminate the redundant data and come up with a total by account code.
Small Business Financial Manager »
November 5, 2002
If you are a small business owner using Quickbooks or Peachtree, you owe it to yourself to take an hour to experiment with this tool. It is called the Small Business Financial Manager.