Excel Tips


Using Excel Macro Recorder »

May 28, 2003

How to use macro recorder to write my own routine to automate what I need.


Freezing Rows in Excel »

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.


Merge Cells in Excel »

May 24, 2003

How to have cell A1 correspond with 3 rows in column B by merging cells.


GetPivotData in Excel »

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.


Using XML In Excel »

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.


Timeline Chart In Excel »

December 3, 2002

Trying to create a timeline by using timeline options in the chart wizard, but unfortunately, they did not look too appealing.


Table Of Contents Macro »

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.