6c. Tips for using the complex spreadsheets  

Part of our process to find stock and estimate cost basis. Start here: Stock Step-by-Step    (Not officially endorsed or supported.)

(Apr 12, 2018.)  Click to join the HPAA   Question? Email us: 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?".  

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