English Deutsch Français Italiano Español Português 繁體中文 Bahasa Indonesia Tiếng Việt ภาษาไทย
All categories
4 ⤊

How do I keep a formula or part of a formula relating to one same cell in Excel?

2007-05-29 12:45:00 · 1 answers · asked by Lochan 1 in Computers & Internet ➔ Software

1 answers

Use a dollar sign
$A$1 will keep the column and row static.
$A1 will keep the column static, row dynamic
A$1 will keep the column dynamic, row static
A1 will keep the column and row dynamic

2007-05-29 12:50:46 · answer #1 · answered by wade_jacksone 2 · 4⤊ 0⤋

fedest.com, questions and answers