Faq/Calc/108

From The Document Foundation Wiki
< Faq‎ | Calc
Jump to: navigation, search

Template:TopMenu/en Template:Menu/en Template:Menu.Documentation/en Template:Menu.FAQ/en

Other languages:
dansk • ‎English • ‎français • ‎русский


How to convert relative to absolute coordinates quickly (effectively adding a '$')

When you type a formula, after having entered the coordinates (using keyboard or mouse), press F4.

Each press on this combination toggles the presence or absence of the '$' for the row, the column and, where appropriate, the sheet.