Excel Tips

Summarize Data with Pivot Table »

February 9, 2002

How to summarize data with pivot table.

Setting Cell Font with VBA »

February 8, 2002

How to set cells font with VBA.

Validating Inputbox Entry »

February 7, 2002

How to validate inputbox entry by using macro.

Maximized View in Open »

February 6, 2002

How can I make sure Excel opens my file maximized?

Excel Autoshapes »

February 5, 2002

Free Drawing 98 application from Microsoft to jazz up the drawing toolbar with 139 easy to use symbols for Excel.

Find and Remove Strings »

February 5, 2002

Is there any way I can simply remove certain characters from a text string?

Switching Between Active Worksheets »

February 4, 2002

Are there any hotkeys for switching between spreadsheet to spreadsheet?

Using the Analysis Toolpack »

February 3, 2002

My colleagues can use the XIRR function, but it does not appear to be available in my version of Excel.

Differences in Excel Versions »

February 2, 2002

Microsoft is pretty good about making sure that features from one version work in the next version.