UpSlide has a number of features that are designed to save you time while building out complex financial models, including formula shortcuts and advanced paste options.
Advanced Paste
With the aim of saving you time when building models we have four advanced paste functions.
Preserve Formulas
Paste the exact same values and formulas as those from the source range. When copied, all original cell references from the source range will be maintained. Today you might copy the formula cell by cell directly from the formula bar. Our preserve formulas paste means you can copy and paste a whole range of unique formulas in one go.
For example you may want to replicate a total row of a table into multiple parts of your sheet/book whilst maintaining the original references so when the one source table has values change all the other parts of your sheet/book update as they reference that original table.
Shortcut: CTRL + ALT + P
Duplicate Formulas
Duplicate Formulas behaves like the native paste for references within the copied range (meaning all references within the source range will be adapted to the new range), but it preserves the absolute cell references for references outside of the copied range.
It can be used when wanting to compare multiple outputs when adjusting input variables. For example in a cash flow forecast applying and displaying the results with different discount rates applied.
Shortcut: CTRL + ALT + B
The gif below demonstrates the difference between Preserve and Duplicate Formulas.
Row Heights
Paste row heights of the copied range to the selected range.
Shortcut: CTRL + ALT + H
Number Formats Only
Paste the number formats only to preserve any other formatting present in the target range.
Shortcut: CTRL + ALT + F
Fast Fill Right/Down
Used to fill data when your models expand, our Fast Fill Right/Down functions are like the native Excel Fast Fill but they do not require you to preselect the destination range. UpSlide intelligently detects data surrounding the active cell to determine how far to fill.
With one cell selected, press:
- Ctrl + Alt + d for Fast Fill Down
- Ctrl + Alt + r for Fast Fill Right
Both options can also be found in the Formulas drop-down list in the UpSlide ribbon.
IfError
The IfError feature allows you to handle errors in your formulas by wrapping them in an IFERROR function.
To apply, simply:
- Highlight the target cells
- Click the down arrow next to Formulas in the UpSlide ribbon
- Select IfError from the drop-down menu (or press Ctrl + Shift + i)
- Type in an error value or message, and click OK
- An IFERROR function will be applied to each highlighted cell
If you click the IfError button on a range of cells that have already been wrapped, it will remove the IFERROR function.
The IfError feature ignores cells that do not have a formula and cells that have a formula with multiple IFERROR functions.
CAGR formula
Using the CAGR formula button, you can quickly apply a CAGR formula to a selected cell. The CAGR is computed using the formula below.
To use:
- Select the cell to which you would like to apply the formula
- Click the down arrow next to Formulas in the UpSlide ribbon
- Select CAGR from the drop-down menu (or press Ctrl + Shift + q)
- In the pop-up window, choose a data range and the period (Annual, Quarterly, or Monthly), and click OK
It's important to keep a few key things in mind when selecting the source data range. First, it must have only one dimension - the data must be in a single row or column. Second, it should contain at least two cells with numerical data. Finally, the data range must contain only blank or numerical cells.