How to keep formula cell reference constant in Excel

preview_player
Показать описание
When you use relative cell reference in a formula, it will automatically adjust when you use the Fill Handle to apply it to a different location or copy and paste it to another cells. See below screenshot shows.
In many cases, you would like the cell reference staying constant rather than adjusting automatically. In this vedio, we will show you how to keep formula cell reference constant in Excel.
You can follow the step-by-step guide via the following hyperlink:
Рекомендации по теме
Комментарии
Автор

i guess im your first like. video really helped

lloydnyako