Tips and Tricks

Useful Keyboard Shortcuts

Useful Standard Numbers Shortcuts

Add rows to a table: press Return while having a cell selected in the last available row.

Paste Formula Results: Shift - ⌘ - V

Paste and Match Style: Shift -Option- ⌘ - V

Insert Current Date & Time: Control - Shift - Command - T

Unlock an element: Option - ⌘ - L

Lock an element: ⌘ - L

Highlight the row and column for a cell: Press Option as you move over a cell

Numbers has shortcuts for just about anything.

Add Rows to Tables

There might be time when you need to add some rows to the different tables of our tools.

The best way to add rows to a table with preserving the formulas is to simply select a cell in the last row, then press Return.

Example:

I need more rows in the Snapshots table. I select a cell in the last available row (excluding the footer), and simply hit enter.

Adding rows to the Snapshot Table

Pasting Data into the Portfolio Tracker

Most often, when pasting values into the smol Portfolio Tracker, you will either want to Paste and Match Style or Paste Formula Results. We recommend you learn the shortcuts for both as it will speed things up for you.

Paste Formula Results: Shift - ⌘ - V

When making a snapshot by copying and pasting the "Current Values" in the Snapshot table, you want to Paste Formula Results, since it is the values (the "results") you want to paste and not the formula itself.

Pasting Formula Results

Paste and Match Style: Shift -Option- ⌘ - V

If you just want to paste values you have copied either from a previous version of the smol Portfolio Tracker, or from some other source, using Paste and Match Style will paste these values while retaining the style defined by the color theme you have chosen.

Annual Reset

For more active traders, we recommend archiving your Portfolio Tracker at and starting each new year with a fresh copy.

For each asset you still owned at EOY, enter a BUY entry in the new copy of the Portfolio Tracker, with the quantity you own and using your current "Cost / Unit" as the price.

Performing this reset can help keep things snappy and running smoothly if you have hundreds or thousands of trades in your accounts. It's also great records-keeping as each tax year will be neatly and conveniently archived and separated from others. The "Realized P&L" on the Dashboard and on the Top Line Stats of each account will then give you the realized profits and losses only for the ongoing tax year, while your total Portfolio's P&L will account for the whole appreciation or depreciation of your portfolio across years.

A Note on Plumbing

The Portfolio Tracker has a number of hidden columns performing important calculations in the background. These columns, though hidden by default, are generally bright purple and labeled "Plumbing", so you'll know right away if you've accidentally unhid some of them and you'll be able to easily identify them if you are making some customizations to the Tracker . You can keep them hidden, but beware that deleting them will affect the functionality of the Tracker!

Example of normally hidden "Plumbing" columns differentiated by the color purple.

Last updated

Was this helpful?