Excel Tips
May 28, 2003
How to use macro recorder to write my own routine to automate what I need.
May 27, 2003
Freezing panes in Excel to see the top row as heading when scrolling.
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.