Guía de usuario de Ulet

Primeros pasos con Ulet para Mac.

Copy Formulas With Relative and Fixed References in Ulet on Mac

When several rows share a single multiplier, lock the multiplier cell so it stays fixed while the input row changes.

Write and fill the formula

  1. Put the shared multiplier 2 in G2. Put the quantities in column B.

  2. In E2, enter =B2*$G$2.

  3. Select E2:E4 and press Command+D to fill down.

The filled range starts with a formula that fixes the G2 reference.

The filled range starts with a formula that fixes the G2 reference.

Check the next row

Select E3 and inspect the formula bar. It should show =B3*$G$2. E4 should use B4 and the same G2. Save the workbook once both references are correct.

The filled formulas extend down the Cost column.

The filled formulas extend down the Cost column.

Related guide open and save an XLSX workbook.

Steps checked in the Mac desktop editor with a practice file, including saving and reopening. Screenshots show the Ulet editor; the test used an isolated profile and file-picker fixtures.

Ulet

Tu suite ofimática todo en uno para las tareas diarias.

Ver funciones