Logo

Index   WFR/Leaving   Contacts   Benefits   Medicare   Stock   Pension   Working   HP/HPE   Join

Not officially endorsed or supported. Keep up with HP/HPE-related stock issues: Join HPAA at no charge.

Start here: Stock    All articles on stock: Stock Menu

6c. Excel tips  (Apr 12, 2018.)  Question? Email: info@hpalumni.org

Website operated by volunteers. Not officially endorsed or supported. Question? Email: info@hpalumni.org

Tips for using the complex spreadsheets, such as the HPAA Stock Cost Basis Spreadsheets

To see how a formula works. How to graphically display the relationships between cells and formulas with tracer arrows. Microsoft on tracing precedents

Unfreezing for printing. Some worksheets have top rows and left columns frozen for ease of reading and entering data. You may want to unfreeze. View > Freeze Panes.  Microsoft on freezing and unfreezing panes.

Printing part of a worksheet. Select the "Page Layout" tab and then click the "Print Area" button in the "Page Setup" group.  Microsoft on setting and clearing the print area.

If you don't see a row of tabs along the bottom edge of the HPAA Cost Basis spreadsheets, you may have the window sized in such a way that the tabs are hidden. Microsoft on "Where are my tabs?".  

Disclaimer. The information contained in this website, or sites linked to it, is provided as a service to the community, and does not constitute financial, legal, or personal advice. We make no claims, promises or guarantees about the accuracy, completeness, or adequacy of the information contained in or linked to this website and associated sites. As financial, legal, and personal advice must be tailored to the specific circumstances of each case, and finances and laws are constantly changing, nothing provided here should be used as a substitute for the personal advice of competent financial, legal, and personal advisors.

Helping each other with life after HP and HPE:  Website Index    Forums

Independent, member-supported volunteer association. Not officially endorsed or supported. © 2024 Hewlett-Packard Alumni Association, Inc. By using this site you accept these terms.