Excel Tips


How to Reverse the Sign on a Difference »

May 24, 2002

How to reverse the Sign on a difference.


Use Index and Match to Lookup a Cell to the Left of Key Cell »

May 23, 2002

How to use Index and Match to lookup a cell to the left of key cell


Change the Worksheet Tabname to Reflect the Value in a Cell »

May 22, 2002

Is it possible to change the worksheet tabname to reflect the value in a cell?


Greenbar Formatting In Excel »

May 21, 2002

If you are over a certain age, you will remember when all computer reports were produced by the MIS department using COBOL and a high-speed IBM Line Printer. These reports always printed on paper called "Greenbar".


Formula to Point Always the Same Column »

May 21, 2002

Formula to point always the same column but is free to move to different rows as it is copied.


Freeze the Headers »

May 21, 2002

How to freeze the headers.


Convert 11.5 to 11 Minutes and 30 Seconds »

May 20, 2002

If I have 11.5 in a cell how do I get this converted to 11 minutes and 30 seconds in another cell?


ActiveCell instead Named Range »

May 20, 2002

How to change the macro so it writes the data to the active cell rather than a named one.


Run a Macro Automatically When the Workbook Opens »

May 19, 2002

How to get a macro to run automatically when the user opens a workbook.