Logo

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

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

Find all your HP/HPE-related stock – and estimate cost basis: Stock   Map of stock topics on this site

This complex topic requires a PC, Mac, Chromebook, or large-screen tablet.

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?".  


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.

Note: Personal situations vary. Laws and regulations change – and may vary by state. Business practices change. The information on this website is provided as a service to the community, and does not constitute financial, legal, medical, or personal advice. By using this site you accept these terms.